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_multipleregression.wasp
Title produced by softwareMultiple Regression
Date of computationFri, 16 Nov 2012 06:06:26 -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/2012/Nov/16/t13530640243zr18nbjlq2b2ai.htm/, Retrieved Sat, 27 Apr 2024 06:58:51 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=189863, Retrieved Sat, 27 Apr 2024 06:58:51 +0000
QR Codes:

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

Tree of Dependent Computations

Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [Decreasing Compet...] [2010-11-17 09:04:39] [b98453cac15ba1066b407e146608df68]
- R PD    [Multiple Regression] [WS7: Multiple Reg...] [2012-11-16 11:06:26] [ed5db9d6207bcb51aca69986e23f030b] [Current]
-   P       [Multiple Regression] [WS7: Lineaire trend] [2012-11-18 11:41:30] [b43eb6e2e60f3928e6b8367ff6c5b484]
Feedback Forum

Post a new message

Dataset

Dataseries X:
Download CSV
Histogram
Boxplots 
2001	100	95	102	103	91	99	101	91	114	101	103	85
2001	94	97	99	117	85	97	97	87	99	99	97	94
2001	105	97	108	115	110	113	108	103	98	104	110	107
2001	95	97	92	74	90	100	95	97	91	99	97	98
2001	103	103	99	74	103	105	99	96	111	101	103	111
2001	103	101	102	81	119	109	101	105	104	102	106	115
2001	100	96	87	86	76	91	92	74	100	93	89	76
2001	108	94	71	114	93	89	92	87	108	97	85	100
2001	108	97	105	102	105	105	100	105	113	91	100	103
2001	120	101	115	85	92	120	106	118	113	97	106	117
2001	112	77	103	63	75	107	99	102	114	94	95	101
2001	102	93	75	61	61	84	84	101	109	90	74	73
2002	105	45	97	87	80	101	106	86	116	105	94	84
2002	101	48	95	97	85	105	101	83	102	103	90	90
2002	108	52	99	88	94	119	113	92	107	112	99	105
2002	107	49	100	67	78	114	110	87	111	114	100	111
2002	109	53	92	59	92	114	103	94	122	111	96	110
2002	110	60	94	63	90	119	107	94	123	106	102	116
2002	111	51	89	86	72	99	98	75	108	112	88	85
2002	110	42	67	99	77	91	90	85	115	102	78	92
2002	117	56	109	85	76	121	105	104	120	103	99	117
2002	130	51	113	74	89	128	116	109	117	105	107	119
2002	114	53	106	55	55	112	102	121	115	101	93	100
2002	113	55	78	54	47	93	88	124	116	101	74	71
2003	110	44	102	81	91	108	114	88	118	117	96	82
2003	107	51	97	88	85	107	104	86	98	109	99	90
2003	110	52	96	75	89	115	111	98	121	120	103	109
2003	113	54	99	55	90	121	111	94	118	115	102	112
2003	106	50	86	47	72	112	102	102	120	107	96	103
2003	118	57	92	54	83	123	106	96	111	110	106	116
2003	118	49	86	71	72	101	104	79	117	110	95	89
2003	114	41	62	79	75	87	94	95	110	105	82	91
2003	121	58	105	77	85	124	116	106	107	116	109	121
2003	130	63	108	57	81	125	118	116	115	116	114	123
2003	115	54	96	40	69	111	101	101	106	111	95	98
2003	118	55	80	44	68	98	101	108	115	120	85	81
2004	111	56	95	67	94	102	109	92	112	111	98	84
2004	108	56	94	75	97	105	108	89	106	115	100	92
2004	124	70	108	75	102	128	124	109	106	125	119	116
2004	115	69	97	49	94	125	117	97	114	116	109	112
2004	113	57	89	37	89	116	104	99	109	113	99	106
2004	128	68	107	50	114	131	121	110	100	122	119	131
2004	117	53	87	63	82	98	101	76	105	123	94	83
2004	119	48	70	76	96	89	105	91	100	117	88	98
2004	130	61	111	69	104	133	121	105	104	136	116	120
2004	126	62	105	49	88	114	116	103	112	121	109	121
2004	125	58	99	40	85	113	106	108	97	120	103	107
2004	131	51	84	39	87	104	105	122	107	126	93	89
2005	116	51	87	54	86	108	107	92	104	116	100	81
2005	109	48	92	71	89	106	101	95	98	108	102	90
2005	124	59	98	68	105	117	113	106	100	117	113	103
2005	119	54	95	43	83	123	109	98	97	113	112	117
2005	119	56	85	42	87	114	103	110	81	113	104	110
2005	131	60	100	48	112	132	116	107	73	126	118	130
2005	111	51	79	58	97	92	98	69	89	114	94	79
2005	125	51	66	76	89	94	99	95	96	113	95	101
2005	132	56	105	57	109	121	117	114	97	112	121	123
2005	127	53	96	44	88	114	107	104	98	113	114	111
2005	132	53	103	40	91	116	107	110	89	116	114	109
2005	131	48	83	36	79	98	102	112	98	112	99	89
2006	122	50	91	60	115	112	103	92	91	119	112	87
2006	113	49	95	73	119	109	101	97	86	117	111	95
2006	134	55	109	71	125	133	117	114	97	125	126	119
2006	119	50	92	45	96	118	103	93	102	113	112	110
2006	129	57	99	45	117	132	106	115	80	120	124	124
2006	131	65	110	48	120	134	111	112	71	114	127	133
2006	117	53	88	60	104	97	94	76	91	114	101	84
2006	131	42	73	72	121	100	101	101	102	118	102	105
2006	132	56	111	63	127	128	111	119	91	117	126	128
2006	141	58	112	32	118	135	114	118	94	121	129	127
2006	138	54	111	34	108	131	110	120	53	115	122	120
2006	129	51	84	24	89	107	100	120	77	117	100	93
2007	127	59	102	65	137	122	104	99	70	119	122	98
2007	121	49	102	73	142	121	106	103	65	115	120	106
2007	139	61	114	62	137	141	116	118	89	126	137	122
2007	129	52	99	32	123	125	104	103	70	118	124	116
2007	131	58	100	31	126	130	107	114	78	118	130	122
2007	136	66	110	37	148	159	113	116	78	115	137	134
2007	129	62	93	48	116	111	104	84	73	122	114	88
2007	133	45	77	54	139	110	103	106	83	117	109	110
2007	136	52	108	44	151	133	109	117	74	106	126	122
2007	151	59	120	41	124	135	123	125	102	111	141	135
2007	145	58	106	32	109	119	110	123	54	114	130	116
2007	134	45	78	31	112	94	94	119	79	114	98	85
2008	136	65	100	49	136	118	114	100	86	125	130	106
2008	129	64	102	54	136	115	110	100	87	125	130	115
2008	129	69	97	44	139	114	110	103	79	120	125	111
2008	139	71	101	31	138	131	113	104	64	121	136	133
2008	133	63	89	24	142	117	105	99	70	111	124	124
2008	133	74	93	37	144	123	108	101	75	124	133	131
2008	137	63	89	38	147	106	101	73	72	120	121	97
2008	127	52	62	42	201	89	95	86	83	126	102	97
2008	144	73	96	36	196	116	112	110	74	116	131	131
2008	150	67	95	31	170	116	113	115	82	117	130	127
2008	132	63	80	24	177	97	96	101	78	106	106	101
2008	139	70	67	29	190	82	93	112	77	102	93	88
2009	123	66	71	38	138	92	91	89	77	106	100	76
2009	122	60	73	44	133	90	91	93	72	97	99	87
2009	136	66	81	33	131	99	101	103	76	108	112	110
2009	133	68	77	23	110	99	98	91	75	99	109	102
2009	127	68	68	19	124	89	94	88	69	101	102	99
2009	139	81	77	27	150	106	102	93	67	106	116	117
2009	131	75	73	29	163	84	96	65	68	105	103	83
2009	132	55	54	34	138	78	92	82	73	103	91	90
2009	136	79	85	26	133	101	106	102	69	102	119	116
2009	142	52	86	28	123	100	105	102	76	107	117	117
2009	133	56	79	18	107	96	97	122	67	100	106	96
2009	132	66	67	24	122	80	94	105	69	101	92	73
2010	121	66	72	29	141	87	95	83	68	105	102	66
2010	124	59	76	38	136	90	95	85	64	118	104	73
2010	145	78	90	33	140	113	114	102	69	129	124	114
2010	135	70	84	22	109	105	107	86	67	124	118	107
2010	128	65	75	20	109	100	100	84	71	128	109	102
2010	142	88	90	31	128	116	112	93	58	129	129	125
2010	130	75	77	27	162	89	101	64	57	128	105	80
2010	131	62	60	28	147	87	100	81	69	125	100	95
2010	141	85	92	28	148	111	111	100	76	125	125	120
2010	140	82	88	25	103	110	107	96	74	130	116	117
2010	142	83	83	21	102	104	105	93	77	125	112	99
2010	140	78	69	24	100	85	104	102	81	122	97	64
2011	132	81	73	28	117	96	106	78	77	129	107	82
2011	132	75	78	33	139	99	105	92	64	124	114	97
2011	151	91	92	31	122	117	114	99	67	144	130	121

Tables (Output of Computation)





Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time11 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 & 11 seconds \tabularnewline
R Server & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&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]11 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=189863&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=189863&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 time11 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net






Multiple Linear Regression - Estimated Regression Equation
Textiel[t] = + 5473.28781057935 -2.73884297294589Jaar[t] -0.0131404014908397Voedingsmiddelen[t] + 0.0539397409470382Tabaksproducten[t] -0.00183893461659913Kleding[t] -0.0425609080232513Leer[t] + 0.338544802310588Hout[t] + 0.510298529548832Papier[t] + 0.0555306393401868Uitgeverijen[t] -0.0415552936278247Cokes[t] -0.206153169653918Chemische[t] + 0.708359840363173Rubber[t] -0.304606231203332Nietmetaalhoudende[t] + e[t]

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Estimated Regression Equation \tabularnewline
Textiel[t] =  +  5473.28781057935 -2.73884297294589Jaar[t] -0.0131404014908397Voedingsmiddelen[t] +  0.0539397409470382Tabaksproducten[t] -0.00183893461659913Kleding[t] -0.0425609080232513Leer[t] +  0.338544802310588Hout[t] +  0.510298529548832Papier[t] +  0.0555306393401868Uitgeverijen[t] -0.0415552936278247Cokes[t] -0.206153169653918Chemische[t] +  0.708359840363173Rubber[t] -0.304606231203332Nietmetaalhoudende[t]  + e[t] \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&T=1

[TABLE]
[ROW][C]Multiple Linear Regression - Estimated Regression Equation[/C][/ROW]
[ROW][C]Textiel[t] =  +  5473.28781057935 -2.73884297294589Jaar[t] -0.0131404014908397Voedingsmiddelen[t] +  0.0539397409470382Tabaksproducten[t] -0.00183893461659913Kleding[t] -0.0425609080232513Leer[t] +  0.338544802310588Hout[t] +  0.510298529548832Papier[t] +  0.0555306393401868Uitgeverijen[t] -0.0415552936278247Cokes[t] -0.206153169653918Chemische[t] +  0.708359840363173Rubber[t] -0.304606231203332Nietmetaalhoudende[t]  + e[t][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=189863&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=189863&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:

Multiple Linear Regression - Estimated Regression Equation
Textiel[t] = + 5473.28781057935 -2.73884297294589Jaar[t] -0.0131404014908397Voedingsmiddelen[t] + 0.0539397409470382Tabaksproducten[t] -0.00183893461659913Kleding[t] -0.0425609080232513Leer[t] + 0.338544802310588Hout[t] + 0.510298529548832Papier[t] + 0.0555306393401868Uitgeverijen[t] -0.0415552936278247Cokes[t] -0.206153169653918Chemische[t] + 0.708359840363173Rubber[t] -0.304606231203332Nietmetaalhoudende[t] + e[t]






Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STATH0: parameter = 02-tail p-value1-tail p-value
(Intercept)5473.287810579351056.5660955.18031e-061e-06
Jaar-2.738842972945890.527441-5.19271e-060
Voedingsmiddelen-0.01314040149083970.084974-0.15460.8773890.438694
Tabaksproducten0.05393974094703820.0325281.65830.100110.050055
Kleding-0.001838934616599130.034688-0.0530.9578170.478909
Leer-0.04256090802325130.023769-1.79060.0761020.038051
Hout0.3385448023105880.0875873.86520.0001889.4e-05
Papier0.5102985295488320.12134.20695.3e-052.7e-05
Uitgeverijen0.05553063934018680.0472811.17450.2427390.12137
Cokes-0.04155529362782470.050647-0.82050.4137160.206858
Chemische-0.2061531696539180.065835-3.13140.0022290.001115
Rubber0.7083598403631730.1072326.605900
Nietmetaalhoudende-0.3046062312033320.050957-5.977700

\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) & 5473.28781057935 & 1056.566095 & 5.1803 & 1e-06 & 1e-06 \tabularnewline
Jaar & -2.73884297294589 & 0.527441 & -5.1927 & 1e-06 & 0 \tabularnewline
Voedingsmiddelen & -0.0131404014908397 & 0.084974 & -0.1546 & 0.877389 & 0.438694 \tabularnewline
Tabaksproducten & 0.0539397409470382 & 0.032528 & 1.6583 & 0.10011 & 0.050055 \tabularnewline
Kleding & -0.00183893461659913 & 0.034688 & -0.053 & 0.957817 & 0.478909 \tabularnewline
Leer & -0.0425609080232513 & 0.023769 & -1.7906 & 0.076102 & 0.038051 \tabularnewline
Hout & 0.338544802310588 & 0.087587 & 3.8652 & 0.000188 & 9.4e-05 \tabularnewline
Papier & 0.510298529548832 & 0.1213 & 4.2069 & 5.3e-05 & 2.7e-05 \tabularnewline
Uitgeverijen & 0.0555306393401868 & 0.047281 & 1.1745 & 0.242739 & 0.12137 \tabularnewline
Cokes & -0.0415552936278247 & 0.050647 & -0.8205 & 0.413716 & 0.206858 \tabularnewline
Chemische & -0.206153169653918 & 0.065835 & -3.1314 & 0.002229 & 0.001115 \tabularnewline
Rubber & 0.708359840363173 & 0.107232 & 6.6059 & 0 & 0 \tabularnewline
Nietmetaalhoudende & -0.304606231203332 & 0.050957 & -5.9777 & 0 & 0 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&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]5473.28781057935[/C][C]1056.566095[/C][C]5.1803[/C][C]1e-06[/C][C]1e-06[/C][/ROW]
[ROW][C]Jaar[/C][C]-2.73884297294589[/C][C]0.527441[/C][C]-5.1927[/C][C]1e-06[/C][C]0[/C][/ROW]
[ROW][C]Voedingsmiddelen[/C][C]-0.0131404014908397[/C][C]0.084974[/C][C]-0.1546[/C][C]0.877389[/C][C]0.438694[/C][/ROW]
[ROW][C]Tabaksproducten[/C][C]0.0539397409470382[/C][C]0.032528[/C][C]1.6583[/C][C]0.10011[/C][C]0.050055[/C][/ROW]
[ROW][C]Kleding[/C][C]-0.00183893461659913[/C][C]0.034688[/C][C]-0.053[/C][C]0.957817[/C][C]0.478909[/C][/ROW]
[ROW][C]Leer[/C][C]-0.0425609080232513[/C][C]0.023769[/C][C]-1.7906[/C][C]0.076102[/C][C]0.038051[/C][/ROW]
[ROW][C]Hout[/C][C]0.338544802310588[/C][C]0.087587[/C][C]3.8652[/C][C]0.000188[/C][C]9.4e-05[/C][/ROW]
[ROW][C]Papier[/C][C]0.510298529548832[/C][C]0.1213[/C][C]4.2069[/C][C]5.3e-05[/C][C]2.7e-05[/C][/ROW]
[ROW][C]Uitgeverijen[/C][C]0.0555306393401868[/C][C]0.047281[/C][C]1.1745[/C][C]0.242739[/C][C]0.12137[/C][/ROW]
[ROW][C]Cokes[/C][C]-0.0415552936278247[/C][C]0.050647[/C][C]-0.8205[/C][C]0.413716[/C][C]0.206858[/C][/ROW]
[ROW][C]Chemische[/C][C]-0.206153169653918[/C][C]0.065835[/C][C]-3.1314[/C][C]0.002229[/C][C]0.001115[/C][/ROW]
[ROW][C]Rubber[/C][C]0.708359840363173[/C][C]0.107232[/C][C]6.6059[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]Nietmetaalhoudende[/C][C]-0.304606231203332[/C][C]0.050957[/C][C]-5.9777[/C][C]0[/C][C]0[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=189863&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=189863&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:

Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STATH0: parameter = 02-tail p-value1-tail p-value
(Intercept)5473.287810579351056.5660955.18031e-061e-06
Jaar-2.738842972945890.527441-5.19271e-060
Voedingsmiddelen-0.01314040149083970.084974-0.15460.8773890.438694
Tabaksproducten0.05393974094703820.0325281.65830.100110.050055
Kleding-0.001838934616599130.034688-0.0530.9578170.478909
Leer-0.04256090802325130.023769-1.79060.0761020.038051
Hout0.3385448023105880.0875873.86520.0001889.4e-05
Papier0.5102985295488320.12134.20695.3e-052.7e-05
Uitgeverijen0.05553063934018680.0472811.17450.2427390.12137
Cokes-0.04155529362782470.050647-0.82050.4137160.206858
Chemische-0.2061531696539180.065835-3.13140.0022290.001115
Rubber0.7083598403631730.1072326.605900
Nietmetaalhoudende-0.3046062312033320.050957-5.977700






Multiple Linear Regression - Regression Statistics
Multiple R0.952918821111305
R-squared0.908054279628159
Adjusted R-squared0.898023837405776
F-TEST (value)90.5298350258034
F-TEST (DF numerator)12
F-TEST (DF denominator)110
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.4619792639936
Sum Squared Residuals2190.01848475398

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Regression Statistics \tabularnewline
Multiple R & 0.952918821111305 \tabularnewline
R-squared & 0.908054279628159 \tabularnewline
Adjusted R-squared & 0.898023837405776 \tabularnewline
F-TEST (value) & 90.5298350258034 \tabularnewline
F-TEST (DF numerator) & 12 \tabularnewline
F-TEST (DF denominator) & 110 \tabularnewline
p-value & 0 \tabularnewline
Multiple Linear Regression - Residual Statistics \tabularnewline
Residual Standard Deviation & 4.4619792639936 \tabularnewline
Sum Squared Residuals & 2190.01848475398 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&T=3

[TABLE]
[ROW][C]Multiple Linear Regression - Regression Statistics[/C][/ROW]
[ROW][C]Multiple R[/C][C]0.952918821111305[/C][/ROW]
[ROW][C]R-squared[/C][C]0.908054279628159[/C][/ROW]
[ROW][C]Adjusted R-squared[/C][C]0.898023837405776[/C][/ROW]
[ROW][C]F-TEST (value)[/C][C]90.5298350258034[/C][/ROW]
[ROW][C]F-TEST (DF numerator)[/C][C]12[/C][/ROW]
[ROW][C]F-TEST (DF denominator)[/C][C]110[/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]4.4619792639936[/C][/ROW]
[ROW][C]Sum Squared Residuals[/C][C]2190.01848475398[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=189863&T=3

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=189863&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:

Multiple Linear Regression - Regression Statistics
Multiple R0.952918821111305
R-squared0.908054279628159
Adjusted R-squared0.898023837405776
F-TEST (value)90.5298350258034
F-TEST (DF numerator)12
F-TEST (DF denominator)110
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.4619792639936
Sum Squared Residuals2190.01848475398






Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolationForecastResidualsPrediction Error
1102104.230939449538-2.23093944953827
29995.7508960444233.249103955577
3108110.724084052561-2.72408405256141
49295.2683864567749-3.26838645677491
59997.65886320130761.34113679869237
6102100.7230771531441.27692284685592
78791.7649064298749-4.76490642987489
87179.5206428992244-8.52064289922439
9105100.4331764842914.56682351570891
10115108.6864186337576.31358136624325
1110397.05796336518495.94203663481512
127577.8412017539099-2.84120175390985
139795.1995738216351.80042617836496
149590.15185910905964.8481408909404
1599101.015112942942-2.0151129429421
1610096.38694841933613.61305158066389
179290.44442826209571.55557173790434
189498.0322824641633-4.03228246416328
198984.75098607148384.24901392851624
206770.3613204719351-3.36132047193506
2110996.805175417177312.1948245828227
22113108.8623644095284.13763559047188
2310695.546176260860910.4538237391391
247877.93277204785270.0672279521472916
2510297.91619937100724.08380062899276
269795.19166119270381.80833880729624
279695.82912239346620.170877606533833
289997.23419790687911.76580209312087
298690.7532965114915-4.75329651149152
309298.8034059889065-6.80340598890652
318689.5792708191181-3.57927081911812
326271.6075605146455-9.6075605146455
33105104.2186942260140.781305773985813
34108109.091744286954-1.09174428695353
359690.65880590487585.34119409512417
368082.5614930135401-2.56149301354008
379593.64267434226081.3573256577392
389492.28303421934411.71696578065588
39108113.763815062843-5.76381506284269
4097104.620109412719-7.62010941271922
418990.2345372142913-1.2345372142913
42107108.977583704425-1.9775837044254
438782.88325755944254.11674244055753
447074.4202126527207-4.42021265272074
45111107.5370539177333.46294608226719
4610596.76313339706218.23686660293788
479992.38468183802496.61531816197512
488485.8120473652657-1.81204736526565
498793.5757107011825-6.57571070118255
509290.34846153122641.65153846877359
5198102.421235271714-4.42123527171421
529598.7218129795958-3.72181297959576
538590.3492106315705-5.34921063157052
54100103.370688161432-3.37068816143202
557979.2739678381342-0.273967838134221
566675.9508622835136-9.95086228351357
57105106.574081755787-1.57408175578695
589697.8165918824558-1.81659188245582
5910399.00558692615593.9944130738441
608386.6502195015869-3.65021950158687
619195.3662107343558-4.36621073435579
629590.95267967284614.04732032715385
63109109.191069174763-0.191069174763264
649292.1025401340636-0.102540134063589
6599102.654107243521-3.65410724352118
66110106.9826752753743.01732472462551
678879.65517922075028.34482077924975
687377.1381719715163-4.13817197151633
69111103.8811184256027.11888157439842
70112109.6363751976762.36362480232393
71111106.7120673931484.28793260685213
728485.4983161995142-1.49831619951415
73102100.99164082751.00835917250005
7410298.38656424047523.61343575952483
75114115.640593331366-1.640593331366
769998.62203704557510.377962954424902
77100104.7180868377-4.71808683770044
78110119.048884513656-9.04888451365583
799394.1313259880933-1.13132598809328
807782.9167616511228-5.91676165112276
81108105.2502607669232.74973923307746
82120119.3221109146490.67788908535128
83106107.212073348803-1.21207334880251
847875.41543419051652.58456580948354
85100103.662718431604-3.66271843160376
8610297.85172692842474.1482730715753
879796.88001329125580.119986708744256
88101105.772441075832-4.77244107583221
898992.2160637332284-3.21606373322844
909397.7288258699791-4.72882586997915
918988.87676854331930.123231456680686
926262.8611719162079-0.861171916207893
939695.76423065625610.23576934374388
949597.2369493753398-2.23694937533979
958074.44084051082115.55915948917889
966763.78308987223153.21691012776848
977172.112178402561-1.11217840256104
987369.55261085495043.44738914504956
998178.27165725261572.72834274738428
1007779.3425672419581-2.34256724195806
1016869.0320038512491-1.03200385124911
1027782.0560139949153-5.0560139949153
1037370.52842617019132.47157382980871
1045456.9348450823696-2.9348450823696
1058586.7323637928626-1.73236379286256
1068681.72725744189334.27274255810665
1077978.85653167631070.1434683236893
1086767.6676307605071-0.667630760507109
1097274.3467029957418-2.34670299574174
1107672.02335945013243.97664054986764
1119090.2403205147576-0.240320514757595
1128483.10684568859310.893154311406931
1137571.71389140607293.28610859392705
1149091.4770483764704-1.47704837647042
1157770.08377209815196.91622790184808
1166061.7715258002569-1.77152580025693
1179287.43456932066324.56543067933676
1188880.19571155566997.80428844433009
1198380.61040211673662.38959788326345
1206974.4917740289109-5.49177402891088
1217375.0246720851265-2.02467208512645
1227876.99867389791881.00132610208121
1239289.18994173625432.81005826374571

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Actuals, Interpolation, and Residuals \tabularnewline
Time or Index & Actuals & InterpolationForecast & ResidualsPrediction Error \tabularnewline
1 & 102 & 104.230939449538 & -2.23093944953827 \tabularnewline
2 & 99 & 95.750896044423 & 3.249103955577 \tabularnewline
3 & 108 & 110.724084052561 & -2.72408405256141 \tabularnewline
4 & 92 & 95.2683864567749 & -3.26838645677491 \tabularnewline
5 & 99 & 97.6588632013076 & 1.34113679869237 \tabularnewline
6 & 102 & 100.723077153144 & 1.27692284685592 \tabularnewline
7 & 87 & 91.7649064298749 & -4.76490642987489 \tabularnewline
8 & 71 & 79.5206428992244 & -8.52064289922439 \tabularnewline
9 & 105 & 100.433176484291 & 4.56682351570891 \tabularnewline
10 & 115 & 108.686418633757 & 6.31358136624325 \tabularnewline
11 & 103 & 97.0579633651849 & 5.94203663481512 \tabularnewline
12 & 75 & 77.8412017539099 & -2.84120175390985 \tabularnewline
13 & 97 & 95.199573821635 & 1.80042617836496 \tabularnewline
14 & 95 & 90.1518591090596 & 4.8481408909404 \tabularnewline
15 & 99 & 101.015112942942 & -2.0151129429421 \tabularnewline
16 & 100 & 96.3869484193361 & 3.61305158066389 \tabularnewline
17 & 92 & 90.4444282620957 & 1.55557173790434 \tabularnewline
18 & 94 & 98.0322824641633 & -4.03228246416328 \tabularnewline
19 & 89 & 84.7509860714838 & 4.24901392851624 \tabularnewline
20 & 67 & 70.3613204719351 & -3.36132047193506 \tabularnewline
21 & 109 & 96.8051754171773 & 12.1948245828227 \tabularnewline
22 & 113 & 108.862364409528 & 4.13763559047188 \tabularnewline
23 & 106 & 95.5461762608609 & 10.4538237391391 \tabularnewline
24 & 78 & 77.9327720478527 & 0.0672279521472916 \tabularnewline
25 & 102 & 97.9161993710072 & 4.08380062899276 \tabularnewline
26 & 97 & 95.1916611927038 & 1.80833880729624 \tabularnewline
27 & 96 & 95.8291223934662 & 0.170877606533833 \tabularnewline
28 & 99 & 97.2341979068791 & 1.76580209312087 \tabularnewline
29 & 86 & 90.7532965114915 & -4.75329651149152 \tabularnewline
30 & 92 & 98.8034059889065 & -6.80340598890652 \tabularnewline
31 & 86 & 89.5792708191181 & -3.57927081911812 \tabularnewline
32 & 62 & 71.6075605146455 & -9.6075605146455 \tabularnewline
33 & 105 & 104.218694226014 & 0.781305773985813 \tabularnewline
34 & 108 & 109.091744286954 & -1.09174428695353 \tabularnewline
35 & 96 & 90.6588059048758 & 5.34119409512417 \tabularnewline
36 & 80 & 82.5614930135401 & -2.56149301354008 \tabularnewline
37 & 95 & 93.6426743422608 & 1.3573256577392 \tabularnewline
38 & 94 & 92.2830342193441 & 1.71696578065588 \tabularnewline
39 & 108 & 113.763815062843 & -5.76381506284269 \tabularnewline
40 & 97 & 104.620109412719 & -7.62010941271922 \tabularnewline
41 & 89 & 90.2345372142913 & -1.2345372142913 \tabularnewline
42 & 107 & 108.977583704425 & -1.9775837044254 \tabularnewline
43 & 87 & 82.8832575594425 & 4.11674244055753 \tabularnewline
44 & 70 & 74.4202126527207 & -4.42021265272074 \tabularnewline
45 & 111 & 107.537053917733 & 3.46294608226719 \tabularnewline
46 & 105 & 96.7631333970621 & 8.23686660293788 \tabularnewline
47 & 99 & 92.3846818380249 & 6.61531816197512 \tabularnewline
48 & 84 & 85.8120473652657 & -1.81204736526565 \tabularnewline
49 & 87 & 93.5757107011825 & -6.57571070118255 \tabularnewline
50 & 92 & 90.3484615312264 & 1.65153846877359 \tabularnewline
51 & 98 & 102.421235271714 & -4.42123527171421 \tabularnewline
52 & 95 & 98.7218129795958 & -3.72181297959576 \tabularnewline
53 & 85 & 90.3492106315705 & -5.34921063157052 \tabularnewline
54 & 100 & 103.370688161432 & -3.37068816143202 \tabularnewline
55 & 79 & 79.2739678381342 & -0.273967838134221 \tabularnewline
56 & 66 & 75.9508622835136 & -9.95086228351357 \tabularnewline
57 & 105 & 106.574081755787 & -1.57408175578695 \tabularnewline
58 & 96 & 97.8165918824558 & -1.81659188245582 \tabularnewline
59 & 103 & 99.0055869261559 & 3.9944130738441 \tabularnewline
60 & 83 & 86.6502195015869 & -3.65021950158687 \tabularnewline
61 & 91 & 95.3662107343558 & -4.36621073435579 \tabularnewline
62 & 95 & 90.9526796728461 & 4.04732032715385 \tabularnewline
63 & 109 & 109.191069174763 & -0.191069174763264 \tabularnewline
64 & 92 & 92.1025401340636 & -0.102540134063589 \tabularnewline
65 & 99 & 102.654107243521 & -3.65410724352118 \tabularnewline
66 & 110 & 106.982675275374 & 3.01732472462551 \tabularnewline
67 & 88 & 79.6551792207502 & 8.34482077924975 \tabularnewline
68 & 73 & 77.1381719715163 & -4.13817197151633 \tabularnewline
69 & 111 & 103.881118425602 & 7.11888157439842 \tabularnewline
70 & 112 & 109.636375197676 & 2.36362480232393 \tabularnewline
71 & 111 & 106.712067393148 & 4.28793260685213 \tabularnewline
72 & 84 & 85.4983161995142 & -1.49831619951415 \tabularnewline
73 & 102 & 100.9916408275 & 1.00835917250005 \tabularnewline
74 & 102 & 98.3865642404752 & 3.61343575952483 \tabularnewline
75 & 114 & 115.640593331366 & -1.640593331366 \tabularnewline
76 & 99 & 98.6220370455751 & 0.377962954424902 \tabularnewline
77 & 100 & 104.7180868377 & -4.71808683770044 \tabularnewline
78 & 110 & 119.048884513656 & -9.04888451365583 \tabularnewline
79 & 93 & 94.1313259880933 & -1.13132598809328 \tabularnewline
80 & 77 & 82.9167616511228 & -5.91676165112276 \tabularnewline
81 & 108 & 105.250260766923 & 2.74973923307746 \tabularnewline
82 & 120 & 119.322110914649 & 0.67788908535128 \tabularnewline
83 & 106 & 107.212073348803 & -1.21207334880251 \tabularnewline
84 & 78 & 75.4154341905165 & 2.58456580948354 \tabularnewline
85 & 100 & 103.662718431604 & -3.66271843160376 \tabularnewline
86 & 102 & 97.8517269284247 & 4.1482730715753 \tabularnewline
87 & 97 & 96.8800132912558 & 0.119986708744256 \tabularnewline
88 & 101 & 105.772441075832 & -4.77244107583221 \tabularnewline
89 & 89 & 92.2160637332284 & -3.21606373322844 \tabularnewline
90 & 93 & 97.7288258699791 & -4.72882586997915 \tabularnewline
91 & 89 & 88.8767685433193 & 0.123231456680686 \tabularnewline
92 & 62 & 62.8611719162079 & -0.861171916207893 \tabularnewline
93 & 96 & 95.7642306562561 & 0.23576934374388 \tabularnewline
94 & 95 & 97.2369493753398 & -2.23694937533979 \tabularnewline
95 & 80 & 74.4408405108211 & 5.55915948917889 \tabularnewline
96 & 67 & 63.7830898722315 & 3.21691012776848 \tabularnewline
97 & 71 & 72.112178402561 & -1.11217840256104 \tabularnewline
98 & 73 & 69.5526108549504 & 3.44738914504956 \tabularnewline
99 & 81 & 78.2716572526157 & 2.72834274738428 \tabularnewline
100 & 77 & 79.3425672419581 & -2.34256724195806 \tabularnewline
101 & 68 & 69.0320038512491 & -1.03200385124911 \tabularnewline
102 & 77 & 82.0560139949153 & -5.0560139949153 \tabularnewline
103 & 73 & 70.5284261701913 & 2.47157382980871 \tabularnewline
104 & 54 & 56.9348450823696 & -2.9348450823696 \tabularnewline
105 & 85 & 86.7323637928626 & -1.73236379286256 \tabularnewline
106 & 86 & 81.7272574418933 & 4.27274255810665 \tabularnewline
107 & 79 & 78.8565316763107 & 0.1434683236893 \tabularnewline
108 & 67 & 67.6676307605071 & -0.667630760507109 \tabularnewline
109 & 72 & 74.3467029957418 & -2.34670299574174 \tabularnewline
110 & 76 & 72.0233594501324 & 3.97664054986764 \tabularnewline
111 & 90 & 90.2403205147576 & -0.240320514757595 \tabularnewline
112 & 84 & 83.1068456885931 & 0.893154311406931 \tabularnewline
113 & 75 & 71.7138914060729 & 3.28610859392705 \tabularnewline
114 & 90 & 91.4770483764704 & -1.47704837647042 \tabularnewline
115 & 77 & 70.0837720981519 & 6.91622790184808 \tabularnewline
116 & 60 & 61.7715258002569 & -1.77152580025693 \tabularnewline
117 & 92 & 87.4345693206632 & 4.56543067933676 \tabularnewline
118 & 88 & 80.1957115556699 & 7.80428844433009 \tabularnewline
119 & 83 & 80.6104021167366 & 2.38959788326345 \tabularnewline
120 & 69 & 74.4917740289109 & -5.49177402891088 \tabularnewline
121 & 73 & 75.0246720851265 & -2.02467208512645 \tabularnewline
122 & 78 & 76.9986738979188 & 1.00132610208121 \tabularnewline
123 & 92 & 89.1899417362543 & 2.81005826374571 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&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]102[/C][C]104.230939449538[/C][C]-2.23093944953827[/C][/ROW]
[ROW][C]2[/C][C]99[/C][C]95.750896044423[/C][C]3.249103955577[/C][/ROW]
[ROW][C]3[/C][C]108[/C][C]110.724084052561[/C][C]-2.72408405256141[/C][/ROW]
[ROW][C]4[/C][C]92[/C][C]95.2683864567749[/C][C]-3.26838645677491[/C][/ROW]
[ROW][C]5[/C][C]99[/C][C]97.6588632013076[/C][C]1.34113679869237[/C][/ROW]
[ROW][C]6[/C][C]102[/C][C]100.723077153144[/C][C]1.27692284685592[/C][/ROW]
[ROW][C]7[/C][C]87[/C][C]91.7649064298749[/C][C]-4.76490642987489[/C][/ROW]
[ROW][C]8[/C][C]71[/C][C]79.5206428992244[/C][C]-8.52064289922439[/C][/ROW]
[ROW][C]9[/C][C]105[/C][C]100.433176484291[/C][C]4.56682351570891[/C][/ROW]
[ROW][C]10[/C][C]115[/C][C]108.686418633757[/C][C]6.31358136624325[/C][/ROW]
[ROW][C]11[/C][C]103[/C][C]97.0579633651849[/C][C]5.94203663481512[/C][/ROW]
[ROW][C]12[/C][C]75[/C][C]77.8412017539099[/C][C]-2.84120175390985[/C][/ROW]
[ROW][C]13[/C][C]97[/C][C]95.199573821635[/C][C]1.80042617836496[/C][/ROW]
[ROW][C]14[/C][C]95[/C][C]90.1518591090596[/C][C]4.8481408909404[/C][/ROW]
[ROW][C]15[/C][C]99[/C][C]101.015112942942[/C][C]-2.0151129429421[/C][/ROW]
[ROW][C]16[/C][C]100[/C][C]96.3869484193361[/C][C]3.61305158066389[/C][/ROW]
[ROW][C]17[/C][C]92[/C][C]90.4444282620957[/C][C]1.55557173790434[/C][/ROW]
[ROW][C]18[/C][C]94[/C][C]98.0322824641633[/C][C]-4.03228246416328[/C][/ROW]
[ROW][C]19[/C][C]89[/C][C]84.7509860714838[/C][C]4.24901392851624[/C][/ROW]
[ROW][C]20[/C][C]67[/C][C]70.3613204719351[/C][C]-3.36132047193506[/C][/ROW]
[ROW][C]21[/C][C]109[/C][C]96.8051754171773[/C][C]12.1948245828227[/C][/ROW]
[ROW][C]22[/C][C]113[/C][C]108.862364409528[/C][C]4.13763559047188[/C][/ROW]
[ROW][C]23[/C][C]106[/C][C]95.5461762608609[/C][C]10.4538237391391[/C][/ROW]
[ROW][C]24[/C][C]78[/C][C]77.9327720478527[/C][C]0.0672279521472916[/C][/ROW]
[ROW][C]25[/C][C]102[/C][C]97.9161993710072[/C][C]4.08380062899276[/C][/ROW]
[ROW][C]26[/C][C]97[/C][C]95.1916611927038[/C][C]1.80833880729624[/C][/ROW]
[ROW][C]27[/C][C]96[/C][C]95.8291223934662[/C][C]0.170877606533833[/C][/ROW]
[ROW][C]28[/C][C]99[/C][C]97.2341979068791[/C][C]1.76580209312087[/C][/ROW]
[ROW][C]29[/C][C]86[/C][C]90.7532965114915[/C][C]-4.75329651149152[/C][/ROW]
[ROW][C]30[/C][C]92[/C][C]98.8034059889065[/C][C]-6.80340598890652[/C][/ROW]
[ROW][C]31[/C][C]86[/C][C]89.5792708191181[/C][C]-3.57927081911812[/C][/ROW]
[ROW][C]32[/C][C]62[/C][C]71.6075605146455[/C][C]-9.6075605146455[/C][/ROW]
[ROW][C]33[/C][C]105[/C][C]104.218694226014[/C][C]0.781305773985813[/C][/ROW]
[ROW][C]34[/C][C]108[/C][C]109.091744286954[/C][C]-1.09174428695353[/C][/ROW]
[ROW][C]35[/C][C]96[/C][C]90.6588059048758[/C][C]5.34119409512417[/C][/ROW]
[ROW][C]36[/C][C]80[/C][C]82.5614930135401[/C][C]-2.56149301354008[/C][/ROW]
[ROW][C]37[/C][C]95[/C][C]93.6426743422608[/C][C]1.3573256577392[/C][/ROW]
[ROW][C]38[/C][C]94[/C][C]92.2830342193441[/C][C]1.71696578065588[/C][/ROW]
[ROW][C]39[/C][C]108[/C][C]113.763815062843[/C][C]-5.76381506284269[/C][/ROW]
[ROW][C]40[/C][C]97[/C][C]104.620109412719[/C][C]-7.62010941271922[/C][/ROW]
[ROW][C]41[/C][C]89[/C][C]90.2345372142913[/C][C]-1.2345372142913[/C][/ROW]
[ROW][C]42[/C][C]107[/C][C]108.977583704425[/C][C]-1.9775837044254[/C][/ROW]
[ROW][C]43[/C][C]87[/C][C]82.8832575594425[/C][C]4.11674244055753[/C][/ROW]
[ROW][C]44[/C][C]70[/C][C]74.4202126527207[/C][C]-4.42021265272074[/C][/ROW]
[ROW][C]45[/C][C]111[/C][C]107.537053917733[/C][C]3.46294608226719[/C][/ROW]
[ROW][C]46[/C][C]105[/C][C]96.7631333970621[/C][C]8.23686660293788[/C][/ROW]
[ROW][C]47[/C][C]99[/C][C]92.3846818380249[/C][C]6.61531816197512[/C][/ROW]
[ROW][C]48[/C][C]84[/C][C]85.8120473652657[/C][C]-1.81204736526565[/C][/ROW]
[ROW][C]49[/C][C]87[/C][C]93.5757107011825[/C][C]-6.57571070118255[/C][/ROW]
[ROW][C]50[/C][C]92[/C][C]90.3484615312264[/C][C]1.65153846877359[/C][/ROW]
[ROW][C]51[/C][C]98[/C][C]102.421235271714[/C][C]-4.42123527171421[/C][/ROW]
[ROW][C]52[/C][C]95[/C][C]98.7218129795958[/C][C]-3.72181297959576[/C][/ROW]
[ROW][C]53[/C][C]85[/C][C]90.3492106315705[/C][C]-5.34921063157052[/C][/ROW]
[ROW][C]54[/C][C]100[/C][C]103.370688161432[/C][C]-3.37068816143202[/C][/ROW]
[ROW][C]55[/C][C]79[/C][C]79.2739678381342[/C][C]-0.273967838134221[/C][/ROW]
[ROW][C]56[/C][C]66[/C][C]75.9508622835136[/C][C]-9.95086228351357[/C][/ROW]
[ROW][C]57[/C][C]105[/C][C]106.574081755787[/C][C]-1.57408175578695[/C][/ROW]
[ROW][C]58[/C][C]96[/C][C]97.8165918824558[/C][C]-1.81659188245582[/C][/ROW]
[ROW][C]59[/C][C]103[/C][C]99.0055869261559[/C][C]3.9944130738441[/C][/ROW]
[ROW][C]60[/C][C]83[/C][C]86.6502195015869[/C][C]-3.65021950158687[/C][/ROW]
[ROW][C]61[/C][C]91[/C][C]95.3662107343558[/C][C]-4.36621073435579[/C][/ROW]
[ROW][C]62[/C][C]95[/C][C]90.9526796728461[/C][C]4.04732032715385[/C][/ROW]
[ROW][C]63[/C][C]109[/C][C]109.191069174763[/C][C]-0.191069174763264[/C][/ROW]
[ROW][C]64[/C][C]92[/C][C]92.1025401340636[/C][C]-0.102540134063589[/C][/ROW]
[ROW][C]65[/C][C]99[/C][C]102.654107243521[/C][C]-3.65410724352118[/C][/ROW]
[ROW][C]66[/C][C]110[/C][C]106.982675275374[/C][C]3.01732472462551[/C][/ROW]
[ROW][C]67[/C][C]88[/C][C]79.6551792207502[/C][C]8.34482077924975[/C][/ROW]
[ROW][C]68[/C][C]73[/C][C]77.1381719715163[/C][C]-4.13817197151633[/C][/ROW]
[ROW][C]69[/C][C]111[/C][C]103.881118425602[/C][C]7.11888157439842[/C][/ROW]
[ROW][C]70[/C][C]112[/C][C]109.636375197676[/C][C]2.36362480232393[/C][/ROW]
[ROW][C]71[/C][C]111[/C][C]106.712067393148[/C][C]4.28793260685213[/C][/ROW]
[ROW][C]72[/C][C]84[/C][C]85.4983161995142[/C][C]-1.49831619951415[/C][/ROW]
[ROW][C]73[/C][C]102[/C][C]100.9916408275[/C][C]1.00835917250005[/C][/ROW]
[ROW][C]74[/C][C]102[/C][C]98.3865642404752[/C][C]3.61343575952483[/C][/ROW]
[ROW][C]75[/C][C]114[/C][C]115.640593331366[/C][C]-1.640593331366[/C][/ROW]
[ROW][C]76[/C][C]99[/C][C]98.6220370455751[/C][C]0.377962954424902[/C][/ROW]
[ROW][C]77[/C][C]100[/C][C]104.7180868377[/C][C]-4.71808683770044[/C][/ROW]
[ROW][C]78[/C][C]110[/C][C]119.048884513656[/C][C]-9.04888451365583[/C][/ROW]
[ROW][C]79[/C][C]93[/C][C]94.1313259880933[/C][C]-1.13132598809328[/C][/ROW]
[ROW][C]80[/C][C]77[/C][C]82.9167616511228[/C][C]-5.91676165112276[/C][/ROW]
[ROW][C]81[/C][C]108[/C][C]105.250260766923[/C][C]2.74973923307746[/C][/ROW]
[ROW][C]82[/C][C]120[/C][C]119.322110914649[/C][C]0.67788908535128[/C][/ROW]
[ROW][C]83[/C][C]106[/C][C]107.212073348803[/C][C]-1.21207334880251[/C][/ROW]
[ROW][C]84[/C][C]78[/C][C]75.4154341905165[/C][C]2.58456580948354[/C][/ROW]
[ROW][C]85[/C][C]100[/C][C]103.662718431604[/C][C]-3.66271843160376[/C][/ROW]
[ROW][C]86[/C][C]102[/C][C]97.8517269284247[/C][C]4.1482730715753[/C][/ROW]
[ROW][C]87[/C][C]97[/C][C]96.8800132912558[/C][C]0.119986708744256[/C][/ROW]
[ROW][C]88[/C][C]101[/C][C]105.772441075832[/C][C]-4.77244107583221[/C][/ROW]
[ROW][C]89[/C][C]89[/C][C]92.2160637332284[/C][C]-3.21606373322844[/C][/ROW]
[ROW][C]90[/C][C]93[/C][C]97.7288258699791[/C][C]-4.72882586997915[/C][/ROW]
[ROW][C]91[/C][C]89[/C][C]88.8767685433193[/C][C]0.123231456680686[/C][/ROW]
[ROW][C]92[/C][C]62[/C][C]62.8611719162079[/C][C]-0.861171916207893[/C][/ROW]
[ROW][C]93[/C][C]96[/C][C]95.7642306562561[/C][C]0.23576934374388[/C][/ROW]
[ROW][C]94[/C][C]95[/C][C]97.2369493753398[/C][C]-2.23694937533979[/C][/ROW]
[ROW][C]95[/C][C]80[/C][C]74.4408405108211[/C][C]5.55915948917889[/C][/ROW]
[ROW][C]96[/C][C]67[/C][C]63.7830898722315[/C][C]3.21691012776848[/C][/ROW]
[ROW][C]97[/C][C]71[/C][C]72.112178402561[/C][C]-1.11217840256104[/C][/ROW]
[ROW][C]98[/C][C]73[/C][C]69.5526108549504[/C][C]3.44738914504956[/C][/ROW]
[ROW][C]99[/C][C]81[/C][C]78.2716572526157[/C][C]2.72834274738428[/C][/ROW]
[ROW][C]100[/C][C]77[/C][C]79.3425672419581[/C][C]-2.34256724195806[/C][/ROW]
[ROW][C]101[/C][C]68[/C][C]69.0320038512491[/C][C]-1.03200385124911[/C][/ROW]
[ROW][C]102[/C][C]77[/C][C]82.0560139949153[/C][C]-5.0560139949153[/C][/ROW]
[ROW][C]103[/C][C]73[/C][C]70.5284261701913[/C][C]2.47157382980871[/C][/ROW]
[ROW][C]104[/C][C]54[/C][C]56.9348450823696[/C][C]-2.9348450823696[/C][/ROW]
[ROW][C]105[/C][C]85[/C][C]86.7323637928626[/C][C]-1.73236379286256[/C][/ROW]
[ROW][C]106[/C][C]86[/C][C]81.7272574418933[/C][C]4.27274255810665[/C][/ROW]
[ROW][C]107[/C][C]79[/C][C]78.8565316763107[/C][C]0.1434683236893[/C][/ROW]
[ROW][C]108[/C][C]67[/C][C]67.6676307605071[/C][C]-0.667630760507109[/C][/ROW]
[ROW][C]109[/C][C]72[/C][C]74.3467029957418[/C][C]-2.34670299574174[/C][/ROW]
[ROW][C]110[/C][C]76[/C][C]72.0233594501324[/C][C]3.97664054986764[/C][/ROW]
[ROW][C]111[/C][C]90[/C][C]90.2403205147576[/C][C]-0.240320514757595[/C][/ROW]
[ROW][C]112[/C][C]84[/C][C]83.1068456885931[/C][C]0.893154311406931[/C][/ROW]
[ROW][C]113[/C][C]75[/C][C]71.7138914060729[/C][C]3.28610859392705[/C][/ROW]
[ROW][C]114[/C][C]90[/C][C]91.4770483764704[/C][C]-1.47704837647042[/C][/ROW]
[ROW][C]115[/C][C]77[/C][C]70.0837720981519[/C][C]6.91622790184808[/C][/ROW]
[ROW][C]116[/C][C]60[/C][C]61.7715258002569[/C][C]-1.77152580025693[/C][/ROW]
[ROW][C]117[/C][C]92[/C][C]87.4345693206632[/C][C]4.56543067933676[/C][/ROW]
[ROW][C]118[/C][C]88[/C][C]80.1957115556699[/C][C]7.80428844433009[/C][/ROW]
[ROW][C]119[/C][C]83[/C][C]80.6104021167366[/C][C]2.38959788326345[/C][/ROW]
[ROW][C]120[/C][C]69[/C][C]74.4917740289109[/C][C]-5.49177402891088[/C][/ROW]
[ROW][C]121[/C][C]73[/C][C]75.0246720851265[/C][C]-2.02467208512645[/C][/ROW]
[ROW][C]122[/C][C]78[/C][C]76.9986738979188[/C][C]1.00132610208121[/C][/ROW]
[ROW][C]123[/C][C]92[/C][C]89.1899417362543[/C][C]2.81005826374571[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=189863&T=4

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

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


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

Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolationForecastResidualsPrediction Error
1102104.230939449538-2.23093944953827
29995.7508960444233.249103955577
3108110.724084052561-2.72408405256141
49295.2683864567749-3.26838645677491
59997.65886320130761.34113679869237
6102100.7230771531441.27692284685592
78791.7649064298749-4.76490642987489
87179.5206428992244-8.52064289922439
9105100.4331764842914.56682351570891
10115108.6864186337576.31358136624325
1110397.05796336518495.94203663481512
127577.8412017539099-2.84120175390985
139795.1995738216351.80042617836496
149590.15185910905964.8481408909404
1599101.015112942942-2.0151129429421
1610096.38694841933613.61305158066389
179290.44442826209571.55557173790434
189498.0322824641633-4.03228246416328
198984.75098607148384.24901392851624
206770.3613204719351-3.36132047193506
2110996.805175417177312.1948245828227
22113108.8623644095284.13763559047188
2310695.546176260860910.4538237391391
247877.93277204785270.0672279521472916
2510297.91619937100724.08380062899276
269795.19166119270381.80833880729624
279695.82912239346620.170877606533833
289997.23419790687911.76580209312087
298690.7532965114915-4.75329651149152
309298.8034059889065-6.80340598890652
318689.5792708191181-3.57927081911812
326271.6075605146455-9.6075605146455
33105104.2186942260140.781305773985813
34108109.091744286954-1.09174428695353
359690.65880590487585.34119409512417
368082.5614930135401-2.56149301354008
379593.64267434226081.3573256577392
389492.28303421934411.71696578065588
39108113.763815062843-5.76381506284269
4097104.620109412719-7.62010941271922
418990.2345372142913-1.2345372142913
42107108.977583704425-1.9775837044254
438782.88325755944254.11674244055753
447074.4202126527207-4.42021265272074
45111107.5370539177333.46294608226719
4610596.76313339706218.23686660293788
479992.38468183802496.61531816197512
488485.8120473652657-1.81204736526565
498793.5757107011825-6.57571070118255
509290.34846153122641.65153846877359
5198102.421235271714-4.42123527171421
529598.7218129795958-3.72181297959576
538590.3492106315705-5.34921063157052
54100103.370688161432-3.37068816143202
557979.2739678381342-0.273967838134221
566675.9508622835136-9.95086228351357
57105106.574081755787-1.57408175578695
589697.8165918824558-1.81659188245582
5910399.00558692615593.9944130738441
608386.6502195015869-3.65021950158687
619195.3662107343558-4.36621073435579
629590.95267967284614.04732032715385
63109109.191069174763-0.191069174763264
649292.1025401340636-0.102540134063589
6599102.654107243521-3.65410724352118
66110106.9826752753743.01732472462551
678879.65517922075028.34482077924975
687377.1381719715163-4.13817197151633
69111103.8811184256027.11888157439842
70112109.6363751976762.36362480232393
71111106.7120673931484.28793260685213
728485.4983161995142-1.49831619951415
73102100.99164082751.00835917250005
7410298.38656424047523.61343575952483
75114115.640593331366-1.640593331366
769998.62203704557510.377962954424902
77100104.7180868377-4.71808683770044
78110119.048884513656-9.04888451365583
799394.1313259880933-1.13132598809328
807782.9167616511228-5.91676165112276
81108105.2502607669232.74973923307746
82120119.3221109146490.67788908535128
83106107.212073348803-1.21207334880251
847875.41543419051652.58456580948354
85100103.662718431604-3.66271843160376
8610297.85172692842474.1482730715753
879796.88001329125580.119986708744256
88101105.772441075832-4.77244107583221
898992.2160637332284-3.21606373322844
909397.7288258699791-4.72882586997915
918988.87676854331930.123231456680686
926262.8611719162079-0.861171916207893
939695.76423065625610.23576934374388
949597.2369493753398-2.23694937533979
958074.44084051082115.55915948917889
966763.78308987223153.21691012776848
977172.112178402561-1.11217840256104
987369.55261085495043.44738914504956
998178.27165725261572.72834274738428
1007779.3425672419581-2.34256724195806
1016869.0320038512491-1.03200385124911
1027782.0560139949153-5.0560139949153
1037370.52842617019132.47157382980871
1045456.9348450823696-2.9348450823696
1058586.7323637928626-1.73236379286256
1068681.72725744189334.27274255810665
1077978.85653167631070.1434683236893
1086767.6676307605071-0.667630760507109
1097274.3467029957418-2.34670299574174
1107672.02335945013243.97664054986764
1119090.2403205147576-0.240320514757595
1128483.10684568859310.893154311406931
1137571.71389140607293.28610859392705
1149091.4770483764704-1.47704837647042
1157770.08377209815196.91622790184808
1166061.7715258002569-1.77152580025693
1179287.43456932066324.56543067933676
1188880.19571155566997.80428844433009
1198380.61040211673662.38959788326345
1206974.4917740289109-5.49177402891088
1217375.0246720851265-2.02467208512645
1227876.99867389791881.00132610208121
1239289.18994173625432.81005826374571






Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.1529244182374630.3058488364749260.847075581762537
170.1362257371606870.2724514743213740.863774262839313
180.7376899817114160.5246200365771690.262310018288585
190.7031349173221360.5937301653557290.296865082677864
200.7580481965324140.4839036069351730.241951803467586
210.7608683144892130.4782633710215730.239131685510787
220.733237554233030.5335248915339410.26676244576697
230.7221058231101890.5557883537796220.277894176889811
240.685473267799990.6290534644000190.31452673220001
250.7576447184367980.4847105631264040.242355281563202
260.7471349983423390.5057300033153210.252865001657661
270.7028337360983150.5943325278033690.297166263901684
280.6425669565358830.7148660869282330.357433043464117
290.757207036836370.485585926327260.24279296316363
300.8358946416458440.3282107167083120.164105358354156
310.7877010795505730.4245978408988550.212298920449427
320.7970368829115870.4059262341768250.202963117088412
330.7486309177910.5027381644180.251369082209
340.6930893018962180.6138213962075640.306910698103782
350.781757106198520.4364857876029610.21824289380148
360.7328020655632440.5343958688735120.267197934436756
370.7813119660854350.4373760678291290.218688033914565
380.7828509968860420.4342980062279150.217149003113958
390.795167544742580.409664910514840.20483245525742
400.8148172960873490.3703654078253020.185182703912651
410.7773416227407850.4453167545184290.222658377259215
420.7362498638325860.5275002723348280.263750136167414
430.8270141561965540.3459716876068910.172985843803446
440.8283643663560810.3432712672878370.171635633643919
450.8099432172870020.3801135654259970.190056782712998
460.9473546341941580.1052907316116840.0526453658058422
470.9691258642565240.06174827148695180.0308741357434759
480.9608791375309190.07824172493816260.0391208624690813
490.9581983537279380.08360329254412310.0418016462720616
500.9510924828236720.09781503435265650.0489075171763282
510.9418566290124030.1162867419751940.0581433709875971
520.9285345433562340.1429309132875310.0714654566437655
530.9221575526167210.1556848947665580.0778424473832788
540.9028341974603370.1943316050793260.0971658025396628
550.8949722218010110.2100555563979780.105027778198989
560.9543631888414540.09127362231709190.0456368111585459
570.9400534729431980.1198930541136040.0599465270568018
580.9239361680432770.1521276639134450.0760638319567227
590.9194610118465650.1610779763068710.0805389881534353
600.9090278615688360.1819442768623280.0909721384311639
610.9049267768823440.1901464462353110.0950732231176555
620.9102693609664810.1794612780670370.0897306390335187
630.8844272746295510.2311454507408980.115572725370449
640.8586372350988390.2827255298023210.141362764901161
650.8537491777633340.2925016444733320.146250822236666
660.8421236672923790.3157526654152410.157876332707621
670.9347098160643290.1305803678713410.0652901839356705
680.9434588231085230.1130823537829530.0565411768914767
690.9627298246407020.07454035071859510.0372701753592976
700.9643725347489780.07125493050204310.0356274652510215
710.9706715652449830.05865686951003430.0293284347550172
720.9608753289350720.07824934212985690.0391246710649285
730.9471446415286030.1057107169427930.0528553584713966
740.9509389442347530.09812211153049480.0490610557652474
750.9389297008469140.1221405983061720.061070299153086
760.924978357186810.150043285626380.07502164281319
770.9209099395886830.1581801208226340.0790900604113168
780.9453123213395160.1093753573209680.054687678660484
790.930447827706360.139104344587280.0695521722936401
800.9411637022609020.1176725954781970.0588362977390984
810.9424141727968060.1151716544063880.057585827203194
820.9476630538479440.1046738923041120.0523369461520559
830.930570873637110.1388582527257790.0694291263628897
840.9210632603035740.1578734793928530.0789367396964265
850.894076718603090.2118465627938190.10592328139691
860.9108813201191590.1782373597616830.0891186798808414
870.9343278521661720.1313442956676570.0656721478338283
880.9089800844436320.1820398311127360.0910199155563678
890.8815470685707480.2369058628585040.118452931429252
900.874230615516630.2515387689667410.125769384483371
910.8388844674177520.3222310651644970.161115532582248
920.8911450973112390.2177098053775220.108854902688761
930.8574427782894590.2851144434210820.142557221710541
940.9018228185199080.1963543629601830.0981771814800917
950.8779832586141740.2440334827716530.122016741385826
960.8432611141330120.3134777717339750.156738885866988
970.8749897520584840.2500204958830320.125010247941516
980.8686403788333380.2627192423333240.131359621166662
990.8203567099571750.359286580085650.179643290042825
1000.7475500648586650.5048998702826710.252449935141335
1010.6666478758738830.6667042482522340.333352124126117
1020.7548970415554060.4902059168891880.245102958444594
1030.6621650083159020.6756699833681950.337834991684098
1040.6574479683444760.6851040633110480.342552031655524
1050.5287079413679910.9425841172640180.471292058632009
1060.4950790999342560.9901581998685130.504920900065744
1070.3331357986233160.6662715972466320.666864201376684

\begin{tabular}{lllllllll}
\hline
Goldfeld-Quandt test for Heteroskedasticity \tabularnewline
p-values & Alternative Hypothesis \tabularnewline
breakpoint index & greater & 2-sided & less \tabularnewline
16 & 0.152924418237463 & 0.305848836474926 & 0.847075581762537 \tabularnewline
17 & 0.136225737160687 & 0.272451474321374 & 0.863774262839313 \tabularnewline
18 & 0.737689981711416 & 0.524620036577169 & 0.262310018288585 \tabularnewline
19 & 0.703134917322136 & 0.593730165355729 & 0.296865082677864 \tabularnewline
20 & 0.758048196532414 & 0.483903606935173 & 0.241951803467586 \tabularnewline
21 & 0.760868314489213 & 0.478263371021573 & 0.239131685510787 \tabularnewline
22 & 0.73323755423303 & 0.533524891533941 & 0.26676244576697 \tabularnewline
23 & 0.722105823110189 & 0.555788353779622 & 0.277894176889811 \tabularnewline
24 & 0.68547326779999 & 0.629053464400019 & 0.31452673220001 \tabularnewline
25 & 0.757644718436798 & 0.484710563126404 & 0.242355281563202 \tabularnewline
26 & 0.747134998342339 & 0.505730003315321 & 0.252865001657661 \tabularnewline
27 & 0.702833736098315 & 0.594332527803369 & 0.297166263901684 \tabularnewline
28 & 0.642566956535883 & 0.714866086928233 & 0.357433043464117 \tabularnewline
29 & 0.75720703683637 & 0.48558592632726 & 0.24279296316363 \tabularnewline
30 & 0.835894641645844 & 0.328210716708312 & 0.164105358354156 \tabularnewline
31 & 0.787701079550573 & 0.424597840898855 & 0.212298920449427 \tabularnewline
32 & 0.797036882911587 & 0.405926234176825 & 0.202963117088412 \tabularnewline
33 & 0.748630917791 & 0.502738164418 & 0.251369082209 \tabularnewline
34 & 0.693089301896218 & 0.613821396207564 & 0.306910698103782 \tabularnewline
35 & 0.78175710619852 & 0.436485787602961 & 0.21824289380148 \tabularnewline
36 & 0.732802065563244 & 0.534395868873512 & 0.267197934436756 \tabularnewline
37 & 0.781311966085435 & 0.437376067829129 & 0.218688033914565 \tabularnewline
38 & 0.782850996886042 & 0.434298006227915 & 0.217149003113958 \tabularnewline
39 & 0.79516754474258 & 0.40966491051484 & 0.20483245525742 \tabularnewline
40 & 0.814817296087349 & 0.370365407825302 & 0.185182703912651 \tabularnewline
41 & 0.777341622740785 & 0.445316754518429 & 0.222658377259215 \tabularnewline
42 & 0.736249863832586 & 0.527500272334828 & 0.263750136167414 \tabularnewline
43 & 0.827014156196554 & 0.345971687606891 & 0.172985843803446 \tabularnewline
44 & 0.828364366356081 & 0.343271267287837 & 0.171635633643919 \tabularnewline
45 & 0.809943217287002 & 0.380113565425997 & 0.190056782712998 \tabularnewline
46 & 0.947354634194158 & 0.105290731611684 & 0.0526453658058422 \tabularnewline
47 & 0.969125864256524 & 0.0617482714869518 & 0.0308741357434759 \tabularnewline
48 & 0.960879137530919 & 0.0782417249381626 & 0.0391208624690813 \tabularnewline
49 & 0.958198353727938 & 0.0836032925441231 & 0.0418016462720616 \tabularnewline
50 & 0.951092482823672 & 0.0978150343526565 & 0.0489075171763282 \tabularnewline
51 & 0.941856629012403 & 0.116286741975194 & 0.0581433709875971 \tabularnewline
52 & 0.928534543356234 & 0.142930913287531 & 0.0714654566437655 \tabularnewline
53 & 0.922157552616721 & 0.155684894766558 & 0.0778424473832788 \tabularnewline
54 & 0.902834197460337 & 0.194331605079326 & 0.0971658025396628 \tabularnewline
55 & 0.894972221801011 & 0.210055556397978 & 0.105027778198989 \tabularnewline
56 & 0.954363188841454 & 0.0912736223170919 & 0.0456368111585459 \tabularnewline
57 & 0.940053472943198 & 0.119893054113604 & 0.0599465270568018 \tabularnewline
58 & 0.923936168043277 & 0.152127663913445 & 0.0760638319567227 \tabularnewline
59 & 0.919461011846565 & 0.161077976306871 & 0.0805389881534353 \tabularnewline
60 & 0.909027861568836 & 0.181944276862328 & 0.0909721384311639 \tabularnewline
61 & 0.904926776882344 & 0.190146446235311 & 0.0950732231176555 \tabularnewline
62 & 0.910269360966481 & 0.179461278067037 & 0.0897306390335187 \tabularnewline
63 & 0.884427274629551 & 0.231145450740898 & 0.115572725370449 \tabularnewline
64 & 0.858637235098839 & 0.282725529802321 & 0.141362764901161 \tabularnewline
65 & 0.853749177763334 & 0.292501644473332 & 0.146250822236666 \tabularnewline
66 & 0.842123667292379 & 0.315752665415241 & 0.157876332707621 \tabularnewline
67 & 0.934709816064329 & 0.130580367871341 & 0.0652901839356705 \tabularnewline
68 & 0.943458823108523 & 0.113082353782953 & 0.0565411768914767 \tabularnewline
69 & 0.962729824640702 & 0.0745403507185951 & 0.0372701753592976 \tabularnewline
70 & 0.964372534748978 & 0.0712549305020431 & 0.0356274652510215 \tabularnewline
71 & 0.970671565244983 & 0.0586568695100343 & 0.0293284347550172 \tabularnewline
72 & 0.960875328935072 & 0.0782493421298569 & 0.0391246710649285 \tabularnewline
73 & 0.947144641528603 & 0.105710716942793 & 0.0528553584713966 \tabularnewline
74 & 0.950938944234753 & 0.0981221115304948 & 0.0490610557652474 \tabularnewline
75 & 0.938929700846914 & 0.122140598306172 & 0.061070299153086 \tabularnewline
76 & 0.92497835718681 & 0.15004328562638 & 0.07502164281319 \tabularnewline
77 & 0.920909939588683 & 0.158180120822634 & 0.0790900604113168 \tabularnewline
78 & 0.945312321339516 & 0.109375357320968 & 0.054687678660484 \tabularnewline
79 & 0.93044782770636 & 0.13910434458728 & 0.0695521722936401 \tabularnewline
80 & 0.941163702260902 & 0.117672595478197 & 0.0588362977390984 \tabularnewline
81 & 0.942414172796806 & 0.115171654406388 & 0.057585827203194 \tabularnewline
82 & 0.947663053847944 & 0.104673892304112 & 0.0523369461520559 \tabularnewline
83 & 0.93057087363711 & 0.138858252725779 & 0.0694291263628897 \tabularnewline
84 & 0.921063260303574 & 0.157873479392853 & 0.0789367396964265 \tabularnewline
85 & 0.89407671860309 & 0.211846562793819 & 0.10592328139691 \tabularnewline
86 & 0.910881320119159 & 0.178237359761683 & 0.0891186798808414 \tabularnewline
87 & 0.934327852166172 & 0.131344295667657 & 0.0656721478338283 \tabularnewline
88 & 0.908980084443632 & 0.182039831112736 & 0.0910199155563678 \tabularnewline
89 & 0.881547068570748 & 0.236905862858504 & 0.118452931429252 \tabularnewline
90 & 0.87423061551663 & 0.251538768966741 & 0.125769384483371 \tabularnewline
91 & 0.838884467417752 & 0.322231065164497 & 0.161115532582248 \tabularnewline
92 & 0.891145097311239 & 0.217709805377522 & 0.108854902688761 \tabularnewline
93 & 0.857442778289459 & 0.285114443421082 & 0.142557221710541 \tabularnewline
94 & 0.901822818519908 & 0.196354362960183 & 0.0981771814800917 \tabularnewline
95 & 0.877983258614174 & 0.244033482771653 & 0.122016741385826 \tabularnewline
96 & 0.843261114133012 & 0.313477771733975 & 0.156738885866988 \tabularnewline
97 & 0.874989752058484 & 0.250020495883032 & 0.125010247941516 \tabularnewline
98 & 0.868640378833338 & 0.262719242333324 & 0.131359621166662 \tabularnewline
99 & 0.820356709957175 & 0.35928658008565 & 0.179643290042825 \tabularnewline
100 & 0.747550064858665 & 0.504899870282671 & 0.252449935141335 \tabularnewline
101 & 0.666647875873883 & 0.666704248252234 & 0.333352124126117 \tabularnewline
102 & 0.754897041555406 & 0.490205916889188 & 0.245102958444594 \tabularnewline
103 & 0.662165008315902 & 0.675669983368195 & 0.337834991684098 \tabularnewline
104 & 0.657447968344476 & 0.685104063311048 & 0.342552031655524 \tabularnewline
105 & 0.528707941367991 & 0.942584117264018 & 0.471292058632009 \tabularnewline
106 & 0.495079099934256 & 0.990158199868513 & 0.504920900065744 \tabularnewline
107 & 0.333135798623316 & 0.666271597246632 & 0.666864201376684 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&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]16[/C][C]0.152924418237463[/C][C]0.305848836474926[/C][C]0.847075581762537[/C][/ROW]
[ROW][C]17[/C][C]0.136225737160687[/C][C]0.272451474321374[/C][C]0.863774262839313[/C][/ROW]
[ROW][C]18[/C][C]0.737689981711416[/C][C]0.524620036577169[/C][C]0.262310018288585[/C][/ROW]
[ROW][C]19[/C][C]0.703134917322136[/C][C]0.593730165355729[/C][C]0.296865082677864[/C][/ROW]
[ROW][C]20[/C][C]0.758048196532414[/C][C]0.483903606935173[/C][C]0.241951803467586[/C][/ROW]
[ROW][C]21[/C][C]0.760868314489213[/C][C]0.478263371021573[/C][C]0.239131685510787[/C][/ROW]
[ROW][C]22[/C][C]0.73323755423303[/C][C]0.533524891533941[/C][C]0.26676244576697[/C][/ROW]
[ROW][C]23[/C][C]0.722105823110189[/C][C]0.555788353779622[/C][C]0.277894176889811[/C][/ROW]
[ROW][C]24[/C][C]0.68547326779999[/C][C]0.629053464400019[/C][C]0.31452673220001[/C][/ROW]
[ROW][C]25[/C][C]0.757644718436798[/C][C]0.484710563126404[/C][C]0.242355281563202[/C][/ROW]
[ROW][C]26[/C][C]0.747134998342339[/C][C]0.505730003315321[/C][C]0.252865001657661[/C][/ROW]
[ROW][C]27[/C][C]0.702833736098315[/C][C]0.594332527803369[/C][C]0.297166263901684[/C][/ROW]
[ROW][C]28[/C][C]0.642566956535883[/C][C]0.714866086928233[/C][C]0.357433043464117[/C][/ROW]
[ROW][C]29[/C][C]0.75720703683637[/C][C]0.48558592632726[/C][C]0.24279296316363[/C][/ROW]
[ROW][C]30[/C][C]0.835894641645844[/C][C]0.328210716708312[/C][C]0.164105358354156[/C][/ROW]
[ROW][C]31[/C][C]0.787701079550573[/C][C]0.424597840898855[/C][C]0.212298920449427[/C][/ROW]
[ROW][C]32[/C][C]0.797036882911587[/C][C]0.405926234176825[/C][C]0.202963117088412[/C][/ROW]
[ROW][C]33[/C][C]0.748630917791[/C][C]0.502738164418[/C][C]0.251369082209[/C][/ROW]
[ROW][C]34[/C][C]0.693089301896218[/C][C]0.613821396207564[/C][C]0.306910698103782[/C][/ROW]
[ROW][C]35[/C][C]0.78175710619852[/C][C]0.436485787602961[/C][C]0.21824289380148[/C][/ROW]
[ROW][C]36[/C][C]0.732802065563244[/C][C]0.534395868873512[/C][C]0.267197934436756[/C][/ROW]
[ROW][C]37[/C][C]0.781311966085435[/C][C]0.437376067829129[/C][C]0.218688033914565[/C][/ROW]
[ROW][C]38[/C][C]0.782850996886042[/C][C]0.434298006227915[/C][C]0.217149003113958[/C][/ROW]
[ROW][C]39[/C][C]0.79516754474258[/C][C]0.40966491051484[/C][C]0.20483245525742[/C][/ROW]
[ROW][C]40[/C][C]0.814817296087349[/C][C]0.370365407825302[/C][C]0.185182703912651[/C][/ROW]
[ROW][C]41[/C][C]0.777341622740785[/C][C]0.445316754518429[/C][C]0.222658377259215[/C][/ROW]
[ROW][C]42[/C][C]0.736249863832586[/C][C]0.527500272334828[/C][C]0.263750136167414[/C][/ROW]
[ROW][C]43[/C][C]0.827014156196554[/C][C]0.345971687606891[/C][C]0.172985843803446[/C][/ROW]
[ROW][C]44[/C][C]0.828364366356081[/C][C]0.343271267287837[/C][C]0.171635633643919[/C][/ROW]
[ROW][C]45[/C][C]0.809943217287002[/C][C]0.380113565425997[/C][C]0.190056782712998[/C][/ROW]
[ROW][C]46[/C][C]0.947354634194158[/C][C]0.105290731611684[/C][C]0.0526453658058422[/C][/ROW]
[ROW][C]47[/C][C]0.969125864256524[/C][C]0.0617482714869518[/C][C]0.0308741357434759[/C][/ROW]
[ROW][C]48[/C][C]0.960879137530919[/C][C]0.0782417249381626[/C][C]0.0391208624690813[/C][/ROW]
[ROW][C]49[/C][C]0.958198353727938[/C][C]0.0836032925441231[/C][C]0.0418016462720616[/C][/ROW]
[ROW][C]50[/C][C]0.951092482823672[/C][C]0.0978150343526565[/C][C]0.0489075171763282[/C][/ROW]
[ROW][C]51[/C][C]0.941856629012403[/C][C]0.116286741975194[/C][C]0.0581433709875971[/C][/ROW]
[ROW][C]52[/C][C]0.928534543356234[/C][C]0.142930913287531[/C][C]0.0714654566437655[/C][/ROW]
[ROW][C]53[/C][C]0.922157552616721[/C][C]0.155684894766558[/C][C]0.0778424473832788[/C][/ROW]
[ROW][C]54[/C][C]0.902834197460337[/C][C]0.194331605079326[/C][C]0.0971658025396628[/C][/ROW]
[ROW][C]55[/C][C]0.894972221801011[/C][C]0.210055556397978[/C][C]0.105027778198989[/C][/ROW]
[ROW][C]56[/C][C]0.954363188841454[/C][C]0.0912736223170919[/C][C]0.0456368111585459[/C][/ROW]
[ROW][C]57[/C][C]0.940053472943198[/C][C]0.119893054113604[/C][C]0.0599465270568018[/C][/ROW]
[ROW][C]58[/C][C]0.923936168043277[/C][C]0.152127663913445[/C][C]0.0760638319567227[/C][/ROW]
[ROW][C]59[/C][C]0.919461011846565[/C][C]0.161077976306871[/C][C]0.0805389881534353[/C][/ROW]
[ROW][C]60[/C][C]0.909027861568836[/C][C]0.181944276862328[/C][C]0.0909721384311639[/C][/ROW]
[ROW][C]61[/C][C]0.904926776882344[/C][C]0.190146446235311[/C][C]0.0950732231176555[/C][/ROW]
[ROW][C]62[/C][C]0.910269360966481[/C][C]0.179461278067037[/C][C]0.0897306390335187[/C][/ROW]
[ROW][C]63[/C][C]0.884427274629551[/C][C]0.231145450740898[/C][C]0.115572725370449[/C][/ROW]
[ROW][C]64[/C][C]0.858637235098839[/C][C]0.282725529802321[/C][C]0.141362764901161[/C][/ROW]
[ROW][C]65[/C][C]0.853749177763334[/C][C]0.292501644473332[/C][C]0.146250822236666[/C][/ROW]
[ROW][C]66[/C][C]0.842123667292379[/C][C]0.315752665415241[/C][C]0.157876332707621[/C][/ROW]
[ROW][C]67[/C][C]0.934709816064329[/C][C]0.130580367871341[/C][C]0.0652901839356705[/C][/ROW]
[ROW][C]68[/C][C]0.943458823108523[/C][C]0.113082353782953[/C][C]0.0565411768914767[/C][/ROW]
[ROW][C]69[/C][C]0.962729824640702[/C][C]0.0745403507185951[/C][C]0.0372701753592976[/C][/ROW]
[ROW][C]70[/C][C]0.964372534748978[/C][C]0.0712549305020431[/C][C]0.0356274652510215[/C][/ROW]
[ROW][C]71[/C][C]0.970671565244983[/C][C]0.0586568695100343[/C][C]0.0293284347550172[/C][/ROW]
[ROW][C]72[/C][C]0.960875328935072[/C][C]0.0782493421298569[/C][C]0.0391246710649285[/C][/ROW]
[ROW][C]73[/C][C]0.947144641528603[/C][C]0.105710716942793[/C][C]0.0528553584713966[/C][/ROW]
[ROW][C]74[/C][C]0.950938944234753[/C][C]0.0981221115304948[/C][C]0.0490610557652474[/C][/ROW]
[ROW][C]75[/C][C]0.938929700846914[/C][C]0.122140598306172[/C][C]0.061070299153086[/C][/ROW]
[ROW][C]76[/C][C]0.92497835718681[/C][C]0.15004328562638[/C][C]0.07502164281319[/C][/ROW]
[ROW][C]77[/C][C]0.920909939588683[/C][C]0.158180120822634[/C][C]0.0790900604113168[/C][/ROW]
[ROW][C]78[/C][C]0.945312321339516[/C][C]0.109375357320968[/C][C]0.054687678660484[/C][/ROW]
[ROW][C]79[/C][C]0.93044782770636[/C][C]0.13910434458728[/C][C]0.0695521722936401[/C][/ROW]
[ROW][C]80[/C][C]0.941163702260902[/C][C]0.117672595478197[/C][C]0.0588362977390984[/C][/ROW]
[ROW][C]81[/C][C]0.942414172796806[/C][C]0.115171654406388[/C][C]0.057585827203194[/C][/ROW]
[ROW][C]82[/C][C]0.947663053847944[/C][C]0.104673892304112[/C][C]0.0523369461520559[/C][/ROW]
[ROW][C]83[/C][C]0.93057087363711[/C][C]0.138858252725779[/C][C]0.0694291263628897[/C][/ROW]
[ROW][C]84[/C][C]0.921063260303574[/C][C]0.157873479392853[/C][C]0.0789367396964265[/C][/ROW]
[ROW][C]85[/C][C]0.89407671860309[/C][C]0.211846562793819[/C][C]0.10592328139691[/C][/ROW]
[ROW][C]86[/C][C]0.910881320119159[/C][C]0.178237359761683[/C][C]0.0891186798808414[/C][/ROW]
[ROW][C]87[/C][C]0.934327852166172[/C][C]0.131344295667657[/C][C]0.0656721478338283[/C][/ROW]
[ROW][C]88[/C][C]0.908980084443632[/C][C]0.182039831112736[/C][C]0.0910199155563678[/C][/ROW]
[ROW][C]89[/C][C]0.881547068570748[/C][C]0.236905862858504[/C][C]0.118452931429252[/C][/ROW]
[ROW][C]90[/C][C]0.87423061551663[/C][C]0.251538768966741[/C][C]0.125769384483371[/C][/ROW]
[ROW][C]91[/C][C]0.838884467417752[/C][C]0.322231065164497[/C][C]0.161115532582248[/C][/ROW]
[ROW][C]92[/C][C]0.891145097311239[/C][C]0.217709805377522[/C][C]0.108854902688761[/C][/ROW]
[ROW][C]93[/C][C]0.857442778289459[/C][C]0.285114443421082[/C][C]0.142557221710541[/C][/ROW]
[ROW][C]94[/C][C]0.901822818519908[/C][C]0.196354362960183[/C][C]0.0981771814800917[/C][/ROW]
[ROW][C]95[/C][C]0.877983258614174[/C][C]0.244033482771653[/C][C]0.122016741385826[/C][/ROW]
[ROW][C]96[/C][C]0.843261114133012[/C][C]0.313477771733975[/C][C]0.156738885866988[/C][/ROW]
[ROW][C]97[/C][C]0.874989752058484[/C][C]0.250020495883032[/C][C]0.125010247941516[/C][/ROW]
[ROW][C]98[/C][C]0.868640378833338[/C][C]0.262719242333324[/C][C]0.131359621166662[/C][/ROW]
[ROW][C]99[/C][C]0.820356709957175[/C][C]0.35928658008565[/C][C]0.179643290042825[/C][/ROW]
[ROW][C]100[/C][C]0.747550064858665[/C][C]0.504899870282671[/C][C]0.252449935141335[/C][/ROW]
[ROW][C]101[/C][C]0.666647875873883[/C][C]0.666704248252234[/C][C]0.333352124126117[/C][/ROW]
[ROW][C]102[/C][C]0.754897041555406[/C][C]0.490205916889188[/C][C]0.245102958444594[/C][/ROW]
[ROW][C]103[/C][C]0.662165008315902[/C][C]0.675669983368195[/C][C]0.337834991684098[/C][/ROW]
[ROW][C]104[/C][C]0.657447968344476[/C][C]0.685104063311048[/C][C]0.342552031655524[/C][/ROW]
[ROW][C]105[/C][C]0.528707941367991[/C][C]0.942584117264018[/C][C]0.471292058632009[/C][/ROW]
[ROW][C]106[/C][C]0.495079099934256[/C][C]0.990158199868513[/C][C]0.504920900065744[/C][/ROW]
[ROW][C]107[/C][C]0.333135798623316[/C][C]0.666271597246632[/C][C]0.666864201376684[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=189863&T=5

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

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


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

Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.1529244182374630.3058488364749260.847075581762537
170.1362257371606870.2724514743213740.863774262839313
180.7376899817114160.5246200365771690.262310018288585
190.7031349173221360.5937301653557290.296865082677864
200.7580481965324140.4839036069351730.241951803467586
210.7608683144892130.4782633710215730.239131685510787
220.733237554233030.5335248915339410.26676244576697
230.7221058231101890.5557883537796220.277894176889811
240.685473267799990.6290534644000190.31452673220001
250.7576447184367980.4847105631264040.242355281563202
260.7471349983423390.5057300033153210.252865001657661
270.7028337360983150.5943325278033690.297166263901684
280.6425669565358830.7148660869282330.357433043464117
290.757207036836370.485585926327260.24279296316363
300.8358946416458440.3282107167083120.164105358354156
310.7877010795505730.4245978408988550.212298920449427
320.7970368829115870.4059262341768250.202963117088412
330.7486309177910.5027381644180.251369082209
340.6930893018962180.6138213962075640.306910698103782
350.781757106198520.4364857876029610.21824289380148
360.7328020655632440.5343958688735120.267197934436756
370.7813119660854350.4373760678291290.218688033914565
380.7828509968860420.4342980062279150.217149003113958
390.795167544742580.409664910514840.20483245525742
400.8148172960873490.3703654078253020.185182703912651
410.7773416227407850.4453167545184290.222658377259215
420.7362498638325860.5275002723348280.263750136167414
430.8270141561965540.3459716876068910.172985843803446
440.8283643663560810.3432712672878370.171635633643919
450.8099432172870020.3801135654259970.190056782712998
460.9473546341941580.1052907316116840.0526453658058422
470.9691258642565240.06174827148695180.0308741357434759
480.9608791375309190.07824172493816260.0391208624690813
490.9581983537279380.08360329254412310.0418016462720616
500.9510924828236720.09781503435265650.0489075171763282
510.9418566290124030.1162867419751940.0581433709875971
520.9285345433562340.1429309132875310.0714654566437655
530.9221575526167210.1556848947665580.0778424473832788
540.9028341974603370.1943316050793260.0971658025396628
550.8949722218010110.2100555563979780.105027778198989
560.9543631888414540.09127362231709190.0456368111585459
570.9400534729431980.1198930541136040.0599465270568018
580.9239361680432770.1521276639134450.0760638319567227
590.9194610118465650.1610779763068710.0805389881534353
600.9090278615688360.1819442768623280.0909721384311639
610.9049267768823440.1901464462353110.0950732231176555
620.9102693609664810.1794612780670370.0897306390335187
630.8844272746295510.2311454507408980.115572725370449
640.8586372350988390.2827255298023210.141362764901161
650.8537491777633340.2925016444733320.146250822236666
660.8421236672923790.3157526654152410.157876332707621
670.9347098160643290.1305803678713410.0652901839356705
680.9434588231085230.1130823537829530.0565411768914767
690.9627298246407020.07454035071859510.0372701753592976
700.9643725347489780.07125493050204310.0356274652510215
710.9706715652449830.05865686951003430.0293284347550172
720.9608753289350720.07824934212985690.0391246710649285
730.9471446415286030.1057107169427930.0528553584713966
740.9509389442347530.09812211153049480.0490610557652474
750.9389297008469140.1221405983061720.061070299153086
760.924978357186810.150043285626380.07502164281319
770.9209099395886830.1581801208226340.0790900604113168
780.9453123213395160.1093753573209680.054687678660484
790.930447827706360.139104344587280.0695521722936401
800.9411637022609020.1176725954781970.0588362977390984
810.9424141727968060.1151716544063880.057585827203194
820.9476630538479440.1046738923041120.0523369461520559
830.930570873637110.1388582527257790.0694291263628897
840.9210632603035740.1578734793928530.0789367396964265
850.894076718603090.2118465627938190.10592328139691
860.9108813201191590.1782373597616830.0891186798808414
870.9343278521661720.1313442956676570.0656721478338283
880.9089800844436320.1820398311127360.0910199155563678
890.8815470685707480.2369058628585040.118452931429252
900.874230615516630.2515387689667410.125769384483371
910.8388844674177520.3222310651644970.161115532582248
920.8911450973112390.2177098053775220.108854902688761
930.8574427782894590.2851144434210820.142557221710541
940.9018228185199080.1963543629601830.0981771814800917
950.8779832586141740.2440334827716530.122016741385826
960.8432611141330120.3134777717339750.156738885866988
970.8749897520584840.2500204958830320.125010247941516
980.8686403788333380.2627192423333240.131359621166662
990.8203567099571750.359286580085650.179643290042825
1000.7475500648586650.5048998702826710.252449935141335
1010.6666478758738830.6667042482522340.333352124126117
1020.7548970415554060.4902059168891880.245102958444594
1030.6621650083159020.6756699833681950.337834991684098
1040.6574479683444760.6851040633110480.342552031655524
1050.5287079413679910.9425841172640180.471292058632009
1060.4950790999342560.9901581998685130.504920900065744
1070.3331357986233160.6662715972466320.666864201376684






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 level100.108695652173913NOK

\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 & 10 & 0.108695652173913 & NOK \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=189863&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]10[/C][C]0.108695652173913[/C][C]NOK[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=189863&T=6

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

As an alternative you can also use a QR Code:  
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 level100.108695652173913NOK


Figures (Output of Computation)

Figure 1
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 2
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 3
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 4
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 5
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 6
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 7
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 8
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 9
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Figure 10
PNG link  
QR Code
Postscript link  
QR Code
PDF link  
QR Code


Input Parameters & R Code

Parameters (Session):
par1 = 6 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ;
Parameters (R input):
par1 = 4 ; par2 = Do not include Seasonal Dummies ; par3 = No 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')
}