Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_multipleregression.wasp
Title produced by softwareMultiple Regression
Date of computationThu, 19 Nov 2009 13:16:00 -0700
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2009/Nov/19/t12586619214nij0dxde3padqy.htm/, Retrieved Fri, 29 Mar 2024 12:48:52 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=57933, Retrieved Fri, 29 Mar 2024 12:48:52 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact195
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [Q1 The Seatbeltlaw] [2007-11-14 19:27:43] [8cd6641b921d30ebe00b648d1481bba0]
- RM D  [Multiple Regression] [Seatbelt] [2009-11-12 14:14:11] [b98453cac15ba1066b407e146608df68]
-    D      [Multiple Regression] [WS 7 Multiple reg...] [2009-11-19 20:16:00] [eba9f01697e64705b70041e6f338cb22] [Current]
Feedback Forum

Post a new message
Dataseries X:
119,93	111,4	101,21	108,01
94,76	87,4	119,93	101,21
95,26	96,8	94,76	119,93
117,96	114,1	95,26	94,76
115,86	110,3	117,96	95,26
111,44	103,9	115,86	117,96
108,16	101,6	111,44	115,86
108,77	94,6	108,16	111,44
109,45	95,9	108,77	108,16
124,83	104,7	109,45	108,77
115,31	102,8	124,83	109,45
109,49	98,1	115,31	124,83
124,24	113,9	109,49	115,31
92,85	80,9	124,24	109,49
98,42	95,7	92,85	124,24
120,88	113,2	98,42	92,85
111,72	105,9	120,88	98,42
116,1	108,8	111,72	120,88
109,37	102,3	116,1	111,72
111,65	99	109,37	116,1
114,29	100,7	111,65	109,37
133,68	115,5	114,29	111,65
114,27	100,7	133,68	114,29
126,49	109,9	114,27	133,68
131	114,6	126,49	114,27
104	85,4	131	126,49
108,88	100,5	104	131
128,48	114,8	108,88	104
132,44	116,5	128,48	108,88
128,04	112,9	132,44	128,48
116,35	102	128,04	132,44
120,93	106	116,35	128,04
118,59	105,3	120,93	116,35
133,1	118,8	118,59	120,93
121,05	106,1	133,1	118,59
127,62	109,3	121,05	133,1
135,44	117,2	127,62	121,05
114,88	92,5	135,44	127,62
114,34	104,2	114,88	135,44
128,85	112,5	114,34	114,88
138,9	122,4	128,85	114,34
129,44	113,3	138,9	128,85
114,96	100	129,44	138,9
127,98	110,7	114,96	129,44
127,03	112,8	127,98	114,96
128,75	109,8	127,03	127,98
137,91	117,3	128,75	127,03
128,37	109,1	137,91	128,75
135,9	115,9	128,37	137,91
122,19	96	135,9	128,37
113,08	99,8	122,19	135,9
136,2	116,8	113,08	122,19
138	115,7	136,2	113,08
115,24	99,4	138	136,2
110,95	94,3	115,24	138
99,23	91	110,95	115,24
102,39	93,2	99,23	110,95
112,67	103,1	102,39	99,23




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135

\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 & 3 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ 72.249.127.135 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&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]3 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gwilym Jenkins' @ 72.249.127.135[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=57933&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 time3 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135







Multiple Linear Regression - Estimated Regression Equation
Y[t] = -50.9640522907201 + 1.07016114979443X[t] + 0.173985757105798Y1[t] + 0.293977711131534Y2[t] + 1.59007716465838M1[t] + 4.34909964071228M2[t] -6.16808657058887M3[t] + 5.25575586956772M4[t] + 2.64205857405578M5[t] -3.92509865437882M6[t] -2.86912893355579M7[t] + 2.20031881493963M8[t] + 3.4871885785655M9[t] + 5.68632854743579M10[t] + 1.38569107000666M11[t] + 0.0128020945805415t + e[t]

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Estimated Regression Equation \tabularnewline
Y[t] =  -50.9640522907201 +  1.07016114979443X[t] +  0.173985757105798Y1[t] +  0.293977711131534Y2[t] +  1.59007716465838M1[t] +  4.34909964071228M2[t] -6.16808657058887M3[t] +  5.25575586956772M4[t] +  2.64205857405578M5[t] -3.92509865437882M6[t] -2.86912893355579M7[t] +  2.20031881493963M8[t] +  3.4871885785655M9[t] +  5.68632854743579M10[t] +  1.38569107000666M11[t] +  0.0128020945805415t  + e[t] \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&T=1

[TABLE]
[ROW][C]Multiple Linear Regression - Estimated Regression Equation[/C][/ROW]
[ROW][C]Y[t] =  -50.9640522907201 +  1.07016114979443X[t] +  0.173985757105798Y1[t] +  0.293977711131534Y2[t] +  1.59007716465838M1[t] +  4.34909964071228M2[t] -6.16808657058887M3[t] +  5.25575586956772M4[t] +  2.64205857405578M5[t] -3.92509865437882M6[t] -2.86912893355579M7[t] +  2.20031881493963M8[t] +  3.4871885785655M9[t] +  5.68632854743579M10[t] +  1.38569107000666M11[t] +  0.0128020945805415t  + e[t][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=1

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

As an alternative you can also use a QR Code:  

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

Multiple Linear Regression - Estimated Regression Equation
Y[t] = -50.9640522907201 + 1.07016114979443X[t] + 0.173985757105798Y1[t] + 0.293977711131534Y2[t] + 1.59007716465838M1[t] + 4.34909964071228M2[t] -6.16808657058887M3[t] + 5.25575586956772M4[t] + 2.64205857405578M5[t] -3.92509865437882M6[t] -2.86912893355579M7[t] + 2.20031881493963M8[t] + 3.4871885785655M9[t] + 5.68632854743579M10[t] + 1.38569107000666M11[t] + 0.0128020945805415t + e[t]







Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STATH0: parameter = 02-tail p-value1-tail p-value
(Intercept)-50.96405229072019.03349-5.64171e-061e-06
X1.070161149794430.07956513.450200
Y10.1739857571057980.0615562.82650.0071770.003588
Y20.2939777111315340.0688684.26870.000115.5e-05
M11.590077164658382.0571630.77290.4438820.221941
M24.349099640712282.4661781.76350.0850910.042545
M3-6.168086570588872.035795-3.02980.0041760.002088
M45.255755869567722.6180432.00750.0511580.025579
M52.642058574055782.6556490.99490.3254910.162745
M6-3.925098654378821.846348-2.12590.0394360.019718
M7-2.869128933555791.846323-1.5540.1276960.063848
M82.200318814939631.9296781.14030.2606420.130321
M93.48718857856552.1218851.64340.1077590.053879
M105.686328547435792.2033472.58080.0134420.006721
M111.385691070006662.1984150.63030.5319040.265952
t0.01280209458054150.0320640.39930.6917170.345859

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Ordinary Least Squares \tabularnewline
Variable & Parameter & S.D. & T-STATH0: parameter = 0 & 2-tail p-value & 1-tail p-value \tabularnewline
(Intercept) & -50.9640522907201 & 9.03349 & -5.6417 & 1e-06 & 1e-06 \tabularnewline
X & 1.07016114979443 & 0.079565 & 13.4502 & 0 & 0 \tabularnewline
Y1 & 0.173985757105798 & 0.061556 & 2.8265 & 0.007177 & 0.003588 \tabularnewline
Y2 & 0.293977711131534 & 0.068868 & 4.2687 & 0.00011 & 5.5e-05 \tabularnewline
M1 & 1.59007716465838 & 2.057163 & 0.7729 & 0.443882 & 0.221941 \tabularnewline
M2 & 4.34909964071228 & 2.466178 & 1.7635 & 0.085091 & 0.042545 \tabularnewline
M3 & -6.16808657058887 & 2.035795 & -3.0298 & 0.004176 & 0.002088 \tabularnewline
M4 & 5.25575586956772 & 2.618043 & 2.0075 & 0.051158 & 0.025579 \tabularnewline
M5 & 2.64205857405578 & 2.655649 & 0.9949 & 0.325491 & 0.162745 \tabularnewline
M6 & -3.92509865437882 & 1.846348 & -2.1259 & 0.039436 & 0.019718 \tabularnewline
M7 & -2.86912893355579 & 1.846323 & -1.554 & 0.127696 & 0.063848 \tabularnewline
M8 & 2.20031881493963 & 1.929678 & 1.1403 & 0.260642 & 0.130321 \tabularnewline
M9 & 3.4871885785655 & 2.121885 & 1.6434 & 0.107759 & 0.053879 \tabularnewline
M10 & 5.68632854743579 & 2.203347 & 2.5808 & 0.013442 & 0.006721 \tabularnewline
M11 & 1.38569107000666 & 2.198415 & 0.6303 & 0.531904 & 0.265952 \tabularnewline
t & 0.0128020945805415 & 0.032064 & 0.3993 & 0.691717 & 0.345859 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&T=2

[TABLE]
[ROW][C]Multiple Linear Regression - Ordinary Least Squares[/C][/ROW]
[ROW][C]Variable[/C][C]Parameter[/C][C]S.D.[/C][C]T-STATH0: parameter = 0[/C][C]2-tail p-value[/C][C]1-tail p-value[/C][/ROW]
[ROW][C](Intercept)[/C][C]-50.9640522907201[/C][C]9.03349[/C][C]-5.6417[/C][C]1e-06[/C][C]1e-06[/C][/ROW]
[ROW][C]X[/C][C]1.07016114979443[/C][C]0.079565[/C][C]13.4502[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]Y1[/C][C]0.173985757105798[/C][C]0.061556[/C][C]2.8265[/C][C]0.007177[/C][C]0.003588[/C][/ROW]
[ROW][C]Y2[/C][C]0.293977711131534[/C][C]0.068868[/C][C]4.2687[/C][C]0.00011[/C][C]5.5e-05[/C][/ROW]
[ROW][C]M1[/C][C]1.59007716465838[/C][C]2.057163[/C][C]0.7729[/C][C]0.443882[/C][C]0.221941[/C][/ROW]
[ROW][C]M2[/C][C]4.34909964071228[/C][C]2.466178[/C][C]1.7635[/C][C]0.085091[/C][C]0.042545[/C][/ROW]
[ROW][C]M3[/C][C]-6.16808657058887[/C][C]2.035795[/C][C]-3.0298[/C][C]0.004176[/C][C]0.002088[/C][/ROW]
[ROW][C]M4[/C][C]5.25575586956772[/C][C]2.618043[/C][C]2.0075[/C][C]0.051158[/C][C]0.025579[/C][/ROW]
[ROW][C]M5[/C][C]2.64205857405578[/C][C]2.655649[/C][C]0.9949[/C][C]0.325491[/C][C]0.162745[/C][/ROW]
[ROW][C]M6[/C][C]-3.92509865437882[/C][C]1.846348[/C][C]-2.1259[/C][C]0.039436[/C][C]0.019718[/C][/ROW]
[ROW][C]M7[/C][C]-2.86912893355579[/C][C]1.846323[/C][C]-1.554[/C][C]0.127696[/C][C]0.063848[/C][/ROW]
[ROW][C]M8[/C][C]2.20031881493963[/C][C]1.929678[/C][C]1.1403[/C][C]0.260642[/C][C]0.130321[/C][/ROW]
[ROW][C]M9[/C][C]3.4871885785655[/C][C]2.121885[/C][C]1.6434[/C][C]0.107759[/C][C]0.053879[/C][/ROW]
[ROW][C]M10[/C][C]5.68632854743579[/C][C]2.203347[/C][C]2.5808[/C][C]0.013442[/C][C]0.006721[/C][/ROW]
[ROW][C]M11[/C][C]1.38569107000666[/C][C]2.198415[/C][C]0.6303[/C][C]0.531904[/C][C]0.265952[/C][/ROW]
[ROW][C]t[/C][C]0.0128020945805415[/C][C]0.032064[/C][C]0.3993[/C][C]0.691717[/C][C]0.345859[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=2

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

As an alternative you can also use a QR Code:  

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

Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STATH0: parameter = 02-tail p-value1-tail p-value
(Intercept)-50.96405229072019.03349-5.64171e-061e-06
X1.070161149794430.07956513.450200
Y10.1739857571057980.0615562.82650.0071770.003588
Y20.2939777111315340.0688684.26870.000115.5e-05
M11.590077164658382.0571630.77290.4438820.221941
M24.349099640712282.4661781.76350.0850910.042545
M3-6.168086570588872.035795-3.02980.0041760.002088
M45.255755869567722.6180432.00750.0511580.025579
M52.642058574055782.6556490.99490.3254910.162745
M6-3.925098654378821.846348-2.12590.0394360.019718
M7-2.869128933555791.846323-1.5540.1276960.063848
M82.200318814939631.9296781.14030.2606420.130321
M93.48718857856552.1218851.64340.1077590.053879
M105.686328547435792.2033472.58080.0134420.006721
M111.385691070006662.1984150.63030.5319040.265952
t0.01280209458054150.0320640.39930.6917170.345859







Multiple Linear Regression - Regression Statistics
Multiple R0.980850670429848
R-squared0.962068037682683
Adjusted R-squared0.948520908283641
F-TEST (value)71.0163761889459
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.65910913178632
Sum Squared Residuals296.976177739476

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Regression Statistics \tabularnewline
Multiple R & 0.980850670429848 \tabularnewline
R-squared & 0.962068037682683 \tabularnewline
Adjusted R-squared & 0.948520908283641 \tabularnewline
F-TEST (value) & 71.0163761889459 \tabularnewline
F-TEST (DF numerator) & 15 \tabularnewline
F-TEST (DF denominator) & 42 \tabularnewline
p-value & 0 \tabularnewline
Multiple Linear Regression - Residual Statistics \tabularnewline
Residual Standard Deviation & 2.65910913178632 \tabularnewline
Sum Squared Residuals & 296.976177739476 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&T=3

[TABLE]
[ROW][C]Multiple Linear Regression - Regression Statistics[/C][/ROW]
[ROW][C]Multiple R[/C][C]0.980850670429848[/C][/ROW]
[ROW][C]R-squared[/C][C]0.962068037682683[/C][/ROW]
[ROW][C]Adjusted R-squared[/C][C]0.948520908283641[/C][/ROW]
[ROW][C]F-TEST (value)[/C][C]71.0163761889459[/C][/ROW]
[ROW][C]F-TEST (DF numerator)[/C][C]15[/C][/ROW]
[ROW][C]F-TEST (DF denominator)[/C][C]42[/C][/ROW]
[ROW][C]p-value[/C][C]0[/C][/ROW]
[ROW][C]Multiple Linear Regression - Residual Statistics[/C][/ROW]
[ROW][C]Residual Standard Deviation[/C][C]2.65910913178632[/C][/ROW]
[ROW][C]Sum Squared Residuals[/C][C]296.976177739476[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=3

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

As an alternative you can also use a QR Code:  

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

Multiple Linear Regression - Regression Statistics
Multiple R0.980850670429848
R-squared0.962068037682683
Adjusted R-squared0.948520908283641
F-TEST (value)71.0163761889459
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.65910913178632
Sum Squared Residuals296.976177739476







Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolationForecastResidualsPrediction Error
1119.93119.2164101116130.713589888387024
294.7697.5623320245071-2.80233202450712
395.2698.2415039618835-2.98150396188351
4117.96120.879510277436-2.91951027743645
5115.86118.308468249154-2.4484682491536
6111.44111.2130057093790.226994290621141
7108.16108.434036640471-0.274036640471373
8108.77104.1551036684784.61489633152204
9109.45105.9878694407403.46213055925976
10124.83117.9148663410046.91513365899579
11115.31114.4695305614030.840469438597184
12109.49110.931916971499-1.44191697149868
13124.24125.632077481162-1.39207748116161
1492.8593.943923747105-1.09392374710498
1598.4298.1526829709810.267317029019022
16120.88120.0582879417810.821712058218956
17111.72115.190392302949-3.47039230294921
18116.1116.748534360424-0.648534360424116
19109.37108.9304804843220.43951951567756
20111.65110.5978967625111.05210323748911
21114.29112.1350601056542.15493989434616
22133.68131.3149787662012.36502123379860
23114.27115.338443354064-1.06844335406398
24126.49126.1342012301630.355798769836524
25131129.1868364722061.81316352779402
26104105.087038863418-1.08703886341766
27108.88107.3703121439401.50968785606044
28128.48127.0219134148621.45808658513812
29132.44131.0850242381771.35497576182347
30128.04127.1290357013800.91096429862042
31116.35116.931665388839-0.581665388839237
32120.93122.967164401547-2.03716440154736
33118.59120.877978779315-2.28797877931461
34133.1138.476387610345-5.37638761034508
35121.05122.434131116665-1.38413111666460
36127.62126.6548460359740.965153964025679
37135.44134.3126533836391.12734661636065
38114.88113.9434997370530.936500262947035
39114.34114.681759607881-0.341759607880524
40128.85128.86260763621-0.0126076362099425
41138.9139.222093189837-0.32209318983747
42129.44128.9434450402860.496554959714038
43114.96117.087644298075-2.12764429807471
44127.98128.320275533755-0.340275533754762
45127.03129.875783106862-2.84578310686236
46128.75132.539545050612-3.78954505061198
47137.91136.2978949678691.61210503213140
48128.37128.2490357623640.120964237636472
49135.9138.16202255138-2.26202255138009
50122.19118.1432056279174.04679437208273
51113.08111.5337413153151.54625868468456
52136.2135.5476807297110.652319270289317
53138133.1140220198834.88597798011681
54115.24116.225979188531-0.985979188531487
55110.95108.4061731882922.54382681170776
5699.23102.519559633709-3.28955963370902
57102.39102.873308567429-0.483308567428939
58112.67112.784222231837-0.114222231837341

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Actuals, Interpolation, and Residuals \tabularnewline
Time or Index & Actuals & InterpolationForecast & ResidualsPrediction Error \tabularnewline
1 & 119.93 & 119.216410111613 & 0.713589888387024 \tabularnewline
2 & 94.76 & 97.5623320245071 & -2.80233202450712 \tabularnewline
3 & 95.26 & 98.2415039618835 & -2.98150396188351 \tabularnewline
4 & 117.96 & 120.879510277436 & -2.91951027743645 \tabularnewline
5 & 115.86 & 118.308468249154 & -2.4484682491536 \tabularnewline
6 & 111.44 & 111.213005709379 & 0.226994290621141 \tabularnewline
7 & 108.16 & 108.434036640471 & -0.274036640471373 \tabularnewline
8 & 108.77 & 104.155103668478 & 4.61489633152204 \tabularnewline
9 & 109.45 & 105.987869440740 & 3.46213055925976 \tabularnewline
10 & 124.83 & 117.914866341004 & 6.91513365899579 \tabularnewline
11 & 115.31 & 114.469530561403 & 0.840469438597184 \tabularnewline
12 & 109.49 & 110.931916971499 & -1.44191697149868 \tabularnewline
13 & 124.24 & 125.632077481162 & -1.39207748116161 \tabularnewline
14 & 92.85 & 93.943923747105 & -1.09392374710498 \tabularnewline
15 & 98.42 & 98.152682970981 & 0.267317029019022 \tabularnewline
16 & 120.88 & 120.058287941781 & 0.821712058218956 \tabularnewline
17 & 111.72 & 115.190392302949 & -3.47039230294921 \tabularnewline
18 & 116.1 & 116.748534360424 & -0.648534360424116 \tabularnewline
19 & 109.37 & 108.930480484322 & 0.43951951567756 \tabularnewline
20 & 111.65 & 110.597896762511 & 1.05210323748911 \tabularnewline
21 & 114.29 & 112.135060105654 & 2.15493989434616 \tabularnewline
22 & 133.68 & 131.314978766201 & 2.36502123379860 \tabularnewline
23 & 114.27 & 115.338443354064 & -1.06844335406398 \tabularnewline
24 & 126.49 & 126.134201230163 & 0.355798769836524 \tabularnewline
25 & 131 & 129.186836472206 & 1.81316352779402 \tabularnewline
26 & 104 & 105.087038863418 & -1.08703886341766 \tabularnewline
27 & 108.88 & 107.370312143940 & 1.50968785606044 \tabularnewline
28 & 128.48 & 127.021913414862 & 1.45808658513812 \tabularnewline
29 & 132.44 & 131.085024238177 & 1.35497576182347 \tabularnewline
30 & 128.04 & 127.129035701380 & 0.91096429862042 \tabularnewline
31 & 116.35 & 116.931665388839 & -0.581665388839237 \tabularnewline
32 & 120.93 & 122.967164401547 & -2.03716440154736 \tabularnewline
33 & 118.59 & 120.877978779315 & -2.28797877931461 \tabularnewline
34 & 133.1 & 138.476387610345 & -5.37638761034508 \tabularnewline
35 & 121.05 & 122.434131116665 & -1.38413111666460 \tabularnewline
36 & 127.62 & 126.654846035974 & 0.965153964025679 \tabularnewline
37 & 135.44 & 134.312653383639 & 1.12734661636065 \tabularnewline
38 & 114.88 & 113.943499737053 & 0.936500262947035 \tabularnewline
39 & 114.34 & 114.681759607881 & -0.341759607880524 \tabularnewline
40 & 128.85 & 128.86260763621 & -0.0126076362099425 \tabularnewline
41 & 138.9 & 139.222093189837 & -0.32209318983747 \tabularnewline
42 & 129.44 & 128.943445040286 & 0.496554959714038 \tabularnewline
43 & 114.96 & 117.087644298075 & -2.12764429807471 \tabularnewline
44 & 127.98 & 128.320275533755 & -0.340275533754762 \tabularnewline
45 & 127.03 & 129.875783106862 & -2.84578310686236 \tabularnewline
46 & 128.75 & 132.539545050612 & -3.78954505061198 \tabularnewline
47 & 137.91 & 136.297894967869 & 1.61210503213140 \tabularnewline
48 & 128.37 & 128.249035762364 & 0.120964237636472 \tabularnewline
49 & 135.9 & 138.16202255138 & -2.26202255138009 \tabularnewline
50 & 122.19 & 118.143205627917 & 4.04679437208273 \tabularnewline
51 & 113.08 & 111.533741315315 & 1.54625868468456 \tabularnewline
52 & 136.2 & 135.547680729711 & 0.652319270289317 \tabularnewline
53 & 138 & 133.114022019883 & 4.88597798011681 \tabularnewline
54 & 115.24 & 116.225979188531 & -0.985979188531487 \tabularnewline
55 & 110.95 & 108.406173188292 & 2.54382681170776 \tabularnewline
56 & 99.23 & 102.519559633709 & -3.28955963370902 \tabularnewline
57 & 102.39 & 102.873308567429 & -0.483308567428939 \tabularnewline
58 & 112.67 & 112.784222231837 & -0.114222231837341 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&T=4

[TABLE]
[ROW][C]Multiple Linear Regression - Actuals, Interpolation, and Residuals[/C][/ROW]
[ROW][C]Time or Index[/C][C]Actuals[/C][C]InterpolationForecast[/C][C]ResidualsPrediction Error[/C][/ROW]
[ROW][C]1[/C][C]119.93[/C][C]119.216410111613[/C][C]0.713589888387024[/C][/ROW]
[ROW][C]2[/C][C]94.76[/C][C]97.5623320245071[/C][C]-2.80233202450712[/C][/ROW]
[ROW][C]3[/C][C]95.26[/C][C]98.2415039618835[/C][C]-2.98150396188351[/C][/ROW]
[ROW][C]4[/C][C]117.96[/C][C]120.879510277436[/C][C]-2.91951027743645[/C][/ROW]
[ROW][C]5[/C][C]115.86[/C][C]118.308468249154[/C][C]-2.4484682491536[/C][/ROW]
[ROW][C]6[/C][C]111.44[/C][C]111.213005709379[/C][C]0.226994290621141[/C][/ROW]
[ROW][C]7[/C][C]108.16[/C][C]108.434036640471[/C][C]-0.274036640471373[/C][/ROW]
[ROW][C]8[/C][C]108.77[/C][C]104.155103668478[/C][C]4.61489633152204[/C][/ROW]
[ROW][C]9[/C][C]109.45[/C][C]105.987869440740[/C][C]3.46213055925976[/C][/ROW]
[ROW][C]10[/C][C]124.83[/C][C]117.914866341004[/C][C]6.91513365899579[/C][/ROW]
[ROW][C]11[/C][C]115.31[/C][C]114.469530561403[/C][C]0.840469438597184[/C][/ROW]
[ROW][C]12[/C][C]109.49[/C][C]110.931916971499[/C][C]-1.44191697149868[/C][/ROW]
[ROW][C]13[/C][C]124.24[/C][C]125.632077481162[/C][C]-1.39207748116161[/C][/ROW]
[ROW][C]14[/C][C]92.85[/C][C]93.943923747105[/C][C]-1.09392374710498[/C][/ROW]
[ROW][C]15[/C][C]98.42[/C][C]98.152682970981[/C][C]0.267317029019022[/C][/ROW]
[ROW][C]16[/C][C]120.88[/C][C]120.058287941781[/C][C]0.821712058218956[/C][/ROW]
[ROW][C]17[/C][C]111.72[/C][C]115.190392302949[/C][C]-3.47039230294921[/C][/ROW]
[ROW][C]18[/C][C]116.1[/C][C]116.748534360424[/C][C]-0.648534360424116[/C][/ROW]
[ROW][C]19[/C][C]109.37[/C][C]108.930480484322[/C][C]0.43951951567756[/C][/ROW]
[ROW][C]20[/C][C]111.65[/C][C]110.597896762511[/C][C]1.05210323748911[/C][/ROW]
[ROW][C]21[/C][C]114.29[/C][C]112.135060105654[/C][C]2.15493989434616[/C][/ROW]
[ROW][C]22[/C][C]133.68[/C][C]131.314978766201[/C][C]2.36502123379860[/C][/ROW]
[ROW][C]23[/C][C]114.27[/C][C]115.338443354064[/C][C]-1.06844335406398[/C][/ROW]
[ROW][C]24[/C][C]126.49[/C][C]126.134201230163[/C][C]0.355798769836524[/C][/ROW]
[ROW][C]25[/C][C]131[/C][C]129.186836472206[/C][C]1.81316352779402[/C][/ROW]
[ROW][C]26[/C][C]104[/C][C]105.087038863418[/C][C]-1.08703886341766[/C][/ROW]
[ROW][C]27[/C][C]108.88[/C][C]107.370312143940[/C][C]1.50968785606044[/C][/ROW]
[ROW][C]28[/C][C]128.48[/C][C]127.021913414862[/C][C]1.45808658513812[/C][/ROW]
[ROW][C]29[/C][C]132.44[/C][C]131.085024238177[/C][C]1.35497576182347[/C][/ROW]
[ROW][C]30[/C][C]128.04[/C][C]127.129035701380[/C][C]0.91096429862042[/C][/ROW]
[ROW][C]31[/C][C]116.35[/C][C]116.931665388839[/C][C]-0.581665388839237[/C][/ROW]
[ROW][C]32[/C][C]120.93[/C][C]122.967164401547[/C][C]-2.03716440154736[/C][/ROW]
[ROW][C]33[/C][C]118.59[/C][C]120.877978779315[/C][C]-2.28797877931461[/C][/ROW]
[ROW][C]34[/C][C]133.1[/C][C]138.476387610345[/C][C]-5.37638761034508[/C][/ROW]
[ROW][C]35[/C][C]121.05[/C][C]122.434131116665[/C][C]-1.38413111666460[/C][/ROW]
[ROW][C]36[/C][C]127.62[/C][C]126.654846035974[/C][C]0.965153964025679[/C][/ROW]
[ROW][C]37[/C][C]135.44[/C][C]134.312653383639[/C][C]1.12734661636065[/C][/ROW]
[ROW][C]38[/C][C]114.88[/C][C]113.943499737053[/C][C]0.936500262947035[/C][/ROW]
[ROW][C]39[/C][C]114.34[/C][C]114.681759607881[/C][C]-0.341759607880524[/C][/ROW]
[ROW][C]40[/C][C]128.85[/C][C]128.86260763621[/C][C]-0.0126076362099425[/C][/ROW]
[ROW][C]41[/C][C]138.9[/C][C]139.222093189837[/C][C]-0.32209318983747[/C][/ROW]
[ROW][C]42[/C][C]129.44[/C][C]128.943445040286[/C][C]0.496554959714038[/C][/ROW]
[ROW][C]43[/C][C]114.96[/C][C]117.087644298075[/C][C]-2.12764429807471[/C][/ROW]
[ROW][C]44[/C][C]127.98[/C][C]128.320275533755[/C][C]-0.340275533754762[/C][/ROW]
[ROW][C]45[/C][C]127.03[/C][C]129.875783106862[/C][C]-2.84578310686236[/C][/ROW]
[ROW][C]46[/C][C]128.75[/C][C]132.539545050612[/C][C]-3.78954505061198[/C][/ROW]
[ROW][C]47[/C][C]137.91[/C][C]136.297894967869[/C][C]1.61210503213140[/C][/ROW]
[ROW][C]48[/C][C]128.37[/C][C]128.249035762364[/C][C]0.120964237636472[/C][/ROW]
[ROW][C]49[/C][C]135.9[/C][C]138.16202255138[/C][C]-2.26202255138009[/C][/ROW]
[ROW][C]50[/C][C]122.19[/C][C]118.143205627917[/C][C]4.04679437208273[/C][/ROW]
[ROW][C]51[/C][C]113.08[/C][C]111.533741315315[/C][C]1.54625868468456[/C][/ROW]
[ROW][C]52[/C][C]136.2[/C][C]135.547680729711[/C][C]0.652319270289317[/C][/ROW]
[ROW][C]53[/C][C]138[/C][C]133.114022019883[/C][C]4.88597798011681[/C][/ROW]
[ROW][C]54[/C][C]115.24[/C][C]116.225979188531[/C][C]-0.985979188531487[/C][/ROW]
[ROW][C]55[/C][C]110.95[/C][C]108.406173188292[/C][C]2.54382681170776[/C][/ROW]
[ROW][C]56[/C][C]99.23[/C][C]102.519559633709[/C][C]-3.28955963370902[/C][/ROW]
[ROW][C]57[/C][C]102.39[/C][C]102.873308567429[/C][C]-0.483308567428939[/C][/ROW]
[ROW][C]58[/C][C]112.67[/C][C]112.784222231837[/C][C]-0.114222231837341[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=4

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

As an alternative you can also use a QR Code:  

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

Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolationForecastResidualsPrediction Error
1119.93119.2164101116130.713589888387024
294.7697.5623320245071-2.80233202450712
395.2698.2415039618835-2.98150396188351
4117.96120.879510277436-2.91951027743645
5115.86118.308468249154-2.4484682491536
6111.44111.2130057093790.226994290621141
7108.16108.434036640471-0.274036640471373
8108.77104.1551036684784.61489633152204
9109.45105.9878694407403.46213055925976
10124.83117.9148663410046.91513365899579
11115.31114.4695305614030.840469438597184
12109.49110.931916971499-1.44191697149868
13124.24125.632077481162-1.39207748116161
1492.8593.943923747105-1.09392374710498
1598.4298.1526829709810.267317029019022
16120.88120.0582879417810.821712058218956
17111.72115.190392302949-3.47039230294921
18116.1116.748534360424-0.648534360424116
19109.37108.9304804843220.43951951567756
20111.65110.5978967625111.05210323748911
21114.29112.1350601056542.15493989434616
22133.68131.3149787662012.36502123379860
23114.27115.338443354064-1.06844335406398
24126.49126.1342012301630.355798769836524
25131129.1868364722061.81316352779402
26104105.087038863418-1.08703886341766
27108.88107.3703121439401.50968785606044
28128.48127.0219134148621.45808658513812
29132.44131.0850242381771.35497576182347
30128.04127.1290357013800.91096429862042
31116.35116.931665388839-0.581665388839237
32120.93122.967164401547-2.03716440154736
33118.59120.877978779315-2.28797877931461
34133.1138.476387610345-5.37638761034508
35121.05122.434131116665-1.38413111666460
36127.62126.6548460359740.965153964025679
37135.44134.3126533836391.12734661636065
38114.88113.9434997370530.936500262947035
39114.34114.681759607881-0.341759607880524
40128.85128.86260763621-0.0126076362099425
41138.9139.222093189837-0.32209318983747
42129.44128.9434450402860.496554959714038
43114.96117.087644298075-2.12764429807471
44127.98128.320275533755-0.340275533754762
45127.03129.875783106862-2.84578310686236
46128.75132.539545050612-3.78954505061198
47137.91136.2978949678691.61210503213140
48128.37128.2490357623640.120964237636472
49135.9138.16202255138-2.26202255138009
50122.19118.1432056279174.04679437208273
51113.08111.5337413153151.54625868468456
52136.2135.5476807297110.652319270289317
53138133.1140220198834.88597798011681
54115.24116.225979188531-0.985979188531487
55110.95108.4061731882922.54382681170776
5699.23102.519559633709-3.28955963370902
57102.39102.873308567429-0.483308567428939
58112.67112.784222231837-0.114222231837341







Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.4517427237684340.9034854475368690.548257276231566
200.3871567936930910.7743135873861810.612843206306909
210.31715034372780.63430068745560.6828496562722
220.3768086832416540.7536173664833070.623191316758346
230.2851609558182190.5703219116364380.714839044181781
240.5962868790607390.8074262418785230.403713120939262
250.7628765604026850.4742468791946310.237123439597315
260.7007652017073460.5984695965853070.299234798292653
270.6907703627272570.6184592745454860.309229637272743
280.6205512915075810.7588974169848370.379448708492419
290.657466436138810.6850671277223790.342533563861189
300.5695940054232970.8608119891534050.430405994576703
310.5052275388004120.9895449223991770.494772461199588
320.5965537156743670.8068925686512650.403446284325633
330.6812065375167120.6375869249665770.318793462483288
340.8194171369109290.3611657261781410.180582863089071
350.719778776644510.5604424467109810.280221223355491
360.6386671517318450.722665696536310.361332848268155
370.6945000987686530.6109998024626930.305499901231347
380.5785466661331620.8429066677336760.421453333866838
390.4033528343136030.8067056686272050.596647165686397

\begin{tabular}{lllllllll}
\hline
Goldfeld-Quandt test for Heteroskedasticity \tabularnewline
p-values & Alternative Hypothesis \tabularnewline
breakpoint index & greater & 2-sided & less \tabularnewline
19 & 0.451742723768434 & 0.903485447536869 & 0.548257276231566 \tabularnewline
20 & 0.387156793693091 & 0.774313587386181 & 0.612843206306909 \tabularnewline
21 & 0.3171503437278 & 0.6343006874556 & 0.6828496562722 \tabularnewline
22 & 0.376808683241654 & 0.753617366483307 & 0.623191316758346 \tabularnewline
23 & 0.285160955818219 & 0.570321911636438 & 0.714839044181781 \tabularnewline
24 & 0.596286879060739 & 0.807426241878523 & 0.403713120939262 \tabularnewline
25 & 0.762876560402685 & 0.474246879194631 & 0.237123439597315 \tabularnewline
26 & 0.700765201707346 & 0.598469596585307 & 0.299234798292653 \tabularnewline
27 & 0.690770362727257 & 0.618459274545486 & 0.309229637272743 \tabularnewline
28 & 0.620551291507581 & 0.758897416984837 & 0.379448708492419 \tabularnewline
29 & 0.65746643613881 & 0.685067127722379 & 0.342533563861189 \tabularnewline
30 & 0.569594005423297 & 0.860811989153405 & 0.430405994576703 \tabularnewline
31 & 0.505227538800412 & 0.989544922399177 & 0.494772461199588 \tabularnewline
32 & 0.596553715674367 & 0.806892568651265 & 0.403446284325633 \tabularnewline
33 & 0.681206537516712 & 0.637586924966577 & 0.318793462483288 \tabularnewline
34 & 0.819417136910929 & 0.361165726178141 & 0.180582863089071 \tabularnewline
35 & 0.71977877664451 & 0.560442446710981 & 0.280221223355491 \tabularnewline
36 & 0.638667151731845 & 0.72266569653631 & 0.361332848268155 \tabularnewline
37 & 0.694500098768653 & 0.610999802462693 & 0.305499901231347 \tabularnewline
38 & 0.578546666133162 & 0.842906667733676 & 0.421453333866838 \tabularnewline
39 & 0.403352834313603 & 0.806705668627205 & 0.596647165686397 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&T=5

[TABLE]
[ROW][C]Goldfeld-Quandt test for Heteroskedasticity[/C][/ROW]
[ROW][C]p-values[/C][C]Alternative Hypothesis[/C][/ROW]
[ROW][C]breakpoint index[/C][C]greater[/C][C]2-sided[/C][C]less[/C][/ROW]
[ROW][C]19[/C][C]0.451742723768434[/C][C]0.903485447536869[/C][C]0.548257276231566[/C][/ROW]
[ROW][C]20[/C][C]0.387156793693091[/C][C]0.774313587386181[/C][C]0.612843206306909[/C][/ROW]
[ROW][C]21[/C][C]0.3171503437278[/C][C]0.6343006874556[/C][C]0.6828496562722[/C][/ROW]
[ROW][C]22[/C][C]0.376808683241654[/C][C]0.753617366483307[/C][C]0.623191316758346[/C][/ROW]
[ROW][C]23[/C][C]0.285160955818219[/C][C]0.570321911636438[/C][C]0.714839044181781[/C][/ROW]
[ROW][C]24[/C][C]0.596286879060739[/C][C]0.807426241878523[/C][C]0.403713120939262[/C][/ROW]
[ROW][C]25[/C][C]0.762876560402685[/C][C]0.474246879194631[/C][C]0.237123439597315[/C][/ROW]
[ROW][C]26[/C][C]0.700765201707346[/C][C]0.598469596585307[/C][C]0.299234798292653[/C][/ROW]
[ROW][C]27[/C][C]0.690770362727257[/C][C]0.618459274545486[/C][C]0.309229637272743[/C][/ROW]
[ROW][C]28[/C][C]0.620551291507581[/C][C]0.758897416984837[/C][C]0.379448708492419[/C][/ROW]
[ROW][C]29[/C][C]0.65746643613881[/C][C]0.685067127722379[/C][C]0.342533563861189[/C][/ROW]
[ROW][C]30[/C][C]0.569594005423297[/C][C]0.860811989153405[/C][C]0.430405994576703[/C][/ROW]
[ROW][C]31[/C][C]0.505227538800412[/C][C]0.989544922399177[/C][C]0.494772461199588[/C][/ROW]
[ROW][C]32[/C][C]0.596553715674367[/C][C]0.806892568651265[/C][C]0.403446284325633[/C][/ROW]
[ROW][C]33[/C][C]0.681206537516712[/C][C]0.637586924966577[/C][C]0.318793462483288[/C][/ROW]
[ROW][C]34[/C][C]0.819417136910929[/C][C]0.361165726178141[/C][C]0.180582863089071[/C][/ROW]
[ROW][C]35[/C][C]0.71977877664451[/C][C]0.560442446710981[/C][C]0.280221223355491[/C][/ROW]
[ROW][C]36[/C][C]0.638667151731845[/C][C]0.72266569653631[/C][C]0.361332848268155[/C][/ROW]
[ROW][C]37[/C][C]0.694500098768653[/C][C]0.610999802462693[/C][C]0.305499901231347[/C][/ROW]
[ROW][C]38[/C][C]0.578546666133162[/C][C]0.842906667733676[/C][C]0.421453333866838[/C][/ROW]
[ROW][C]39[/C][C]0.403352834313603[/C][C]0.806705668627205[/C][C]0.596647165686397[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=5

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

As an alternative you can also use a QR Code:  

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

Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.4517427237684340.9034854475368690.548257276231566
200.3871567936930910.7743135873861810.612843206306909
210.31715034372780.63430068745560.6828496562722
220.3768086832416540.7536173664833070.623191316758346
230.2851609558182190.5703219116364380.714839044181781
240.5962868790607390.8074262418785230.403713120939262
250.7628765604026850.4742468791946310.237123439597315
260.7007652017073460.5984695965853070.299234798292653
270.6907703627272570.6184592745454860.309229637272743
280.6205512915075810.7588974169848370.379448708492419
290.657466436138810.6850671277223790.342533563861189
300.5695940054232970.8608119891534050.430405994576703
310.5052275388004120.9895449223991770.494772461199588
320.5965537156743670.8068925686512650.403446284325633
330.6812065375167120.6375869249665770.318793462483288
340.8194171369109290.3611657261781410.180582863089071
350.719778776644510.5604424467109810.280221223355491
360.6386671517318450.722665696536310.361332848268155
370.6945000987686530.6109998024626930.305499901231347
380.5785466661331620.8429066677336760.421453333866838
390.4033528343136030.8067056686272050.596647165686397







Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level00OK
10% type I error level00OK

\begin{tabular}{lllllllll}
\hline
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity \tabularnewline
Description & # significant tests & % significant tests & OK/NOK \tabularnewline
1% type I error level & 0 & 0 & OK \tabularnewline
5% type I error level & 0 & 0 & OK \tabularnewline
10% type I error level & 0 & 0 & OK \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=57933&T=6

[TABLE]
[ROW][C]Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity[/C][/ROW]
[ROW][C]Description[/C][C]# significant tests[/C][C]% significant tests[/C][C]OK/NOK[/C][/ROW]
[ROW][C]1% type I error level[/C][C]0[/C][C]0[/C][C]OK[/C][/ROW]
[ROW][C]5% type I error level[/C][C]0[/C][C]0[/C][C]OK[/C][/ROW]
[ROW][C]10% type I error level[/C][C]0[/C][C]0[/C][C]OK[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=57933&T=6

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

As an alternative you can also use a QR Code:  

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

Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level00OK
10% type I error level00OK



Parameters (Session):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = Linear Trend ;
Parameters (R input):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = Linear Trend ;
R code (references can be found in the software module):
library(lattice)
library(lmtest)
n25 <- 25 #minimum number of obs. for Goldfeld-Quandt test
par1 <- as.numeric(par1)
x <- t(y)
k <- length(x[1,])
n <- length(x[,1])
x1 <- cbind(x[,par1], x[,1:k!=par1])
mycolnames <- c(colnames(x)[par1], colnames(x)[1:k!=par1])
colnames(x1) <- mycolnames #colnames(x)[par1]
x <- x1
if (par3 == 'First Differences'){
x2 <- array(0, dim=c(n-1,k), dimnames=list(1:(n-1), paste('(1-B)',colnames(x),sep='')))
for (i in 1:n-1) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
}
if (par2 == 'Include Monthly Dummies'){
x2 <- array(0, dim=c(n,11), dimnames=list(1:n, paste('M', seq(1:11), sep ='')))
for (i in 1:11){
x2[seq(i,n,12),i] <- 1
}
x <- cbind(x, x2)
}
if (par2 == 'Include Quarterly Dummies'){
x2 <- array(0, dim=c(n,3), dimnames=list(1:n, paste('Q', seq(1:3), sep ='')))
for (i in 1:3){
x2[seq(i,n,4),i] <- 1
}
x <- cbind(x, x2)
}
k <- length(x[1,])
if (par3 == 'Linear Trend'){
x <- cbind(x, c(1:n))
colnames(x)[k+1] <- 't'
}
x
k <- length(x[1,])
df <- as.data.frame(x)
(mylm <- lm(df))
(mysum <- summary(mylm))
if (n > n25) {
kp3 <- k + 3
nmkm3 <- n - k - 3
gqarr <- array(NA, dim=c(nmkm3-kp3+1,3))
numgqtests <- 0
numsignificant1 <- 0
numsignificant5 <- 0
numsignificant10 <- 0
for (mypoint in kp3:nmkm3) {
j <- 0
numgqtests <- numgqtests + 1
for (myalt in c('greater', 'two.sided', 'less')) {
j <- j + 1
gqarr[mypoint-kp3+1,j] <- gqtest(mylm, point=mypoint, alternative=myalt)$p.value
}
if (gqarr[mypoint-kp3+1,2] < 0.01) numsignificant1 <- numsignificant1 + 1
if (gqarr[mypoint-kp3+1,2] < 0.05) numsignificant5 <- numsignificant5 + 1
if (gqarr[mypoint-kp3+1,2] < 0.10) numsignificant10 <- numsignificant10 + 1
}
gqarr
}
bitmap(file='test0.png')
plot(x[,1], type='l', main='Actuals and Interpolation', ylab='value of Actuals and Interpolation (dots)', xlab='time or index')
points(x[,1]-mysum$resid)
grid()
dev.off()
bitmap(file='test1.png')
plot(mysum$resid, type='b', pch=19, main='Residuals', ylab='value of Residuals', xlab='time or index')
grid()
dev.off()
bitmap(file='test2.png')
hist(mysum$resid, main='Residual Histogram', xlab='values of Residuals')
grid()
dev.off()
bitmap(file='test3.png')
densityplot(~mysum$resid,col='black',main='Residual Density Plot', xlab='values of Residuals')
dev.off()
bitmap(file='test4.png')
qqnorm(mysum$resid, main='Residual Normal Q-Q Plot')
qqline(mysum$resid)
grid()
dev.off()
(myerror <- as.ts(mysum$resid))
bitmap(file='test5.png')
dum <- cbind(lag(myerror,k=1),myerror)
dum
dum1 <- dum[2:length(myerror),]
dum1
z <- as.data.frame(dum1)
z
plot(z,main=paste('Residual Lag plot, lowess, and regression line'), ylab='values of Residuals', xlab='lagged values of Residuals')
lines(lowess(z))
abline(lm(z))
grid()
dev.off()
bitmap(file='test6.png')
acf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Autocorrelation Function')
grid()
dev.off()
bitmap(file='test7.png')
pacf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Partial Autocorrelation Function')
grid()
dev.off()
bitmap(file='test8.png')
opar <- par(mfrow = c(2,2), oma = c(0, 0, 1.1, 0))
plot(mylm, las = 1, sub='Residual Diagnostics')
par(opar)
dev.off()
if (n > n25) {
bitmap(file='test9.png')
plot(kp3:nmkm3,gqarr[,2], main='Goldfeld-Quandt test',ylab='2-sided p-value',xlab='breakpoint')
grid()
dev.off()
}
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Estimated Regression Equation', 1, TRUE)
a<-table.row.end(a)
myeq <- colnames(x)[1]
myeq <- paste(myeq, '[t] = ', sep='')
for (i in 1:k){
if (mysum$coefficients[i,1] > 0) myeq <- paste(myeq, '+', '')
myeq <- paste(myeq, mysum$coefficients[i,1], sep=' ')
if (rownames(mysum$coefficients)[i] != '(Intercept)') {
myeq <- paste(myeq, rownames(mysum$coefficients)[i], sep='')
if (rownames(mysum$coefficients)[i] != 't') myeq <- paste(myeq, '[t]', sep='')
}
}
myeq <- paste(myeq, ' + e[t]')
a<-table.row.start(a)
a<-table.element(a, myeq)
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,hyperlink('ols1.htm','Multiple Linear Regression - Ordinary Least Squares',''), 6, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Variable',header=TRUE)
a<-table.element(a,'Parameter',header=TRUE)
a<-table.element(a,'S.D.',header=TRUE)
a<-table.element(a,'T-STAT
H0: parameter = 0',header=TRUE)
a<-table.element(a,'2-tail p-value',header=TRUE)
a<-table.element(a,'1-tail p-value',header=TRUE)
a<-table.row.end(a)
for (i in 1:k){
a<-table.row.start(a)
a<-table.element(a,rownames(mysum$coefficients)[i],header=TRUE)
a<-table.element(a,mysum$coefficients[i,1])
a<-table.element(a, round(mysum$coefficients[i,2],6))
a<-table.element(a, round(mysum$coefficients[i,3],4))
a<-table.element(a, round(mysum$coefficients[i,4],6))
a<-table.element(a, round(mysum$coefficients[i,4]/2,6))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Regression Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple R',1,TRUE)
a<-table.element(a, sqrt(mysum$r.squared))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'R-squared',1,TRUE)
a<-table.element(a, mysum$r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Adjusted R-squared',1,TRUE)
a<-table.element(a, mysum$adj.r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (value)',1,TRUE)
a<-table.element(a, mysum$fstatistic[1])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF numerator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[2])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF denominator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[3])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'p-value',1,TRUE)
a<-table.element(a, 1-pf(mysum$fstatistic[1],mysum$fstatistic[2],mysum$fstatistic[3]))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Residual Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Residual Standard Deviation',1,TRUE)
a<-table.element(a, mysum$sigma)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Sum Squared Residuals',1,TRUE)
a<-table.element(a, sum(myerror*myerror))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Actuals, Interpolation, and Residuals', 4, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Time or Index', 1, TRUE)
a<-table.element(a, 'Actuals', 1, TRUE)
a<-table.element(a, 'Interpolation
Forecast', 1, TRUE)
a<-table.element(a, 'Residuals
Prediction Error', 1, TRUE)
a<-table.row.end(a)
for (i in 1:n) {
a<-table.row.start(a)
a<-table.element(a,i, 1, TRUE)
a<-table.element(a,x[i])
a<-table.element(a,x[i]-mysum$resid[i])
a<-table.element(a,mysum$resid[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable4.tab')
if (n > n25) {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-values',header=TRUE)
a<-table.element(a,'Alternative Hypothesis',3,header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'breakpoint index',header=TRUE)
a<-table.element(a,'greater',header=TRUE)
a<-table.element(a,'2-sided',header=TRUE)
a<-table.element(a,'less',header=TRUE)
a<-table.row.end(a)
for (mypoint in kp3:nmkm3) {
a<-table.row.start(a)
a<-table.element(a,mypoint,header=TRUE)
a<-table.element(a,gqarr[mypoint-kp3+1,1])
a<-table.element(a,gqarr[mypoint-kp3+1,2])
a<-table.element(a,gqarr[mypoint-kp3+1,3])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable5.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Description',header=TRUE)
a<-table.element(a,'# significant tests',header=TRUE)
a<-table.element(a,'% significant tests',header=TRUE)
a<-table.element(a,'OK/NOK',header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'1% type I error level',header=TRUE)
a<-table.element(a,numsignificant1)
a<-table.element(a,numsignificant1/numgqtests)
if (numsignificant1/numgqtests < 0.01) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'5% type I error level',header=TRUE)
a<-table.element(a,numsignificant5)
a<-table.element(a,numsignificant5/numgqtests)
if (numsignificant5/numgqtests < 0.05) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'10% type I error level',header=TRUE)
a<-table.element(a,numsignificant10)
a<-table.element(a,numsignificant10/numgqtests)
if (numsignificant10/numgqtests < 0.1) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable6.tab')
}