FreeStatistics.org

Free Statistics

of Irreproducible Research!

Description of Statistical Computation

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_twosampletests_mean.wasp
Title produced by softwarePaired and Unpaired Two Samples Tests about the Mean
Date of computationFri, 12 Dec 2014 20:40:29 +0000
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2014/Dec/12/t1418416888k0yq32jqzdxedg2.htm/, Retrieved Thu, 16 May 2024 21:50:53 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=266883, Retrieved Thu, 16 May 2024 21:50:53 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact77

Tree of Dependent Computations

Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Paired and Unpaired Two Samples Tests about the Mean] [] [2014-12-12 20:40:29] [2493f5613ad82cc6ad9068825c65e4dc] [Current]
Feedback Forum

Post a new message

Dataset

Dataseries X:
Download CSV
Histogram
Boxplots 
26	NA
37	NA
67	NA
43	NA
52	NA
52	NA
43	NA
84	NA
67	NA
49	NA
70	NA
58	NA
68	NA
NA	62
43	NA
56	NA
74	NA
63	NA
58	NA
63	NA
53	NA
NA	57
64	NA
53	NA
29	NA
54	NA
58	NA
51	NA
54	NA
NA	56
47	NA
50	NA
35	NA
NA	30
68	NA
NA	56
43	NA
NA	67
62	NA
57	NA
54	NA
61	NA
56	NA
41	NA
53	NA
46	NA
51	NA
37	NA
42	NA
NA	38
66	NA
53	NA
NA	49
NA	49
NA	59
NA	40
NA	63
NA	34
NA	32
NA	67
NA	61
NA	60
NA	63
52	NA
16	NA
46	NA
56	NA
NA	52
NA	55
50	NA
59	NA
60	NA
52	NA
44	NA
67	NA
52	NA
55	NA
37	NA
54	NA
NA	72
51	NA
48	NA
60	NA
50	NA
63	NA
33	NA
67	NA
46	NA
54	NA
59	NA
61	NA
NA	33
47	NA
69	NA
52	NA
55	NA
41	NA
73	NA
52	NA
50	NA
51	NA
60	NA
56	NA
56	NA
29	NA
NA	66
NA	66
73	NA
55	NA
NA	64
NA	40
NA	46
NA	58
43	NA
61	NA
NA	51
NA	50
NA	52
NA	54
NA	66
NA	61
NA	80
NA	51
NA	56
56	NA
56	NA
NA	53
47	NA
25	NA
NA	47
46	NA
NA	50
NA	39
51	NA
NA	58
NA	35
NA	58
NA	60
NA	62
NA	63
NA	53
NA	46
NA	67
NA	59
NA	64
NA	38
NA	50
48	NA
NA	48
NA	47
NA	66
47	NA
NA	63
58	NA
NA	44
51	NA
NA	43
55	NA
NA	38
NA	45
NA	50
NA	54
57	NA
60	NA
NA	55
56	NA
49	NA
NA	37
59	NA
NA	46
NA	51
58	NA
NA	64
53	NA
48	NA
51	NA
NA	47
59	NA
NA	62
62	NA
51	NA
64	NA
52	NA
NA	67
50	NA
54	NA
58	NA
NA	56
63	NA
31	NA
NA	65
71	NA
NA	50
NA	57
NA	47
NA	47
NA	57
43	NA
41	NA
63	NA
63	NA
56	NA
51	NA
NA	50
NA	22
41	NA
NA	59
NA	56
66	NA
NA	53
NA	42
NA	52
NA	54
NA	44
NA	62
NA	53
NA	50
NA	36
NA	76
NA	66
NA	62
NA	59
NA	47
NA	55
NA	58
NA	60
44	NA
NA	57
NA	45

Tables (Output of Computation)





Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time1 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 1 seconds \tabularnewline
R Server & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=266883&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]1 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Herman Ole Andreas Wold' @ wold.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=266883&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=266883&T=0

As an alternative you can also use a QR Code:  
QR Code


The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time1 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net






Two Sample t-test (unpaired)
Mean of Sample 153.0708661417323
Mean of Sample 253.3529411764706
t-stat-0.200411775858567
df227
p-value0.841337986866066
H0 value0
Alternativetwo.sided
CI Level0.95
CI[-3.05546623817829,2.49131616870168]
F-test to compare two variances
F-stat1.05728365870095
df126
p-value0.774111809740934
H0 value1
Alternativetwo.sided
CI Level0.95
CI[0.725963345400641,1.52797681508201]

\begin{tabular}{lllllllll}
\hline
Two Sample t-test (unpaired) \tabularnewline
Mean of Sample 1 & 53.0708661417323 \tabularnewline
Mean of Sample 2 & 53.3529411764706 \tabularnewline
t-stat & -0.200411775858567 \tabularnewline
df & 227 \tabularnewline
p-value & 0.841337986866066 \tabularnewline
H0 value & 0 \tabularnewline
Alternative & two.sided \tabularnewline
CI Level & 0.95 \tabularnewline
CI & [-3.05546623817829,2.49131616870168] \tabularnewline
F-test to compare two variances \tabularnewline
F-stat & 1.05728365870095 \tabularnewline
df & 126 \tabularnewline
p-value & 0.774111809740934 \tabularnewline
H0 value & 1 \tabularnewline
Alternative & two.sided \tabularnewline
CI Level & 0.95 \tabularnewline
CI & [0.725963345400641,1.52797681508201] \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=266883&T=1

[TABLE]
[ROW][C]Two Sample t-test (unpaired)[/C][/ROW]
[ROW][C]Mean of Sample 1[/C][C]53.0708661417323[/C][/ROW]
[ROW][C]Mean of Sample 2[/C][C]53.3529411764706[/C][/ROW]
[ROW][C]t-stat[/C][C]-0.200411775858567[/C][/ROW]
[ROW][C]df[/C][C]227[/C][/ROW]
[ROW][C]p-value[/C][C]0.841337986866066[/C][/ROW]
[ROW][C]H0 value[/C][C]0[/C][/ROW]
[ROW][C]Alternative[/C][C]two.sided[/C][/ROW]
[ROW][C]CI Level[/C][C]0.95[/C][/ROW]
[ROW][C]CI[/C][C][-3.05546623817829,2.49131616870168][/C][/ROW]
[ROW][C]F-test to compare two variances[/C][/ROW]
[ROW][C]F-stat[/C][C]1.05728365870095[/C][/ROW]
[ROW][C]df[/C][C]126[/C][/ROW]
[ROW][C]p-value[/C][C]0.774111809740934[/C][/ROW]
[ROW][C]H0 value[/C][C]1[/C][/ROW]
[ROW][C]Alternative[/C][C]two.sided[/C][/ROW]
[ROW][C]CI Level[/C][C]0.95[/C][/ROW]
[ROW][C]CI[/C][C][0.725963345400641,1.52797681508201][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=266883&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=266883&T=1

As an alternative you can also use a QR Code:  
QR Code


The GUIDs for individual cells are displayed in the table below:

Two Sample t-test (unpaired)
Mean of Sample 153.0708661417323
Mean of Sample 253.3529411764706
t-stat-0.200411775858567
df227
p-value0.841337986866066
H0 value0
Alternativetwo.sided
CI Level0.95
CI[-3.05546623817829,2.49131616870168]
F-test to compare two variances
F-stat1.05728365870095
df126
p-value0.774111809740934
H0 value1
Alternativetwo.sided
CI Level0.95
CI[0.725963345400641,1.52797681508201]






Welch Two Sample t-test (unpaired)
Mean of Sample 153.0708661417323
Mean of Sample 253.3529411764706
t-stat-0.201024594554506
df218.85794474088
p-value0.84086604103749
H0 value0
Alternativetwo.sided
CI Level0.95
CI[-3.04756302062062,2.48341295114401]

\begin{tabular}{lllllllll}
\hline
Welch Two Sample t-test (unpaired) \tabularnewline
Mean of Sample 1 & 53.0708661417323 \tabularnewline
Mean of Sample 2 & 53.3529411764706 \tabularnewline
t-stat & -0.201024594554506 \tabularnewline
df & 218.85794474088 \tabularnewline
p-value & 0.84086604103749 \tabularnewline
H0 value & 0 \tabularnewline
Alternative & two.sided \tabularnewline
CI Level & 0.95 \tabularnewline
CI & [-3.04756302062062,2.48341295114401] \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=266883&T=2

[TABLE]
[ROW][C]Welch Two Sample t-test (unpaired)[/C][/ROW]
[ROW][C]Mean of Sample 1[/C][C]53.0708661417323[/C][/ROW]
[ROW][C]Mean of Sample 2[/C][C]53.3529411764706[/C][/ROW]
[ROW][C]t-stat[/C][C]-0.201024594554506[/C][/ROW]
[ROW][C]df[/C][C]218.85794474088[/C][/ROW]
[ROW][C]p-value[/C][C]0.84086604103749[/C][/ROW]
[ROW][C]H0 value[/C][C]0[/C][/ROW]
[ROW][C]Alternative[/C][C]two.sided[/C][/ROW]
[ROW][C]CI Level[/C][C]0.95[/C][/ROW]
[ROW][C]CI[/C][C][-3.04756302062062,2.48341295114401][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=266883&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=266883&T=2

As an alternative you can also use a QR Code:  
QR Code


The GUIDs for individual cells are displayed in the table below:

Welch Two Sample t-test (unpaired)
Mean of Sample 153.0708661417323
Mean of Sample 253.3529411764706
t-stat-0.201024594554506
df218.85794474088
p-value0.84086604103749
H0 value0
Alternativetwo.sided
CI Level0.95
CI[-3.04756302062062,2.48341295114401]






Wicoxon rank sum test with continuity correction (unpaired)
W6365
p-value0.82282296001488
H0 value0
Alternativetwo.sided
Kolmogorov-Smirnov Test to compare Distributions of two Samples
KS Statistic0.0653080129689671
p-value0.969300959080211
Kolmogorov-Smirnov Test to compare Distributional Shape of two Samples
KS Statistic0.0910143584993052
p-value0.736806181852539

\begin{tabular}{lllllllll}
\hline
Wicoxon rank sum test with continuity correction (unpaired) \tabularnewline
W & 6365 \tabularnewline
p-value & 0.82282296001488 \tabularnewline
H0 value & 0 \tabularnewline
Alternative & two.sided \tabularnewline
Kolmogorov-Smirnov Test to compare Distributions of two Samples \tabularnewline
KS Statistic & 0.0653080129689671 \tabularnewline
p-value & 0.969300959080211 \tabularnewline
Kolmogorov-Smirnov Test to compare Distributional Shape of two Samples \tabularnewline
KS Statistic & 0.0910143584993052 \tabularnewline
p-value & 0.736806181852539 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=266883&T=3

[TABLE]
[ROW][C]Wicoxon rank sum test with continuity correction (unpaired)[/C][/ROW]
[ROW][C]W[/C][C]6365[/C][/ROW]
[ROW][C]p-value[/C][C]0.82282296001488[/C][/ROW]
[ROW][C]H0 value[/C][C]0[/C][/ROW]
[ROW][C]Alternative[/C][C]two.sided[/C][/ROW]
[ROW][C]Kolmogorov-Smirnov Test to compare Distributions of two Samples[/C][/ROW]
[ROW][C]KS Statistic[/C][C]0.0653080129689671[/C][/ROW]
[ROW][C]p-value[/C][C]0.969300959080211[/C][/ROW]
[ROW][C]Kolmogorov-Smirnov Test to compare Distributional Shape of two Samples[/C][/ROW]
[ROW][C]KS Statistic[/C][C]0.0910143584993052[/C][/ROW]
[ROW][C]p-value[/C][C]0.736806181852539[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=266883&T=3

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=266883&T=3

As an alternative you can also use a QR Code:  
QR Code


The GUIDs for individual cells are displayed in the table below:

Wicoxon rank sum test with continuity correction (unpaired)
W6365
p-value0.82282296001488
H0 value0
Alternativetwo.sided
Kolmogorov-Smirnov Test to compare Distributions of two Samples
KS Statistic0.0653080129689671
p-value0.969300959080211
Kolmogorov-Smirnov Test to compare Distributional Shape of two Samples
KS Statistic0.0910143584993052
p-value0.736806181852539


Figures (Output of Computation)

Input Parameters & R Code

Parameters (Session):
par1 = 1 ; par2 = 2 ; par3 = 0.95 ; par4 = two.sided ; par5 = unpaired ; par6 = 0.0 ;
Parameters (R input):
par1 = 1 ; par2 = 2 ; par3 = 0.95 ; par4 = two.sided ; par5 = unpaired ; par6 = 0.0 ;
R code (references can be found in the software module):
par1 <- as.numeric(par1) #column number of first sample
par2 <- as.numeric(par2) #column number of second sample
par3 <- as.numeric(par3) #confidence (= 1 - alpha)
if (par5 == 'unpaired') paired <- FALSE else paired <- TRUE
par6 <- as.numeric(par6) #H0
z <- t(y)
if (par1 == par2) stop('Please, select two different column numbers')
if (par1 < 1) stop('Please, select a column number greater than zero for the first sample')
if (par2 < 1) stop('Please, select a column number greater than zero for the second sample')
if (par1 > length(z[1,])) stop('The column number for the first sample should be smaller')
if (par2 > length(z[1,])) stop('The column number for the second sample should be smaller')
if (par3 <= 0) stop('The confidence level should be larger than zero')
if (par3 >= 1) stop('The confidence level should be smaller than zero')
(r.t <- t.test(z[,par1],z[,par2],var.equal=TRUE,alternative=par4,paired=paired,mu=par6,conf.level=par3))
(v.t <- var.test(z[,par1],z[,par2],conf.level=par3))
(r.w <- t.test(z[,par1],z[,par2],var.equal=FALSE,alternative=par4,paired=paired,mu=par6,conf.level=par3))
(w.t <- wilcox.test(z[,par1],z[,par2],alternative=par4,paired=paired,mu=par6,conf.level=par3))
(ks.t <- ks.test(z[,par1],z[,par2],alternative=par4))
m1 <- mean(z[,par1],na.rm=T)
m2 <- mean(z[,par2],na.rm=T)
mdiff <- m1 - m2
newsam1 <- z[!is.na(z[,par1]),par1]
newsam2 <- z[,par2]+mdiff
newsam2 <- newsam2[!is.na(newsam2)]
(ks1.t <- ks.test(newsam1,newsam2,alternative=par4))
mydf <- data.frame(cbind(z[,par1],z[,par2]))
colnames(mydf) <- c('Variable 1','Variable 2')
bitmap(file='test1.png')
boxplot(mydf, notch=TRUE, ylab='value',main=main)
dev.off()
bitmap(file='test2.png')
qqnorm(z[,par1],main='Normal QQplot - Variable 1')
qqline(z[,par1])
dev.off()
bitmap(file='test3.png')
qqnorm(z[,par2],main='Normal QQplot - Variable 2')
qqline(z[,par2])
dev.off()
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,paste('Two Sample t-test (',par5,')',sep=''),2,TRUE)
a<-table.row.end(a)
if(!paired){
a<-table.row.start(a)
a<-table.element(a,'Mean of Sample 1',header=TRUE)
a<-table.element(a,r.t$estimate[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Mean of Sample 2',header=TRUE)
a<-table.element(a,r.t$estimate[[2]])
a<-table.row.end(a)
} else {
a<-table.row.start(a)
a<-table.element(a,'Difference: Mean1 - Mean2',header=TRUE)
a<-table.element(a,r.t$estimate)
a<-table.row.end(a)
}
a<-table.row.start(a)
a<-table.element(a,'t-stat',header=TRUE)
a<-table.element(a,r.t$statistic[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'df',header=TRUE)
a<-table.element(a,r.t$parameter[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-value',header=TRUE)
a<-table.element(a,r.t$p.value)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'H0 value',header=TRUE)
a<-table.element(a,r.t$null.value[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Alternative',header=TRUE)
a<-table.element(a,r.t$alternative)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'CI Level',header=TRUE)
a<-table.element(a,attr(r.t$conf.int,'conf.level'))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'CI',header=TRUE)
a<-table.element(a,paste('[',r.t$conf.int[1],',',r.t$conf.int[2],']',sep=''))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'F-test to compare two variances',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'F-stat',header=TRUE)
a<-table.element(a,v.t$statistic[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'df',header=TRUE)
a<-table.element(a,v.t$parameter[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-value',header=TRUE)
a<-table.element(a,v.t$p.value)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'H0 value',header=TRUE)
a<-table.element(a,v.t$null.value[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Alternative',header=TRUE)
a<-table.element(a,v.t$alternative)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'CI Level',header=TRUE)
a<-table.element(a,attr(v.t$conf.int,'conf.level'))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'CI',header=TRUE)
a<-table.element(a,paste('[',v.t$conf.int[1],',',v.t$conf.int[2],']',sep=''))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,paste('Welch Two Sample t-test (',par5,')',sep=''),2,TRUE)
a<-table.row.end(a)
if(!paired){
a<-table.row.start(a)
a<-table.element(a,'Mean of Sample 1',header=TRUE)
a<-table.element(a,r.w$estimate[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Mean of Sample 2',header=TRUE)
a<-table.element(a,r.w$estimate[[2]])
a<-table.row.end(a)
} else {
a<-table.row.start(a)
a<-table.element(a,'Difference: Mean1 - Mean2',header=TRUE)
a<-table.element(a,r.w$estimate)
a<-table.row.end(a)
}
a<-table.row.start(a)
a<-table.element(a,'t-stat',header=TRUE)
a<-table.element(a,r.w$statistic[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'df',header=TRUE)
a<-table.element(a,r.w$parameter[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-value',header=TRUE)
a<-table.element(a,r.w$p.value)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'H0 value',header=TRUE)
a<-table.element(a,r.w$null.value[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Alternative',header=TRUE)
a<-table.element(a,r.w$alternative)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'CI Level',header=TRUE)
a<-table.element(a,attr(r.w$conf.int,'conf.level'))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'CI',header=TRUE)
a<-table.element(a,paste('[',r.w$conf.int[1],',',r.w$conf.int[2],']',sep=''))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,paste('Wicoxon rank sum test with continuity correction (',par5,')',sep=''),2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'W',header=TRUE)
a<-table.element(a,w.t$statistic[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-value',header=TRUE)
a<-table.element(a,w.t$p.value)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'H0 value',header=TRUE)
a<-table.element(a,w.t$null.value[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Alternative',header=TRUE)
a<-table.element(a,w.t$alternative)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Kolmogorov-Smirnov Test to compare Distributions of two Samples',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'KS Statistic',header=TRUE)
a<-table.element(a,ks.t$statistic[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-value',header=TRUE)
a<-table.element(a,ks.t$p.value)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Kolmogorov-Smirnov Test to compare Distributional Shape of two Samples',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'KS Statistic',header=TRUE)
a<-table.element(a,ks1.t$statistic[[1]])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-value',header=TRUE)
a<-table.element(a,ks1.t$p.value)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable2.tab')