Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_arimabackwardselection.wasp
Title produced by softwareARIMA Backward Selection
Date of computationTue, 20 Dec 2011 17:46:18 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/20/t1324421217j5z2sy153ewgibm.htm/, Retrieved Mon, 06 May 2024 02:25:05 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158331, Retrieved Mon, 06 May 2024 02:25:05 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact156
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Univariate Data Series] [data set] [2008-12-01 19:54:57] [b98453cac15ba1066b407e146608df68]
- RMP   [Standard Deviation-Mean Plot] [Unemployment] [2010-11-29 10:34:47] [b98453cac15ba1066b407e146608df68]
- R PD    [Standard Deviation-Mean Plot] [WS9 3.2 SMP] [2010-12-07 14:36:57] [afe9379cca749d06b3d6872e02cc47ed]
- R  D      [Standard Deviation-Mean Plot] [] [2011-12-04 11:12:53] [ec2187f7727da5d5d939740b21b8b68a]
- RMP         [ARIMA Backward Selection] [] [2011-12-04 16:51:18] [ec2187f7727da5d5d939740b21b8b68a]
-   PD            [ARIMA Backward Selection] [] [2011-12-20 22:46:18] [542c32830549043c4555f1bd78aefedb] [Current]
-   P               [ARIMA Backward Selection] [] [2011-12-21 15:44:35] [ec2187f7727da5d5d939740b21b8b68a]
- RMP               [ARIMA Forecasting] [] [2011-12-21 16:14:33] [ec2187f7727da5d5d939740b21b8b68a]
Feedback Forum

Post a new message
Dataseries X:
90604
97527
111940
100280
100009
95558
98533
92694
97920
110933
110855
111716
96348
105425
114874
104199
101166
99010
101607
97492
106088
113536
112475
115491
97733
102591
114783
100397
97772
96128
91261
90686
97792
108848
109989
109453
93945
98750
119043
104776
103262
106735
101600
99358
105240
114079
121637
111747
99496
104992
124255
108258
106940
104939
105896
107287
110783
122139
125823
120480
103296
117121
129924
118589
118062
113597
117161
112893
119657
136562
140446
138744
120324
118113
130257
125510
117986
118316
122075
117573
122566
135934
138394
137999
118780
117907
142932
132200
125666
127958
127718
124368
135241
144734
142320
141481
120471
123422
145829
134572
132156
140265
137771
134035
144016
151905
155791
148440
129862
134264
151952
143191
137242
136993
134431
132523
133486
140120
137521
112193
94256
99047
109761
102160
104792
104341
112430
113034
114197
127876
135199
123663
112578
117104
139703
114961
134222
128390
134197
135963
135936
146803
143231
131510




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time8 seconds
R Server'AstonUniversity' @ aston.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 & 8 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158331&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]8 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158331&T=0

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

As an alternative you can also use a 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 time8 seconds
R Server'AstonUniversity' @ aston.wessa.net







ARIMA Parameter Estimation and Backward Selection
Iterationar1ar2ar3ma1sar1sar2sma1
Estimates ( 1 )-0.27290.14510.26740.03640.1808-0.0852-0.7295
(p-val)(0.2745 )(0.1683 )(0.0026 )(0.8867 )(0.3156 )(0.5236 )(0 )
Estimates ( 2 )-0.24010.15170.264700.1785-0.0838-0.7274
(p-val)(0.0115 )(0.103 )(0.0026 )(NA )(0.3204 )(0.5308 )(0 )
Estimates ( 3 )-0.25470.14340.269600.22030-0.7845
(p-val)(0.0049 )(0.1164 )(0.0019 )(NA )(0.1744 )(NA )(0 )
Estimates ( 4 )-0.29780.10410.2876000-0.6346
(p-val)(5e-04 )(0.2352 )(7e-04 )(NA )(NA )(NA )(0 )
Estimates ( 5 )-0.325600.259000-0.6357
(p-val)(1e-04 )(NA )(0.0015 )(NA )(NA )(NA )(0 )
Estimates ( 6 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 7 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 8 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 9 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 10 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 11 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 12 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 13 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )

\begin{tabular}{lllllllll}
\hline
ARIMA Parameter Estimation and Backward Selection \tabularnewline
Iteration & ar1 & ar2 & ar3 & ma1 & sar1 & sar2 & sma1 \tabularnewline
Estimates ( 1 ) & -0.2729 & 0.1451 & 0.2674 & 0.0364 & 0.1808 & -0.0852 & -0.7295 \tabularnewline
(p-val) & (0.2745 ) & (0.1683 ) & (0.0026 ) & (0.8867 ) & (0.3156 ) & (0.5236 ) & (0 ) \tabularnewline
Estimates ( 2 ) & -0.2401 & 0.1517 & 0.2647 & 0 & 0.1785 & -0.0838 & -0.7274 \tabularnewline
(p-val) & (0.0115 ) & (0.103 ) & (0.0026 ) & (NA ) & (0.3204 ) & (0.5308 ) & (0 ) \tabularnewline
Estimates ( 3 ) & -0.2547 & 0.1434 & 0.2696 & 0 & 0.2203 & 0 & -0.7845 \tabularnewline
(p-val) & (0.0049 ) & (0.1164 ) & (0.0019 ) & (NA ) & (0.1744 ) & (NA ) & (0 ) \tabularnewline
Estimates ( 4 ) & -0.2978 & 0.1041 & 0.2876 & 0 & 0 & 0 & -0.6346 \tabularnewline
(p-val) & (5e-04 ) & (0.2352 ) & (7e-04 ) & (NA ) & (NA ) & (NA ) & (0 ) \tabularnewline
Estimates ( 5 ) & -0.3256 & 0 & 0.259 & 0 & 0 & 0 & -0.6357 \tabularnewline
(p-val) & (1e-04 ) & (NA ) & (0.0015 ) & (NA ) & (NA ) & (NA ) & (0 ) \tabularnewline
Estimates ( 6 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 7 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 8 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 9 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 10 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 11 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 12 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
Estimates ( 13 ) & NA & NA & NA & NA & NA & NA & NA \tabularnewline
(p-val) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) & (NA ) \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158331&T=1

[TABLE]
[ROW][C]ARIMA Parameter Estimation and Backward Selection[/C][/ROW]
[ROW][C]Iteration[/C][C]ar1[/C][C]ar2[/C][C]ar3[/C][C]ma1[/C][C]sar1[/C][C]sar2[/C][C]sma1[/C][/ROW]
[ROW][C]Estimates ( 1 )[/C][C]-0.2729[/C][C]0.1451[/C][C]0.2674[/C][C]0.0364[/C][C]0.1808[/C][C]-0.0852[/C][C]-0.7295[/C][/ROW]
[ROW][C](p-val)[/C][C](0.2745 )[/C][C](0.1683 )[/C][C](0.0026 )[/C][C](0.8867 )[/C][C](0.3156 )[/C][C](0.5236 )[/C][C](0 )[/C][/ROW]
[ROW][C]Estimates ( 2 )[/C][C]-0.2401[/C][C]0.1517[/C][C]0.2647[/C][C]0[/C][C]0.1785[/C][C]-0.0838[/C][C]-0.7274[/C][/ROW]
[ROW][C](p-val)[/C][C](0.0115 )[/C][C](0.103 )[/C][C](0.0026 )[/C][C](NA )[/C][C](0.3204 )[/C][C](0.5308 )[/C][C](0 )[/C][/ROW]
[ROW][C]Estimates ( 3 )[/C][C]-0.2547[/C][C]0.1434[/C][C]0.2696[/C][C]0[/C][C]0.2203[/C][C]0[/C][C]-0.7845[/C][/ROW]
[ROW][C](p-val)[/C][C](0.0049 )[/C][C](0.1164 )[/C][C](0.0019 )[/C][C](NA )[/C][C](0.1744 )[/C][C](NA )[/C][C](0 )[/C][/ROW]
[ROW][C]Estimates ( 4 )[/C][C]-0.2978[/C][C]0.1041[/C][C]0.2876[/C][C]0[/C][C]0[/C][C]0[/C][C]-0.6346[/C][/ROW]
[ROW][C](p-val)[/C][C](5e-04 )[/C][C](0.2352 )[/C][C](7e-04 )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](0 )[/C][/ROW]
[ROW][C]Estimates ( 5 )[/C][C]-0.3256[/C][C]0[/C][C]0.259[/C][C]0[/C][C]0[/C][C]0[/C][C]-0.6357[/C][/ROW]
[ROW][C](p-val)[/C][C](1e-04 )[/C][C](NA )[/C][C](0.0015 )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](0 )[/C][/ROW]
[ROW][C]Estimates ( 6 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 7 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 8 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 9 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 10 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 11 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 12 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[ROW][C]Estimates ( 13 )[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][C]NA[/C][/ROW]
[ROW][C](p-val)[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][C](NA )[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158331&T=1

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

As an alternative you can also use a QR Code:  

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

ARIMA Parameter Estimation and Backward Selection
Iterationar1ar2ar3ma1sar1sar2sma1
Estimates ( 1 )-0.27290.14510.26740.03640.1808-0.0852-0.7295
(p-val)(0.2745 )(0.1683 )(0.0026 )(0.8867 )(0.3156 )(0.5236 )(0 )
Estimates ( 2 )-0.24010.15170.264700.1785-0.0838-0.7274
(p-val)(0.0115 )(0.103 )(0.0026 )(NA )(0.3204 )(0.5308 )(0 )
Estimates ( 3 )-0.25470.14340.269600.22030-0.7845
(p-val)(0.0049 )(0.1164 )(0.0019 )(NA )(0.1744 )(NA )(0 )
Estimates ( 4 )-0.29780.10410.2876000-0.6346
(p-val)(5e-04 )(0.2352 )(7e-04 )(NA )(NA )(NA )(0 )
Estimates ( 5 )-0.325600.259000-0.6357
(p-val)(1e-04 )(NA )(0.0015 )(NA )(NA )(NA )(0 )
Estimates ( 6 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 7 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 8 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 9 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 10 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 11 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 12 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )
Estimates ( 13 )NANANANANANANA
(p-val)(NA )(NA )(NA )(NA )(NA )(NA )(NA )







Estimated ARIMA Residuals
Value
-0.0110201441746426
0.00411063885901124
-0.0119036155859781
-0.000878079691466328
-0.00609283620327566
0.0079332619127729
0.000226892300531816
0.00634973668661
0.00784617251260307
-0.0136541018398393
-0.00850377057596581
0.0027323110945112
-0.000395756062355102
-0.0116247956752402
-0.00246302073020693
-0.00648692756534598
-0.00264218499657081
0.00450584870544257
-0.0196219142301908
0.00635614487500236
0.00613244051514296
0.00954066246911494
0.0021648623809593
-0.00694998310624776
-0.00241978325139549
-0.00576442082744201
0.0241191208235431
0.00356291591347879
0.000123688483758506
0.0123880115588541
-0.00713338490110563
-0.00373199569858959
-0.00777389771574479
-0.00363401641388872
0.0177299748751257
-0.0216615836824979
0.00305671900107053
-0.00111926759467253
0.015630665613511
-0.0061761709394793
-1.98718100684666e-05
-0.00658630576860871
0.0100187964755585
0.015794861510747
-0.00661757268913277
-0.00549165713717512
-0.000741434461445793
-0.00175544243945189
-0.00684670237049854
0.0204144081894933
-0.00630078105753477
0.00586867067637726
0.00233606450754621
-0.0053964229760053
0.00691388474750966
-0.00405055828297775
0.000612504725031886
0.0101616843537443
0.0062618692762037
0.0051548101811216
-0.00162201033294101
-0.0331368098812975
-0.0227379237470683
0.0245071986356261
0.00161907492421057
0.00306210461217058
0.00538526177938785
0.00122888593826267
-0.00878993848057056
-0.00440696392786969
-0.00149770142360754
0.00777228110340305
0.000513467134913155
-0.0174615328581467
0.0168804467092542
0.0115741298953333
-0.00372614953102597
0.00046212179148489
-0.00228793945245828
-0.000426059783196535
0.00895986171158795
-0.00736271518122806
-0.0181477193678384
-0.00224561050278719
0.000897922415462584
0.00140722578650797
0.00625114801438252
0.00409285525946942
0.00586431991157123
0.0194236614244358
-0.00353308302304166
-0.00664074588357447
-0.00151079937923609
-0.00887682362412188
0.00145233191993125
-0.00974238249120635
0.00481049842952395
0.00393398528382513
-0.0057630669102888
0.00248199792866987
-0.00169128725628471
-0.00681023102353
-0.00960373388335594
0.00438999993724593
-0.0150030834342024
-0.0139959449705665
-0.0130874859872158
-0.0540744779542117
-0.0213432767988492
0.0131855787053573
0.00536328263922184
-0.0012668484310763
0.0193441800856503
0.00406539753382676
0.022295248386991
0.0118415268511948
-0.00959366997046134
0.00275166916412885
0.0201297127605711
0.00733302365894231
0.0140249663456031
0.00204126248378257
0.0138862747203201
-0.0406728671831904
0.040563151801729
-0.000856285035042817
0.00804904326377482
-0.00346312799426072
-0.00393432037800852
-0.00808909949601416
-0.0171549408150819
6.29083608265019e-05

\begin{tabular}{lllllllll}
\hline
Estimated ARIMA Residuals \tabularnewline
Value \tabularnewline
-0.0110201441746426 \tabularnewline
0.00411063885901124 \tabularnewline
-0.0119036155859781 \tabularnewline
-0.000878079691466328 \tabularnewline
-0.00609283620327566 \tabularnewline
0.0079332619127729 \tabularnewline
0.000226892300531816 \tabularnewline
0.00634973668661 \tabularnewline
0.00784617251260307 \tabularnewline
-0.0136541018398393 \tabularnewline
-0.00850377057596581 \tabularnewline
0.0027323110945112 \tabularnewline
-0.000395756062355102 \tabularnewline
-0.0116247956752402 \tabularnewline
-0.00246302073020693 \tabularnewline
-0.00648692756534598 \tabularnewline
-0.00264218499657081 \tabularnewline
0.00450584870544257 \tabularnewline
-0.0196219142301908 \tabularnewline
0.00635614487500236 \tabularnewline
0.00613244051514296 \tabularnewline
0.00954066246911494 \tabularnewline
0.0021648623809593 \tabularnewline
-0.00694998310624776 \tabularnewline
-0.00241978325139549 \tabularnewline
-0.00576442082744201 \tabularnewline
0.0241191208235431 \tabularnewline
0.00356291591347879 \tabularnewline
0.000123688483758506 \tabularnewline
0.0123880115588541 \tabularnewline
-0.00713338490110563 \tabularnewline
-0.00373199569858959 \tabularnewline
-0.00777389771574479 \tabularnewline
-0.00363401641388872 \tabularnewline
0.0177299748751257 \tabularnewline
-0.0216615836824979 \tabularnewline
0.00305671900107053 \tabularnewline
-0.00111926759467253 \tabularnewline
0.015630665613511 \tabularnewline
-0.0061761709394793 \tabularnewline
-1.98718100684666e-05 \tabularnewline
-0.00658630576860871 \tabularnewline
0.0100187964755585 \tabularnewline
0.015794861510747 \tabularnewline
-0.00661757268913277 \tabularnewline
-0.00549165713717512 \tabularnewline
-0.000741434461445793 \tabularnewline
-0.00175544243945189 \tabularnewline
-0.00684670237049854 \tabularnewline
0.0204144081894933 \tabularnewline
-0.00630078105753477 \tabularnewline
0.00586867067637726 \tabularnewline
0.00233606450754621 \tabularnewline
-0.0053964229760053 \tabularnewline
0.00691388474750966 \tabularnewline
-0.00405055828297775 \tabularnewline
0.000612504725031886 \tabularnewline
0.0101616843537443 \tabularnewline
0.0062618692762037 \tabularnewline
0.0051548101811216 \tabularnewline
-0.00162201033294101 \tabularnewline
-0.0331368098812975 \tabularnewline
-0.0227379237470683 \tabularnewline
0.0245071986356261 \tabularnewline
0.00161907492421057 \tabularnewline
0.00306210461217058 \tabularnewline
0.00538526177938785 \tabularnewline
0.00122888593826267 \tabularnewline
-0.00878993848057056 \tabularnewline
-0.00440696392786969 \tabularnewline
-0.00149770142360754 \tabularnewline
0.00777228110340305 \tabularnewline
0.000513467134913155 \tabularnewline
-0.0174615328581467 \tabularnewline
0.0168804467092542 \tabularnewline
0.0115741298953333 \tabularnewline
-0.00372614953102597 \tabularnewline
0.00046212179148489 \tabularnewline
-0.00228793945245828 \tabularnewline
-0.000426059783196535 \tabularnewline
0.00895986171158795 \tabularnewline
-0.00736271518122806 \tabularnewline
-0.0181477193678384 \tabularnewline
-0.00224561050278719 \tabularnewline
0.000897922415462584 \tabularnewline
0.00140722578650797 \tabularnewline
0.00625114801438252 \tabularnewline
0.00409285525946942 \tabularnewline
0.00586431991157123 \tabularnewline
0.0194236614244358 \tabularnewline
-0.00353308302304166 \tabularnewline
-0.00664074588357447 \tabularnewline
-0.00151079937923609 \tabularnewline
-0.00887682362412188 \tabularnewline
0.00145233191993125 \tabularnewline
-0.00974238249120635 \tabularnewline
0.00481049842952395 \tabularnewline
0.00393398528382513 \tabularnewline
-0.0057630669102888 \tabularnewline
0.00248199792866987 \tabularnewline
-0.00169128725628471 \tabularnewline
-0.00681023102353 \tabularnewline
-0.00960373388335594 \tabularnewline
0.00438999993724593 \tabularnewline
-0.0150030834342024 \tabularnewline
-0.0139959449705665 \tabularnewline
-0.0130874859872158 \tabularnewline
-0.0540744779542117 \tabularnewline
-0.0213432767988492 \tabularnewline
0.0131855787053573 \tabularnewline
0.00536328263922184 \tabularnewline
-0.0012668484310763 \tabularnewline
0.0193441800856503 \tabularnewline
0.00406539753382676 \tabularnewline
0.022295248386991 \tabularnewline
0.0118415268511948 \tabularnewline
-0.00959366997046134 \tabularnewline
0.00275166916412885 \tabularnewline
0.0201297127605711 \tabularnewline
0.00733302365894231 \tabularnewline
0.0140249663456031 \tabularnewline
0.00204126248378257 \tabularnewline
0.0138862747203201 \tabularnewline
-0.0406728671831904 \tabularnewline
0.040563151801729 \tabularnewline
-0.000856285035042817 \tabularnewline
0.00804904326377482 \tabularnewline
-0.00346312799426072 \tabularnewline
-0.00393432037800852 \tabularnewline
-0.00808909949601416 \tabularnewline
-0.0171549408150819 \tabularnewline
6.29083608265019e-05 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158331&T=2

[TABLE]
[ROW][C]Estimated ARIMA Residuals[/C][/ROW]
[ROW][C]Value[/C][/ROW]
[ROW][C]-0.0110201441746426[/C][/ROW]
[ROW][C]0.00411063885901124[/C][/ROW]
[ROW][C]-0.0119036155859781[/C][/ROW]
[ROW][C]-0.000878079691466328[/C][/ROW]
[ROW][C]-0.00609283620327566[/C][/ROW]
[ROW][C]0.0079332619127729[/C][/ROW]
[ROW][C]0.000226892300531816[/C][/ROW]
[ROW][C]0.00634973668661[/C][/ROW]
[ROW][C]0.00784617251260307[/C][/ROW]
[ROW][C]-0.0136541018398393[/C][/ROW]
[ROW][C]-0.00850377057596581[/C][/ROW]
[ROW][C]0.0027323110945112[/C][/ROW]
[ROW][C]-0.000395756062355102[/C][/ROW]
[ROW][C]-0.0116247956752402[/C][/ROW]
[ROW][C]-0.00246302073020693[/C][/ROW]
[ROW][C]-0.00648692756534598[/C][/ROW]
[ROW][C]-0.00264218499657081[/C][/ROW]
[ROW][C]0.00450584870544257[/C][/ROW]
[ROW][C]-0.0196219142301908[/C][/ROW]
[ROW][C]0.00635614487500236[/C][/ROW]
[ROW][C]0.00613244051514296[/C][/ROW]
[ROW][C]0.00954066246911494[/C][/ROW]
[ROW][C]0.0021648623809593[/C][/ROW]
[ROW][C]-0.00694998310624776[/C][/ROW]
[ROW][C]-0.00241978325139549[/C][/ROW]
[ROW][C]-0.00576442082744201[/C][/ROW]
[ROW][C]0.0241191208235431[/C][/ROW]
[ROW][C]0.00356291591347879[/C][/ROW]
[ROW][C]0.000123688483758506[/C][/ROW]
[ROW][C]0.0123880115588541[/C][/ROW]
[ROW][C]-0.00713338490110563[/C][/ROW]
[ROW][C]-0.00373199569858959[/C][/ROW]
[ROW][C]-0.00777389771574479[/C][/ROW]
[ROW][C]-0.00363401641388872[/C][/ROW]
[ROW][C]0.0177299748751257[/C][/ROW]
[ROW][C]-0.0216615836824979[/C][/ROW]
[ROW][C]0.00305671900107053[/C][/ROW]
[ROW][C]-0.00111926759467253[/C][/ROW]
[ROW][C]0.015630665613511[/C][/ROW]
[ROW][C]-0.0061761709394793[/C][/ROW]
[ROW][C]-1.98718100684666e-05[/C][/ROW]
[ROW][C]-0.00658630576860871[/C][/ROW]
[ROW][C]0.0100187964755585[/C][/ROW]
[ROW][C]0.015794861510747[/C][/ROW]
[ROW][C]-0.00661757268913277[/C][/ROW]
[ROW][C]-0.00549165713717512[/C][/ROW]
[ROW][C]-0.000741434461445793[/C][/ROW]
[ROW][C]-0.00175544243945189[/C][/ROW]
[ROW][C]-0.00684670237049854[/C][/ROW]
[ROW][C]0.0204144081894933[/C][/ROW]
[ROW][C]-0.00630078105753477[/C][/ROW]
[ROW][C]0.00586867067637726[/C][/ROW]
[ROW][C]0.00233606450754621[/C][/ROW]
[ROW][C]-0.0053964229760053[/C][/ROW]
[ROW][C]0.00691388474750966[/C][/ROW]
[ROW][C]-0.00405055828297775[/C][/ROW]
[ROW][C]0.000612504725031886[/C][/ROW]
[ROW][C]0.0101616843537443[/C][/ROW]
[ROW][C]0.0062618692762037[/C][/ROW]
[ROW][C]0.0051548101811216[/C][/ROW]
[ROW][C]-0.00162201033294101[/C][/ROW]
[ROW][C]-0.0331368098812975[/C][/ROW]
[ROW][C]-0.0227379237470683[/C][/ROW]
[ROW][C]0.0245071986356261[/C][/ROW]
[ROW][C]0.00161907492421057[/C][/ROW]
[ROW][C]0.00306210461217058[/C][/ROW]
[ROW][C]0.00538526177938785[/C][/ROW]
[ROW][C]0.00122888593826267[/C][/ROW]
[ROW][C]-0.00878993848057056[/C][/ROW]
[ROW][C]-0.00440696392786969[/C][/ROW]
[ROW][C]-0.00149770142360754[/C][/ROW]
[ROW][C]0.00777228110340305[/C][/ROW]
[ROW][C]0.000513467134913155[/C][/ROW]
[ROW][C]-0.0174615328581467[/C][/ROW]
[ROW][C]0.0168804467092542[/C][/ROW]
[ROW][C]0.0115741298953333[/C][/ROW]
[ROW][C]-0.00372614953102597[/C][/ROW]
[ROW][C]0.00046212179148489[/C][/ROW]
[ROW][C]-0.00228793945245828[/C][/ROW]
[ROW][C]-0.000426059783196535[/C][/ROW]
[ROW][C]0.00895986171158795[/C][/ROW]
[ROW][C]-0.00736271518122806[/C][/ROW]
[ROW][C]-0.0181477193678384[/C][/ROW]
[ROW][C]-0.00224561050278719[/C][/ROW]
[ROW][C]0.000897922415462584[/C][/ROW]
[ROW][C]0.00140722578650797[/C][/ROW]
[ROW][C]0.00625114801438252[/C][/ROW]
[ROW][C]0.00409285525946942[/C][/ROW]
[ROW][C]0.00586431991157123[/C][/ROW]
[ROW][C]0.0194236614244358[/C][/ROW]
[ROW][C]-0.00353308302304166[/C][/ROW]
[ROW][C]-0.00664074588357447[/C][/ROW]
[ROW][C]-0.00151079937923609[/C][/ROW]
[ROW][C]-0.00887682362412188[/C][/ROW]
[ROW][C]0.00145233191993125[/C][/ROW]
[ROW][C]-0.00974238249120635[/C][/ROW]
[ROW][C]0.00481049842952395[/C][/ROW]
[ROW][C]0.00393398528382513[/C][/ROW]
[ROW][C]-0.0057630669102888[/C][/ROW]
[ROW][C]0.00248199792866987[/C][/ROW]
[ROW][C]-0.00169128725628471[/C][/ROW]
[ROW][C]-0.00681023102353[/C][/ROW]
[ROW][C]-0.00960373388335594[/C][/ROW]
[ROW][C]0.00438999993724593[/C][/ROW]
[ROW][C]-0.0150030834342024[/C][/ROW]
[ROW][C]-0.0139959449705665[/C][/ROW]
[ROW][C]-0.0130874859872158[/C][/ROW]
[ROW][C]-0.0540744779542117[/C][/ROW]
[ROW][C]-0.0213432767988492[/C][/ROW]
[ROW][C]0.0131855787053573[/C][/ROW]
[ROW][C]0.00536328263922184[/C][/ROW]
[ROW][C]-0.0012668484310763[/C][/ROW]
[ROW][C]0.0193441800856503[/C][/ROW]
[ROW][C]0.00406539753382676[/C][/ROW]
[ROW][C]0.022295248386991[/C][/ROW]
[ROW][C]0.0118415268511948[/C][/ROW]
[ROW][C]-0.00959366997046134[/C][/ROW]
[ROW][C]0.00275166916412885[/C][/ROW]
[ROW][C]0.0201297127605711[/C][/ROW]
[ROW][C]0.00733302365894231[/C][/ROW]
[ROW][C]0.0140249663456031[/C][/ROW]
[ROW][C]0.00204126248378257[/C][/ROW]
[ROW][C]0.0138862747203201[/C][/ROW]
[ROW][C]-0.0406728671831904[/C][/ROW]
[ROW][C]0.040563151801729[/C][/ROW]
[ROW][C]-0.000856285035042817[/C][/ROW]
[ROW][C]0.00804904326377482[/C][/ROW]
[ROW][C]-0.00346312799426072[/C][/ROW]
[ROW][C]-0.00393432037800852[/C][/ROW]
[ROW][C]-0.00808909949601416[/C][/ROW]
[ROW][C]-0.0171549408150819[/C][/ROW]
[ROW][C]6.29083608265019e-05[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158331&T=2

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

As an alternative you can also use a QR Code:  

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

Estimated ARIMA Residuals
Value
-0.0110201441746426
0.00411063885901124
-0.0119036155859781
-0.000878079691466328
-0.00609283620327566
0.0079332619127729
0.000226892300531816
0.00634973668661
0.00784617251260307
-0.0136541018398393
-0.00850377057596581
0.0027323110945112
-0.000395756062355102
-0.0116247956752402
-0.00246302073020693
-0.00648692756534598
-0.00264218499657081
0.00450584870544257
-0.0196219142301908
0.00635614487500236
0.00613244051514296
0.00954066246911494
0.0021648623809593
-0.00694998310624776
-0.00241978325139549
-0.00576442082744201
0.0241191208235431
0.00356291591347879
0.000123688483758506
0.0123880115588541
-0.00713338490110563
-0.00373199569858959
-0.00777389771574479
-0.00363401641388872
0.0177299748751257
-0.0216615836824979
0.00305671900107053
-0.00111926759467253
0.015630665613511
-0.0061761709394793
-1.98718100684666e-05
-0.00658630576860871
0.0100187964755585
0.015794861510747
-0.00661757268913277
-0.00549165713717512
-0.000741434461445793
-0.00175544243945189
-0.00684670237049854
0.0204144081894933
-0.00630078105753477
0.00586867067637726
0.00233606450754621
-0.0053964229760053
0.00691388474750966
-0.00405055828297775
0.000612504725031886
0.0101616843537443
0.0062618692762037
0.0051548101811216
-0.00162201033294101
-0.0331368098812975
-0.0227379237470683
0.0245071986356261
0.00161907492421057
0.00306210461217058
0.00538526177938785
0.00122888593826267
-0.00878993848057056
-0.00440696392786969
-0.00149770142360754
0.00777228110340305
0.000513467134913155
-0.0174615328581467
0.0168804467092542
0.0115741298953333
-0.00372614953102597
0.00046212179148489
-0.00228793945245828
-0.000426059783196535
0.00895986171158795
-0.00736271518122806
-0.0181477193678384
-0.00224561050278719
0.000897922415462584
0.00140722578650797
0.00625114801438252
0.00409285525946942
0.00586431991157123
0.0194236614244358
-0.00353308302304166
-0.00664074588357447
-0.00151079937923609
-0.00887682362412188
0.00145233191993125
-0.00974238249120635
0.00481049842952395
0.00393398528382513
-0.0057630669102888
0.00248199792866987
-0.00169128725628471
-0.00681023102353
-0.00960373388335594
0.00438999993724593
-0.0150030834342024
-0.0139959449705665
-0.0130874859872158
-0.0540744779542117
-0.0213432767988492
0.0131855787053573
0.00536328263922184
-0.0012668484310763
0.0193441800856503
0.00406539753382676
0.022295248386991
0.0118415268511948
-0.00959366997046134
0.00275166916412885
0.0201297127605711
0.00733302365894231
0.0140249663456031
0.00204126248378257
0.0138862747203201
-0.0406728671831904
0.040563151801729
-0.000856285035042817
0.00804904326377482
-0.00346312799426072
-0.00393432037800852
-0.00808909949601416
-0.0171549408150819
6.29083608265019e-05



Parameters (Session):
par1 = 4 ; par2 = Include Monthly Dummies ; par3 = No Linear Trend ;
Parameters (R input):
par1 = FALSE ; par2 = 0.1 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 3 ; par7 = 1 ; par8 = 2 ; par9 = 1 ;
R code (references can be found in the software module):
library(lattice)
if (par1 == 'TRUE') par1 <- TRUE
if (par1 == 'FALSE') par1 <- FALSE
par2 <- as.numeric(par2) #Box-Cox lambda transformation parameter
par3 <- as.numeric(par3) #degree of non-seasonal differencing
par4 <- as.numeric(par4) #degree of seasonal differencing
par5 <- as.numeric(par5) #seasonal period
par6 <- as.numeric(par6) #degree (p) of the non-seasonal AR(p) polynomial
par7 <- as.numeric(par7) #degree (q) of the non-seasonal MA(q) polynomial
par8 <- as.numeric(par8) #degree (P) of the seasonal AR(P) polynomial
par9 <- as.numeric(par9) #degree (Q) of the seasonal MA(Q) polynomial
armaGR <- function(arima.out, names, n){
try1 <- arima.out$coef
try2 <- sqrt(diag(arima.out$var.coef))
try.data.frame <- data.frame(matrix(NA,ncol=4,nrow=length(names)))
dimnames(try.data.frame) <- list(names,c('coef','std','tstat','pv'))
try.data.frame[,1] <- try1
for(i in 1:length(try2)) try.data.frame[which(rownames(try.data.frame)==names(try2)[i]),2] <- try2[i]
try.data.frame[,3] <- try.data.frame[,1] / try.data.frame[,2]
try.data.frame[,4] <- round((1-pt(abs(try.data.frame[,3]),df=n-(length(try2)+1)))*2,5)
vector <- rep(NA,length(names))
vector[is.na(try.data.frame[,4])] <- 0
maxi <- which.max(try.data.frame[,4])
continue <- max(try.data.frame[,4],na.rm=TRUE) > .05
vector[maxi] <- 0
list(summary=try.data.frame,next.vector=vector,continue=continue)
}
arimaSelect <- function(series, order=c(13,0,0), seasonal=list(order=c(2,0,0),period=12), include.mean=F){
nrc <- order[1]+order[3]+seasonal$order[1]+seasonal$order[3]
coeff <- matrix(NA, nrow=nrc*2, ncol=nrc)
pval <- matrix(NA, nrow=nrc*2, ncol=nrc)
mylist <- rep(list(NULL), nrc)
names <- NULL
if(order[1] > 0) names <- paste('ar',1:order[1],sep='')
if(order[3] > 0) names <- c( names , paste('ma',1:order[3],sep='') )
if(seasonal$order[1] > 0) names <- c(names, paste('sar',1:seasonal$order[1],sep=''))
if(seasonal$order[3] > 0) names <- c(names, paste('sma',1:seasonal$order[3],sep=''))
arima.out <- arima(series, order=order, seasonal=seasonal, include.mean=include.mean, method='ML')
mylist[[1]] <- arima.out
last.arma <- armaGR(arima.out, names, length(series))
mystop <- FALSE
i <- 1
coeff[i,] <- last.arma[[1]][,1]
pval [i,] <- last.arma[[1]][,4]
i <- 2
aic <- arima.out$aic
while(!mystop){
mylist[[i]] <- arima.out
arima.out <- arima(series, order=order, seasonal=seasonal, include.mean=include.mean, method='ML', fixed=last.arma$next.vector)
aic <- c(aic, arima.out$aic)
last.arma <- armaGR(arima.out, names, length(series))
mystop <- !last.arma$continue
coeff[i,] <- last.arma[[1]][,1]
pval [i,] <- last.arma[[1]][,4]
i <- i+1
}
list(coeff, pval, mylist, aic=aic)
}
arimaSelectplot <- function(arimaSelect.out,noms,choix){
noms <- names(arimaSelect.out[[3]][[1]]$coef)
coeff <- arimaSelect.out[[1]]
k <- min(which(is.na(coeff[,1])))-1
coeff <- coeff[1:k,]
pval <- arimaSelect.out[[2]][1:k,]
aic <- arimaSelect.out$aic[1:k]
coeff[coeff==0] <- NA
n <- ncol(coeff)
if(missing(choix)) choix <- k
layout(matrix(c(1,1,1,2,
3,3,3,2,
3,3,3,4,
5,6,7,7),nr=4),
widths=c(10,35,45,15),
heights=c(30,30,15,15))
couleurs <- rainbow(75)[1:50]#(50)
ticks <- pretty(coeff)
par(mar=c(1,1,3,1))
plot(aic,k:1-.5,type='o',pch=21,bg='blue',cex=2,axes=F,lty=2,xpd=NA)
points(aic[choix],k-choix+.5,pch=21,cex=4,bg=2,xpd=NA)
title('aic',line=2)
par(mar=c(3,0,0,0))
plot(0,axes=F,xlab='',ylab='',xlim=range(ticks),ylim=c(.1,1))
rect(xleft = min(ticks) + (0:49)/50*(max(ticks)-min(ticks)),
xright = min(ticks) + (1:50)/50*(max(ticks)-min(ticks)),
ytop = rep(1,50),
ybottom= rep(0,50),col=couleurs,border=NA)
axis(1,ticks)
rect(xleft=min(ticks),xright=max(ticks),ytop=1,ybottom=0)
text(mean(coeff,na.rm=T),.5,'coefficients',cex=2,font=2)
par(mar=c(1,1,3,1))
image(1:n,1:k,t(coeff[k:1,]),axes=F,col=couleurs,zlim=range(ticks))
for(i in 1:n) for(j in 1:k) if(!is.na(coeff[j,i])) {
if(pval[j,i]<.01) symb = 'green'
else if( (pval[j,i]<.05) & (pval[j,i]>=.01)) symb = 'orange'
else if( (pval[j,i]<.1) & (pval[j,i]>=.05)) symb = 'red'
else symb = 'black'
polygon(c(i+.5 ,i+.2 ,i+.5 ,i+.5),
c(k-j+0.5,k-j+0.5,k-j+0.8,k-j+0.5),
col=symb)
if(j==choix) {
rect(xleft=i-.5,
xright=i+.5,
ybottom=k-j+1.5,
ytop=k-j+.5,
lwd=4)
text(i,
k-j+1,
round(coeff[j,i],2),
cex=1.2,
font=2)
}
else{
rect(xleft=i-.5,xright=i+.5,ybottom=k-j+1.5,ytop=k-j+.5)
text(i,k-j+1,round(coeff[j,i],2),cex=1.2,font=1)
}
}
axis(3,1:n,noms)
par(mar=c(0.5,0,0,0.5))
plot(0,axes=F,xlab='',ylab='',type='n',xlim=c(0,8),ylim=c(-.2,.8))
cols <- c('green','orange','red','black')
niv <- c('0','0.01','0.05','0.1')
for(i in 0:3){
polygon(c(1+2*i ,1+2*i ,1+2*i-.5 ,1+2*i),
c(.4 ,.7 , .4 , .4),
col=cols[i+1])
text(2*i,0.5,niv[i+1],cex=1.5)
}
text(8,.5,1,cex=1.5)
text(4,0,'p-value',cex=2)
box()
residus <- arimaSelect.out[[3]][[choix]]$res
par(mar=c(1,2,4,1))
acf(residus,main='')
title('acf',line=.5)
par(mar=c(1,2,4,1))
pacf(residus,main='')
title('pacf',line=.5)
par(mar=c(2,2,4,1))
qqnorm(residus,main='')
title('qq-norm',line=.5)
qqline(residus)
residus
}
if (par2 == 0) x <- log(x)
if (par2 != 0) x <- x^par2
(selection <- arimaSelect(x, order=c(par6,par3,par7), seasonal=list(order=c(par8,par4,par9), period=par5)))
bitmap(file='test1.png')
resid <- arimaSelectplot(selection)
dev.off()
resid
bitmap(file='test2.png')
acf(resid,length(resid)/2, main='Residual Autocorrelation Function')
dev.off()
bitmap(file='test3.png')
pacf(resid,length(resid)/2, main='Residual Partial Autocorrelation Function')
dev.off()
bitmap(file='test4.png')
cpgram(resid, main='Residual Cumulative Periodogram')
dev.off()
bitmap(file='test5.png')
hist(resid, main='Residual Histogram', xlab='values of Residuals')
dev.off()
bitmap(file='test6.png')
densityplot(~resid,col='black',main='Residual Density Plot', xlab='values of Residuals')
dev.off()
bitmap(file='test7.png')
qqnorm(resid, main='Residual Normal Q-Q Plot')
qqline(resid)
dev.off()
ncols <- length(selection[[1]][1,])
nrows <- length(selection[[2]][,1])-1
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'ARIMA Parameter Estimation and Backward Selection', ncols+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Iteration', header=TRUE)
for (i in 1:ncols) {
a<-table.element(a,names(selection[[3]][[1]]$coef)[i],header=TRUE)
}
a<-table.row.end(a)
for (j in 1:nrows) {
a<-table.row.start(a)
mydum <- 'Estimates ('
mydum <- paste(mydum,j)
mydum <- paste(mydum,')')
a<-table.element(a,mydum, header=TRUE)
for (i in 1:ncols) {
a<-table.element(a,round(selection[[1]][j,i],4))
}
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'(p-val)', header=TRUE)
for (i in 1:ncols) {
mydum <- '('
mydum <- paste(mydum,round(selection[[2]][j,i],4),sep='')
mydum <- paste(mydum,')')
a<-table.element(a,mydum)
}
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,'Estimated ARIMA Residuals', 1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Value', 1,TRUE)
a<-table.row.end(a)
for (i in (par4*par5+par3):length(resid)) {
a<-table.row.start(a)
a<-table.element(a,resid[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable1.tab')