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 computationThu, 15 Dec 2011 06:37:25 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/15/t132394910074gywe0rqum6r3e.htm/, Retrieved Wed, 08 May 2024 05:55:26 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=155354, Retrieved Wed, 08 May 2024 05:55:26 +0000
QR Codes:

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

Tree of Dependent Computations

Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [] [2011-12-15 11:33:26] [d49626b9c7bd91ce0b695b5077c2942f]
- R       [Multiple Regression] [] [2011-12-15 11:37:25] [8a7cc4cdacda1fa59fc196ea0735b051] [Current]
Feedback Forum

Post a new message

Dataset

Dataseries X:
Download CSV
Histogram
Boxplots 
1418	56	396	81	30	115	94	24188	146283	144	145	2
2172	89	967	125	30	116	103	32287	96933	135	132	4
1583	44	656	66	26	100	93	27101	95757	84	84	0
1764	84	655	74	38	140	123	19716	143983	130	127	0
1495	88	465	49	44	166	148	17753	75851	82	78	-4
1373	55	525	52	30	99	90	9028	59238	60	60	4
2187	60	885	88	40	139	124	18653	93163	131	131	4
4041	154	1436	108	47	181	168	29498	151511	140	133	0
1706	53	612	43	30	116	115	27563	136368	151	150	-1
2152	119	865	75	31	116	71	18293	112642	91	91	0
2242	75	963	86	30	108	108	16116	127766	119	118	1
2515	92	966	135	34	129	120	26569	85646	123	119	0
2147	100	801	63	31	118	114	24785	98579	90	89	3
1638	73	513	52	33	125	120	23825	131741	113	108	-1
2452	77	992	59	33	127	124	34461	171975	175	162	4
2662	99	937	64	36	136	126	24919	159676	96	92	3
865	30	260	32	14	46	37	12558	58391	41	41	1
1793	76	503	129	17	54	38	7784	31580	47	47	0
2527	146	927	37	32	124	120	28522	136815	126	120	-2
2747	67	1269	31	30	115	93	22265	120642	105	105	-3
1324	56	537	65	35	128	95	14459	69107	80	79	-4
1383	58	532	74	28	97	90	22240	108016	73	70	2
4308	119	1635	715	34	125	110	11912	79336	68	67	2
1831	66	557	66	39	149	138	18220	93176	127	127	-4
3373	89	1178	106	39	149	133	19199	161632	154	152	3
2352	41	866	112	29	108	96	25239	102996	112	109	2
2144	68	574	66	44	166	164	29801	160604	137	133	2
4691	168	1276	190	21	80	78	18450	158051	135	123	0
2694	132	825	165	28	107	102	34861	162647	230	230	5
1769	71	663	61	28	107	99	16688	60622	71	68	-2
3148	112	1069	53	38	146	129	24683	179566	147	147	0
1954	70	711	38	32	123	114	21436	96144	105	101	-2
1226	57	503	50	29	111	99	30546	129847	107	108	-3
1496	103	464	42	27	105	104	15977	71180	116	114	2
1943	52	657	53	40	155	138	14251	86767	89	88	2
1762	62	577	50	40	155	151	16851	93487	84	83	2
1403	45	619	77	28	104	72	21113	82981	113	113	0
1425	46	479	57	34	132	120	17401	73815	120	118	4
1857	63	817	73	33	127	115	23958	94552	110	110	4
1420	53	537	63	33	122	98	14587	67808	78	76	2
1644	78	465	47	35	87	71	20537	106175	145	141	2
1054	46	299	57	29	109	107	30495	76669	91	91	-4
937	41	248	36	20	78	73	7117	57283	48	48	3
2547	91	905	63	37	141	129	33473	72413	150	144	3
1626	63	512	63	33	124	118	21115	96971	181	168	2
1964	63	786	110	29	112	104	32902	120336	121	117	-1
1381	32	489	56	28	108	107	25131	93913	99	100	-3
1290	34	351	71	21	78	36	6943	32036	40	37	0
1982	93	669	56	41	158	139	31808	102255	87	87	1
1590	55	506	79	20	78	56	17014	63506	66	64	-3
1281	72	407	67	30	119	93	6440	68370	58	58	3
1272	42	316	76	22	88	87	18647	50517	77	76	0
1944	71	603	65	42	155	110	20556	103950	130	129	0
1605	65	577	45	32	123	83	22392	84396	101	101	0
1386	41	411	97	36	136	98	8388	55515	120	89	3
2395	86	975	53	31	117	82	22120	209056	195	193	-3
2699	95	964	144	33	124	115	20923	142775	106	101	0
1606	49	537	60	40	151	140	20237	68847	83	82	-4
1204	64	369	89	38	145	120	3769	20112	37	36	2
1138	38	417	42	24	87	66	12252	61023	77	75	-1
1111	52	389	52	43	165	139	21721	112494	144	131	3
2186	247	719	128	31	120	119	17939	78876	95	90	2
3604	139	1277	142	40	150	141	23436	170745	169	166	5
3261	110	1402	128	37	136	133	34538	122037	134	133	2
1641	67	564	50	31	116	98	25515	112283	197	196	-2
2312	83	747	50	39	150	117	29402	120691	140	136	0
2201	70	861	46	32	118	105	28732	122422	125	123	3
961	32	319	57	18	71	55	5250	25899	21	21	-2
1900	83	612	52	39	144	132	28608	139296	167	163	0
1645	70	564	48	30	110	73	14817	89455	96	96	6
2429	103	824	91	37	147	86	16714	147866	151	151	-3
872	34	239	70	32	111	48	1669	14336	23	23	3
1018	40	459	37	17	68	48	7768	30059	21	14	0
1403	46	454	72	12	48	43	7936	41907	90	87	-2
616	18	225	24	13	51	46	7294	35885	60	56	1
1232	60	389	90	17	68	65	13275	55764	26	25	0
1255	39	339	45	17	64	52	5401	35619	41	41	2
995	31	333	26	20	76	68	8702	40557	35	33	2
2048	54	636	132	17	66	47	8030	44197	68	68	-3
301	14	93	35	17	68	41	1278	4103	6	6	-2
628	23	170	48	17	66	47	1574	4694	0	0	1
1597	77	530	124	22	83	71	9653	62991	41	39	-4
717	19	201	35	15	55	30	7067	24261	38	37	0
652	49	227	49	12	41	24	1514	21425	47	47	1
733	20	261	45	17	66	63	5432	27184	34	34	0

Tables (Output of Computation)





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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155354&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 time6 seconds
R Server'George Udny Yule' @ yule.wessa.net






Multiple Linear Regression - Estimated Regression Equation
testscores[t] = -0.499196751044552 -0.000698879751712638pageviews[t] + 0.00396592077682703logins[t] + 0.00224768012879452comp_views[t] + 0.00133820189015943comp_views_pr[t] + 0.282710837368043comp_reviewed[t] -0.0893074649308441Feedback_p1[t] + 0.0262587394294302feedback_p120[t] -6.29345910915496e-05revisions[t] -7.27600641965383e-06seconds[t] + 0.0781974664703193hyperlinks[t] -0.0657258098288152blogs[t] -0.00102669152057652t + e[t]

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Estimated Regression Equation \tabularnewline
testscores[t] =  -0.499196751044552 -0.000698879751712638pageviews[t] +  0.00396592077682703logins[t] +  0.00224768012879452comp_views[t] +  0.00133820189015943comp_views_pr[t] +  0.282710837368043comp_reviewed[t] -0.0893074649308441Feedback_p1[t] +  0.0262587394294302feedback_p120[t] -6.29345910915496e-05revisions[t] -7.27600641965383e-06seconds[t] +  0.0781974664703193hyperlinks[t] -0.0657258098288152blogs[t] -0.00102669152057652t  + e[t] \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155354&T=1

[TABLE]
[ROW][C]Multiple Linear Regression - Estimated Regression Equation[/C][/ROW]
[ROW][C]testscores[t] =  -0.499196751044552 -0.000698879751712638pageviews[t] +  0.00396592077682703logins[t] +  0.00224768012879452comp_views[t] +  0.00133820189015943comp_views_pr[t] +  0.282710837368043comp_reviewed[t] -0.0893074649308441Feedback_p1[t] +  0.0262587394294302feedback_p120[t] -6.29345910915496e-05revisions[t] -7.27600641965383e-06seconds[t] +  0.0781974664703193hyperlinks[t] -0.0657258098288152blogs[t] -0.00102669152057652t  + e[t][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155354&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155354&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
testscores[t] = -0.499196751044552 -0.000698879751712638pageviews[t] + 0.00396592077682703logins[t] + 0.00224768012879452comp_views[t] + 0.00133820189015943comp_views_pr[t] + 0.282710837368043comp_reviewed[t] -0.0893074649308441Feedback_p1[t] + 0.0262587394294302feedback_p120[t] -6.29345910915496e-05revisions[t] -7.27600641965383e-06seconds[t] + 0.0781974664703193hyperlinks[t] -0.0657258098288152blogs[t] -0.00102669152057652t + e[t]






Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STATH0: parameter = 02-tail p-value1-tail p-value
(Intercept)-0.4991967510445521.472621-0.3390.7356080.367804
pageviews-0.0006988797517126380.001359-0.51440.6085690.304284
logins0.003965920776827030.0114980.34490.7311530.365577
comp_views0.002247680128794520.0031190.72060.4734680.236734
comp_views_pr0.001338201890159430.0048670.2750.7841340.392067
comp_reviewed0.2827108373680430.1759521.60680.1124860.056243
Feedback_p1-0.08930746493084410.052311-1.70720.0920880.046044
feedback_p1200.02625873942943020.0244981.07190.2873610.143681
revisions-6.29345910915496e-055.9e-05-1.06410.290820.14541
seconds-7.27600641965383e-061.4e-05-0.52030.6044340.302217
hyperlinks0.07819746647031930.0660391.18410.2402660.120133
blogs-0.06572580982881520.068554-0.95880.3408920.170446
t-0.001026691520576520.013727-0.07480.9405860.470293

\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) & -0.499196751044552 & 1.472621 & -0.339 & 0.735608 & 0.367804 \tabularnewline
pageviews & -0.000698879751712638 & 0.001359 & -0.5144 & 0.608569 & 0.304284 \tabularnewline
logins & 0.00396592077682703 & 0.011498 & 0.3449 & 0.731153 & 0.365577 \tabularnewline
comp_views & 0.00224768012879452 & 0.003119 & 0.7206 & 0.473468 & 0.236734 \tabularnewline
comp_views_pr & 0.00133820189015943 & 0.004867 & 0.275 & 0.784134 & 0.392067 \tabularnewline
comp_reviewed & 0.282710837368043 & 0.175952 & 1.6068 & 0.112486 & 0.056243 \tabularnewline
Feedback_p1 & -0.0893074649308441 & 0.052311 & -1.7072 & 0.092088 & 0.046044 \tabularnewline
feedback_p120 & 0.0262587394294302 & 0.024498 & 1.0719 & 0.287361 & 0.143681 \tabularnewline
revisions & -6.29345910915496e-05 & 5.9e-05 & -1.0641 & 0.29082 & 0.14541 \tabularnewline
seconds & -7.27600641965383e-06 & 1.4e-05 & -0.5203 & 0.604434 & 0.302217 \tabularnewline
hyperlinks & 0.0781974664703193 & 0.066039 & 1.1841 & 0.240266 & 0.120133 \tabularnewline
blogs & -0.0657258098288152 & 0.068554 & -0.9588 & 0.340892 & 0.170446 \tabularnewline
t & -0.00102669152057652 & 0.013727 & -0.0748 & 0.940586 & 0.470293 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155354&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]-0.499196751044552[/C][C]1.472621[/C][C]-0.339[/C][C]0.735608[/C][C]0.367804[/C][/ROW]
[ROW][C]pageviews[/C][C]-0.000698879751712638[/C][C]0.001359[/C][C]-0.5144[/C][C]0.608569[/C][C]0.304284[/C][/ROW]
[ROW][C]logins[/C][C]0.00396592077682703[/C][C]0.011498[/C][C]0.3449[/C][C]0.731153[/C][C]0.365577[/C][/ROW]
[ROW][C]comp_views[/C][C]0.00224768012879452[/C][C]0.003119[/C][C]0.7206[/C][C]0.473468[/C][C]0.236734[/C][/ROW]
[ROW][C]comp_views_pr[/C][C]0.00133820189015943[/C][C]0.004867[/C][C]0.275[/C][C]0.784134[/C][C]0.392067[/C][/ROW]
[ROW][C]comp_reviewed[/C][C]0.282710837368043[/C][C]0.175952[/C][C]1.6068[/C][C]0.112486[/C][C]0.056243[/C][/ROW]
[ROW][C]Feedback_p1[/C][C]-0.0893074649308441[/C][C]0.052311[/C][C]-1.7072[/C][C]0.092088[/C][C]0.046044[/C][/ROW]
[ROW][C]feedback_p120[/C][C]0.0262587394294302[/C][C]0.024498[/C][C]1.0719[/C][C]0.287361[/C][C]0.143681[/C][/ROW]
[ROW][C]revisions[/C][C]-6.29345910915496e-05[/C][C]5.9e-05[/C][C]-1.0641[/C][C]0.29082[/C][C]0.14541[/C][/ROW]
[ROW][C]seconds[/C][C]-7.27600641965383e-06[/C][C]1.4e-05[/C][C]-0.5203[/C][C]0.604434[/C][C]0.302217[/C][/ROW]
[ROW][C]hyperlinks[/C][C]0.0781974664703193[/C][C]0.066039[/C][C]1.1841[/C][C]0.240266[/C][C]0.120133[/C][/ROW]
[ROW][C]blogs[/C][C]-0.0657258098288152[/C][C]0.068554[/C][C]-0.9588[/C][C]0.340892[/C][C]0.170446[/C][/ROW]
[ROW][C]t[/C][C]-0.00102669152057652[/C][C]0.013727[/C][C]-0.0748[/C][C]0.940586[/C][C]0.470293[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155354&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155354&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)-0.4991967510445521.472621-0.3390.7356080.367804
pageviews-0.0006988797517126380.001359-0.51440.6085690.304284
logins0.003965920776827030.0114980.34490.7311530.365577
comp_views0.002247680128794520.0031190.72060.4734680.236734
comp_views_pr0.001338201890159430.0048670.2750.7841340.392067
comp_reviewed0.2827108373680430.1759521.60680.1124860.056243
Feedback_p1-0.08930746493084410.052311-1.70720.0920880.046044
feedback_p1200.02625873942943020.0244981.07190.2873610.143681
revisions-6.29345910915496e-055.9e-05-1.06410.290820.14541
seconds-7.27600641965383e-061.4e-05-0.52030.6044340.302217
hyperlinks0.07819746647031930.0660391.18410.2402660.120133
blogs-0.06572580982881520.068554-0.95880.3408920.170446
t-0.001026691520576520.013727-0.07480.9405860.470293






Multiple Linear Regression - Regression Statistics
Multiple R0.340994467989689
R-squared0.116277227199571
Adjusted R-squared-0.0310099016005005
F-TEST (value)0.789459528112646
F-TEST (DF numerator)12
F-TEST (DF denominator)72
p-value0.659527126988586
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.49991900544623
Sum Squared Residuals449.970842432971

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Regression Statistics \tabularnewline
Multiple R & 0.340994467989689 \tabularnewline
R-squared & 0.116277227199571 \tabularnewline
Adjusted R-squared & -0.0310099016005005 \tabularnewline
F-TEST (value) & 0.789459528112646 \tabularnewline
F-TEST (DF numerator) & 12 \tabularnewline
F-TEST (DF denominator) & 72 \tabularnewline
p-value & 0.659527126988586 \tabularnewline
Multiple Linear Regression - Residual Statistics \tabularnewline
Residual Standard Deviation & 2.49991900544623 \tabularnewline
Sum Squared Residuals & 449.970842432971 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155354&T=3

[TABLE]
[ROW][C]Multiple Linear Regression - Regression Statistics[/C][/ROW]
[ROW][C]Multiple R[/C][C]0.340994467989689[/C][/ROW]
[ROW][C]R-squared[/C][C]0.116277227199571[/C][/ROW]
[ROW][C]Adjusted R-squared[/C][C]-0.0310099016005005[/C][/ROW]
[ROW][C]F-TEST (value)[/C][C]0.789459528112646[/C][/ROW]
[ROW][C]F-TEST (DF numerator)[/C][C]12[/C][/ROW]
[ROW][C]F-TEST (DF denominator)[/C][C]72[/C][/ROW]
[ROW][C]p-value[/C][C]0.659527126988586[/C][/ROW]
[ROW][C]Multiple Linear Regression - Residual Statistics[/C][/ROW]
[ROW][C]Residual Standard Deviation[/C][C]2.49991900544623[/C][/ROW]
[ROW][C]Sum Squared Residuals[/C][C]449.970842432971[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155354&T=3

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155354&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.340994467989689
R-squared0.116277227199571
Adjusted R-squared-0.0310099016005005
F-TEST (value)0.789459528112646
F-TEST (DF numerator)12
F-TEST (DF denominator)72
p-value0.659527126988586
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.49991900544623
Sum Squared Residuals449.970842432971






Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolationForecastResidualsPrediction Error
12-0.4478047123859482.44780471238595
240.6444380686813083.35556193131869
30-0.3642051657380760.364205165738076
401.16811221242508-1.16811221242508
5-41.02752876997282-5.02752876997282
641.755107892726182.24489210727382
742.242873383158581.75712661684142
801.43286235874269-1.43286235874269
9-10.306070498571489-1.30607049857149
100-0.06408497598679560.0640849759867956
1111.77770223454573-0.77770223454573
1201.19178258186378-1.19178258186378
1330.3985830342299332.60141696577007
14-10.450857658898126-1.45085765889813
1541.24616679263622.7538332073638
1630.278793327311382.72120667268862
171-0.2574508431026181.25745084310262
1800.681674484088281-0.681674484088281
19-20.726330606500459-2.72633060650046
20-30.403476505827842-3.40347650582784
21-40.678773006723897-4.6787730067239
2220.5748653580075461.42513464199245
2322.49420036654378-0.494200366543775
24-40.900443148380033-4.90044314838003
2531.139490884862011.86050911513799
2620.4197607764201661.58023922357983
2720.470978368891111.52902163110889
2800.983955999108338-0.983955999108338
2950.7163818562906074.28361814370939
30-20.638053274347396-2.6380532743474
3100.25167521040634-0.25167521040634
32-20.608146618289501-2.6081466182895
33-3-0.679678757632503-2.3203212423675
3420.9695589109650171.03044108903498
3520.5978117293142391.40218827068576
3620.6455930940448491.35440690595515
3700.150454573745772-0.150454573745772
3840.7717129845097353.22828701549027
3940.5301379523851593.46986204761484
4020.6689769799202151.33102302007978
4123.72293528598277-1.72293528598277
42-4-0.416498843219281-3.58350115678072
433-0.09092710258735573.09092710258736
4431.041880269258091.95811973074191
4522.23443871306974-0.234438713069742
46-1-0.00247121485747059-0.99752878514253
47-3-0.227210085146397-2.7727899148536
480-0.4889888308007020.488988830800702
491-0.5174840875535211.51748408755352
50-3-0.620114742796504-2.3798852572035
513-0.04041502467245643.04041502467246
520-0.3329889439331330.332988943933133
5300.368357270551451-0.368357270551451
540-0.5836806235859960.583680623585996
5532.899300181529630.100699818470371
56-30.49147143746419-3.49147143746419
5700.862331975823798-0.862331975823798
58-40.626045307612822-4.62604530761282
5920.889209820818931.11079017918107
60-10.413146964330556-1.41314696433056
6131.347525449638391.65247455036161
6221.658832200805110.341167799194892
6351.731340862439053.26865913756095
6421.397085782637090.60291421736291
65-20.965145744954858-2.96514574495486
660-0.1254105401400370.125410540140037
6730.4252672604989482.57473273950105
68-2-0.385185655024749-1.61481434497525
6901.03974800563306-1.03974800563306
7060.07711139280108185.92288860719892
71-3-0.541503466942158-2.45849653305784
7230.0547084287426742.94529157125733
730-0.03777314888668920.0377731488866892
74-20.493688993570535-2.49368899357053
7510.2220433342624740.777956665737526
760-0.6167165272389730.616716527238973
772-0.1103674743458882.11036747434589
7820.009203725398440721.99079627460156
79-3-0.0242016468826178-2.97579835311738
80-2-0.705969654286968-1.29403034571303
811-0.4709600753047531.47096007530475
82-40.211535329338231-4.21153532933823
830-0.4766546750054730.476654675005473
8410.4251471492843140.574852850715686
8500.0779144282752674-0.0779144282752674

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Actuals, Interpolation, and Residuals \tabularnewline
Time or Index & Actuals & InterpolationForecast & ResidualsPrediction Error \tabularnewline
1 & 2 & -0.447804712385948 & 2.44780471238595 \tabularnewline
2 & 4 & 0.644438068681308 & 3.35556193131869 \tabularnewline
3 & 0 & -0.364205165738076 & 0.364205165738076 \tabularnewline
4 & 0 & 1.16811221242508 & -1.16811221242508 \tabularnewline
5 & -4 & 1.02752876997282 & -5.02752876997282 \tabularnewline
6 & 4 & 1.75510789272618 & 2.24489210727382 \tabularnewline
7 & 4 & 2.24287338315858 & 1.75712661684142 \tabularnewline
8 & 0 & 1.43286235874269 & -1.43286235874269 \tabularnewline
9 & -1 & 0.306070498571489 & -1.30607049857149 \tabularnewline
10 & 0 & -0.0640849759867956 & 0.0640849759867956 \tabularnewline
11 & 1 & 1.77770223454573 & -0.77770223454573 \tabularnewline
12 & 0 & 1.19178258186378 & -1.19178258186378 \tabularnewline
13 & 3 & 0.398583034229933 & 2.60141696577007 \tabularnewline
14 & -1 & 0.450857658898126 & -1.45085765889813 \tabularnewline
15 & 4 & 1.2461667926362 & 2.7538332073638 \tabularnewline
16 & 3 & 0.27879332731138 & 2.72120667268862 \tabularnewline
17 & 1 & -0.257450843102618 & 1.25745084310262 \tabularnewline
18 & 0 & 0.681674484088281 & -0.681674484088281 \tabularnewline
19 & -2 & 0.726330606500459 & -2.72633060650046 \tabularnewline
20 & -3 & 0.403476505827842 & -3.40347650582784 \tabularnewline
21 & -4 & 0.678773006723897 & -4.6787730067239 \tabularnewline
22 & 2 & 0.574865358007546 & 1.42513464199245 \tabularnewline
23 & 2 & 2.49420036654378 & -0.494200366543775 \tabularnewline
24 & -4 & 0.900443148380033 & -4.90044314838003 \tabularnewline
25 & 3 & 1.13949088486201 & 1.86050911513799 \tabularnewline
26 & 2 & 0.419760776420166 & 1.58023922357983 \tabularnewline
27 & 2 & 0.47097836889111 & 1.52902163110889 \tabularnewline
28 & 0 & 0.983955999108338 & -0.983955999108338 \tabularnewline
29 & 5 & 0.716381856290607 & 4.28361814370939 \tabularnewline
30 & -2 & 0.638053274347396 & -2.6380532743474 \tabularnewline
31 & 0 & 0.25167521040634 & -0.25167521040634 \tabularnewline
32 & -2 & 0.608146618289501 & -2.6081466182895 \tabularnewline
33 & -3 & -0.679678757632503 & -2.3203212423675 \tabularnewline
34 & 2 & 0.969558910965017 & 1.03044108903498 \tabularnewline
35 & 2 & 0.597811729314239 & 1.40218827068576 \tabularnewline
36 & 2 & 0.645593094044849 & 1.35440690595515 \tabularnewline
37 & 0 & 0.150454573745772 & -0.150454573745772 \tabularnewline
38 & 4 & 0.771712984509735 & 3.22828701549027 \tabularnewline
39 & 4 & 0.530137952385159 & 3.46986204761484 \tabularnewline
40 & 2 & 0.668976979920215 & 1.33102302007978 \tabularnewline
41 & 2 & 3.72293528598277 & -1.72293528598277 \tabularnewline
42 & -4 & -0.416498843219281 & -3.58350115678072 \tabularnewline
43 & 3 & -0.0909271025873557 & 3.09092710258736 \tabularnewline
44 & 3 & 1.04188026925809 & 1.95811973074191 \tabularnewline
45 & 2 & 2.23443871306974 & -0.234438713069742 \tabularnewline
46 & -1 & -0.00247121485747059 & -0.99752878514253 \tabularnewline
47 & -3 & -0.227210085146397 & -2.7727899148536 \tabularnewline
48 & 0 & -0.488988830800702 & 0.488988830800702 \tabularnewline
49 & 1 & -0.517484087553521 & 1.51748408755352 \tabularnewline
50 & -3 & -0.620114742796504 & -2.3798852572035 \tabularnewline
51 & 3 & -0.0404150246724564 & 3.04041502467246 \tabularnewline
52 & 0 & -0.332988943933133 & 0.332988943933133 \tabularnewline
53 & 0 & 0.368357270551451 & -0.368357270551451 \tabularnewline
54 & 0 & -0.583680623585996 & 0.583680623585996 \tabularnewline
55 & 3 & 2.89930018152963 & 0.100699818470371 \tabularnewline
56 & -3 & 0.49147143746419 & -3.49147143746419 \tabularnewline
57 & 0 & 0.862331975823798 & -0.862331975823798 \tabularnewline
58 & -4 & 0.626045307612822 & -4.62604530761282 \tabularnewline
59 & 2 & 0.88920982081893 & 1.11079017918107 \tabularnewline
60 & -1 & 0.413146964330556 & -1.41314696433056 \tabularnewline
61 & 3 & 1.34752544963839 & 1.65247455036161 \tabularnewline
62 & 2 & 1.65883220080511 & 0.341167799194892 \tabularnewline
63 & 5 & 1.73134086243905 & 3.26865913756095 \tabularnewline
64 & 2 & 1.39708578263709 & 0.60291421736291 \tabularnewline
65 & -2 & 0.965145744954858 & -2.96514574495486 \tabularnewline
66 & 0 & -0.125410540140037 & 0.125410540140037 \tabularnewline
67 & 3 & 0.425267260498948 & 2.57473273950105 \tabularnewline
68 & -2 & -0.385185655024749 & -1.61481434497525 \tabularnewline
69 & 0 & 1.03974800563306 & -1.03974800563306 \tabularnewline
70 & 6 & 0.0771113928010818 & 5.92288860719892 \tabularnewline
71 & -3 & -0.541503466942158 & -2.45849653305784 \tabularnewline
72 & 3 & 0.054708428742674 & 2.94529157125733 \tabularnewline
73 & 0 & -0.0377731488866892 & 0.0377731488866892 \tabularnewline
74 & -2 & 0.493688993570535 & -2.49368899357053 \tabularnewline
75 & 1 & 0.222043334262474 & 0.777956665737526 \tabularnewline
76 & 0 & -0.616716527238973 & 0.616716527238973 \tabularnewline
77 & 2 & -0.110367474345888 & 2.11036747434589 \tabularnewline
78 & 2 & 0.00920372539844072 & 1.99079627460156 \tabularnewline
79 & -3 & -0.0242016468826178 & -2.97579835311738 \tabularnewline
80 & -2 & -0.705969654286968 & -1.29403034571303 \tabularnewline
81 & 1 & -0.470960075304753 & 1.47096007530475 \tabularnewline
82 & -4 & 0.211535329338231 & -4.21153532933823 \tabularnewline
83 & 0 & -0.476654675005473 & 0.476654675005473 \tabularnewline
84 & 1 & 0.425147149284314 & 0.574852850715686 \tabularnewline
85 & 0 & 0.0779144282752674 & -0.0779144282752674 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155354&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]2[/C][C]-0.447804712385948[/C][C]2.44780471238595[/C][/ROW]
[ROW][C]2[/C][C]4[/C][C]0.644438068681308[/C][C]3.35556193131869[/C][/ROW]
[ROW][C]3[/C][C]0[/C][C]-0.364205165738076[/C][C]0.364205165738076[/C][/ROW]
[ROW][C]4[/C][C]0[/C][C]1.16811221242508[/C][C]-1.16811221242508[/C][/ROW]
[ROW][C]5[/C][C]-4[/C][C]1.02752876997282[/C][C]-5.02752876997282[/C][/ROW]
[ROW][C]6[/C][C]4[/C][C]1.75510789272618[/C][C]2.24489210727382[/C][/ROW]
[ROW][C]7[/C][C]4[/C][C]2.24287338315858[/C][C]1.75712661684142[/C][/ROW]
[ROW][C]8[/C][C]0[/C][C]1.43286235874269[/C][C]-1.43286235874269[/C][/ROW]
[ROW][C]9[/C][C]-1[/C][C]0.306070498571489[/C][C]-1.30607049857149[/C][/ROW]
[ROW][C]10[/C][C]0[/C][C]-0.0640849759867956[/C][C]0.0640849759867956[/C][/ROW]
[ROW][C]11[/C][C]1[/C][C]1.77770223454573[/C][C]-0.77770223454573[/C][/ROW]
[ROW][C]12[/C][C]0[/C][C]1.19178258186378[/C][C]-1.19178258186378[/C][/ROW]
[ROW][C]13[/C][C]3[/C][C]0.398583034229933[/C][C]2.60141696577007[/C][/ROW]
[ROW][C]14[/C][C]-1[/C][C]0.450857658898126[/C][C]-1.45085765889813[/C][/ROW]
[ROW][C]15[/C][C]4[/C][C]1.2461667926362[/C][C]2.7538332073638[/C][/ROW]
[ROW][C]16[/C][C]3[/C][C]0.27879332731138[/C][C]2.72120667268862[/C][/ROW]
[ROW][C]17[/C][C]1[/C][C]-0.257450843102618[/C][C]1.25745084310262[/C][/ROW]
[ROW][C]18[/C][C]0[/C][C]0.681674484088281[/C][C]-0.681674484088281[/C][/ROW]
[ROW][C]19[/C][C]-2[/C][C]0.726330606500459[/C][C]-2.72633060650046[/C][/ROW]
[ROW][C]20[/C][C]-3[/C][C]0.403476505827842[/C][C]-3.40347650582784[/C][/ROW]
[ROW][C]21[/C][C]-4[/C][C]0.678773006723897[/C][C]-4.6787730067239[/C][/ROW]
[ROW][C]22[/C][C]2[/C][C]0.574865358007546[/C][C]1.42513464199245[/C][/ROW]
[ROW][C]23[/C][C]2[/C][C]2.49420036654378[/C][C]-0.494200366543775[/C][/ROW]
[ROW][C]24[/C][C]-4[/C][C]0.900443148380033[/C][C]-4.90044314838003[/C][/ROW]
[ROW][C]25[/C][C]3[/C][C]1.13949088486201[/C][C]1.86050911513799[/C][/ROW]
[ROW][C]26[/C][C]2[/C][C]0.419760776420166[/C][C]1.58023922357983[/C][/ROW]
[ROW][C]27[/C][C]2[/C][C]0.47097836889111[/C][C]1.52902163110889[/C][/ROW]
[ROW][C]28[/C][C]0[/C][C]0.983955999108338[/C][C]-0.983955999108338[/C][/ROW]
[ROW][C]29[/C][C]5[/C][C]0.716381856290607[/C][C]4.28361814370939[/C][/ROW]
[ROW][C]30[/C][C]-2[/C][C]0.638053274347396[/C][C]-2.6380532743474[/C][/ROW]
[ROW][C]31[/C][C]0[/C][C]0.25167521040634[/C][C]-0.25167521040634[/C][/ROW]
[ROW][C]32[/C][C]-2[/C][C]0.608146618289501[/C][C]-2.6081466182895[/C][/ROW]
[ROW][C]33[/C][C]-3[/C][C]-0.679678757632503[/C][C]-2.3203212423675[/C][/ROW]
[ROW][C]34[/C][C]2[/C][C]0.969558910965017[/C][C]1.03044108903498[/C][/ROW]
[ROW][C]35[/C][C]2[/C][C]0.597811729314239[/C][C]1.40218827068576[/C][/ROW]
[ROW][C]36[/C][C]2[/C][C]0.645593094044849[/C][C]1.35440690595515[/C][/ROW]
[ROW][C]37[/C][C]0[/C][C]0.150454573745772[/C][C]-0.150454573745772[/C][/ROW]
[ROW][C]38[/C][C]4[/C][C]0.771712984509735[/C][C]3.22828701549027[/C][/ROW]
[ROW][C]39[/C][C]4[/C][C]0.530137952385159[/C][C]3.46986204761484[/C][/ROW]
[ROW][C]40[/C][C]2[/C][C]0.668976979920215[/C][C]1.33102302007978[/C][/ROW]
[ROW][C]41[/C][C]2[/C][C]3.72293528598277[/C][C]-1.72293528598277[/C][/ROW]
[ROW][C]42[/C][C]-4[/C][C]-0.416498843219281[/C][C]-3.58350115678072[/C][/ROW]
[ROW][C]43[/C][C]3[/C][C]-0.0909271025873557[/C][C]3.09092710258736[/C][/ROW]
[ROW][C]44[/C][C]3[/C][C]1.04188026925809[/C][C]1.95811973074191[/C][/ROW]
[ROW][C]45[/C][C]2[/C][C]2.23443871306974[/C][C]-0.234438713069742[/C][/ROW]
[ROW][C]46[/C][C]-1[/C][C]-0.00247121485747059[/C][C]-0.99752878514253[/C][/ROW]
[ROW][C]47[/C][C]-3[/C][C]-0.227210085146397[/C][C]-2.7727899148536[/C][/ROW]
[ROW][C]48[/C][C]0[/C][C]-0.488988830800702[/C][C]0.488988830800702[/C][/ROW]
[ROW][C]49[/C][C]1[/C][C]-0.517484087553521[/C][C]1.51748408755352[/C][/ROW]
[ROW][C]50[/C][C]-3[/C][C]-0.620114742796504[/C][C]-2.3798852572035[/C][/ROW]
[ROW][C]51[/C][C]3[/C][C]-0.0404150246724564[/C][C]3.04041502467246[/C][/ROW]
[ROW][C]52[/C][C]0[/C][C]-0.332988943933133[/C][C]0.332988943933133[/C][/ROW]
[ROW][C]53[/C][C]0[/C][C]0.368357270551451[/C][C]-0.368357270551451[/C][/ROW]
[ROW][C]54[/C][C]0[/C][C]-0.583680623585996[/C][C]0.583680623585996[/C][/ROW]
[ROW][C]55[/C][C]3[/C][C]2.89930018152963[/C][C]0.100699818470371[/C][/ROW]
[ROW][C]56[/C][C]-3[/C][C]0.49147143746419[/C][C]-3.49147143746419[/C][/ROW]
[ROW][C]57[/C][C]0[/C][C]0.862331975823798[/C][C]-0.862331975823798[/C][/ROW]
[ROW][C]58[/C][C]-4[/C][C]0.626045307612822[/C][C]-4.62604530761282[/C][/ROW]
[ROW][C]59[/C][C]2[/C][C]0.88920982081893[/C][C]1.11079017918107[/C][/ROW]
[ROW][C]60[/C][C]-1[/C][C]0.413146964330556[/C][C]-1.41314696433056[/C][/ROW]
[ROW][C]61[/C][C]3[/C][C]1.34752544963839[/C][C]1.65247455036161[/C][/ROW]
[ROW][C]62[/C][C]2[/C][C]1.65883220080511[/C][C]0.341167799194892[/C][/ROW]
[ROW][C]63[/C][C]5[/C][C]1.73134086243905[/C][C]3.26865913756095[/C][/ROW]
[ROW][C]64[/C][C]2[/C][C]1.39708578263709[/C][C]0.60291421736291[/C][/ROW]
[ROW][C]65[/C][C]-2[/C][C]0.965145744954858[/C][C]-2.96514574495486[/C][/ROW]
[ROW][C]66[/C][C]0[/C][C]-0.125410540140037[/C][C]0.125410540140037[/C][/ROW]
[ROW][C]67[/C][C]3[/C][C]0.425267260498948[/C][C]2.57473273950105[/C][/ROW]
[ROW][C]68[/C][C]-2[/C][C]-0.385185655024749[/C][C]-1.61481434497525[/C][/ROW]
[ROW][C]69[/C][C]0[/C][C]1.03974800563306[/C][C]-1.03974800563306[/C][/ROW]
[ROW][C]70[/C][C]6[/C][C]0.0771113928010818[/C][C]5.92288860719892[/C][/ROW]
[ROW][C]71[/C][C]-3[/C][C]-0.541503466942158[/C][C]-2.45849653305784[/C][/ROW]
[ROW][C]72[/C][C]3[/C][C]0.054708428742674[/C][C]2.94529157125733[/C][/ROW]
[ROW][C]73[/C][C]0[/C][C]-0.0377731488866892[/C][C]0.0377731488866892[/C][/ROW]
[ROW][C]74[/C][C]-2[/C][C]0.493688993570535[/C][C]-2.49368899357053[/C][/ROW]
[ROW][C]75[/C][C]1[/C][C]0.222043334262474[/C][C]0.777956665737526[/C][/ROW]
[ROW][C]76[/C][C]0[/C][C]-0.616716527238973[/C][C]0.616716527238973[/C][/ROW]
[ROW][C]77[/C][C]2[/C][C]-0.110367474345888[/C][C]2.11036747434589[/C][/ROW]
[ROW][C]78[/C][C]2[/C][C]0.00920372539844072[/C][C]1.99079627460156[/C][/ROW]
[ROW][C]79[/C][C]-3[/C][C]-0.0242016468826178[/C][C]-2.97579835311738[/C][/ROW]
[ROW][C]80[/C][C]-2[/C][C]-0.705969654286968[/C][C]-1.29403034571303[/C][/ROW]
[ROW][C]81[/C][C]1[/C][C]-0.470960075304753[/C][C]1.47096007530475[/C][/ROW]
[ROW][C]82[/C][C]-4[/C][C]0.211535329338231[/C][C]-4.21153532933823[/C][/ROW]
[ROW][C]83[/C][C]0[/C][C]-0.476654675005473[/C][C]0.476654675005473[/C][/ROW]
[ROW][C]84[/C][C]1[/C][C]0.425147149284314[/C][C]0.574852850715686[/C][/ROW]
[ROW][C]85[/C][C]0[/C][C]0.0779144282752674[/C][C]-0.0779144282752674[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155354&T=4

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155354&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
12-0.4478047123859482.44780471238595
240.6444380686813083.35556193131869
30-0.3642051657380760.364205165738076
401.16811221242508-1.16811221242508
5-41.02752876997282-5.02752876997282
641.755107892726182.24489210727382
742.242873383158581.75712661684142
801.43286235874269-1.43286235874269
9-10.306070498571489-1.30607049857149
100-0.06408497598679560.0640849759867956
1111.77770223454573-0.77770223454573
1201.19178258186378-1.19178258186378
1330.3985830342299332.60141696577007
14-10.450857658898126-1.45085765889813
1541.24616679263622.7538332073638
1630.278793327311382.72120667268862
171-0.2574508431026181.25745084310262
1800.681674484088281-0.681674484088281
19-20.726330606500459-2.72633060650046
20-30.403476505827842-3.40347650582784
21-40.678773006723897-4.6787730067239
2220.5748653580075461.42513464199245
2322.49420036654378-0.494200366543775
24-40.900443148380033-4.90044314838003
2531.139490884862011.86050911513799
2620.4197607764201661.58023922357983
2720.470978368891111.52902163110889
2800.983955999108338-0.983955999108338
2950.7163818562906074.28361814370939
30-20.638053274347396-2.6380532743474
3100.25167521040634-0.25167521040634
32-20.608146618289501-2.6081466182895
33-3-0.679678757632503-2.3203212423675
3420.9695589109650171.03044108903498
3520.5978117293142391.40218827068576
3620.6455930940448491.35440690595515
3700.150454573745772-0.150454573745772
3840.7717129845097353.22828701549027
3940.5301379523851593.46986204761484
4020.6689769799202151.33102302007978
4123.72293528598277-1.72293528598277
42-4-0.416498843219281-3.58350115678072
433-0.09092710258735573.09092710258736
4431.041880269258091.95811973074191
4522.23443871306974-0.234438713069742
46-1-0.00247121485747059-0.99752878514253
47-3-0.227210085146397-2.7727899148536
480-0.4889888308007020.488988830800702
491-0.5174840875535211.51748408755352
50-3-0.620114742796504-2.3798852572035
513-0.04041502467245643.04041502467246
520-0.3329889439331330.332988943933133
5300.368357270551451-0.368357270551451
540-0.5836806235859960.583680623585996
5532.899300181529630.100699818470371
56-30.49147143746419-3.49147143746419
5700.862331975823798-0.862331975823798
58-40.626045307612822-4.62604530761282
5920.889209820818931.11079017918107
60-10.413146964330556-1.41314696433056
6131.347525449638391.65247455036161
6221.658832200805110.341167799194892
6351.731340862439053.26865913756095
6421.397085782637090.60291421736291
65-20.965145744954858-2.96514574495486
660-0.1254105401400370.125410540140037
6730.4252672604989482.57473273950105
68-2-0.385185655024749-1.61481434497525
6901.03974800563306-1.03974800563306
7060.07711139280108185.92288860719892
71-3-0.541503466942158-2.45849653305784
7230.0547084287426742.94529157125733
730-0.03777314888668920.0377731488866892
74-20.493688993570535-2.49368899357053
7510.2220433342624740.777956665737526
760-0.6167165272389730.616716527238973
772-0.1103674743458882.11036747434589
7820.009203725398440721.99079627460156
79-3-0.0242016468826178-2.97579835311738
80-2-0.705969654286968-1.29403034571303
811-0.4709600753047531.47096007530475
82-40.211535329338231-4.21153532933823
830-0.4766546750054730.476654675005473
8410.4251471492843140.574852850715686
8500.0779144282752674-0.0779144282752674






Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.4104709961994940.8209419923989880.589529003800506
170.2591181832439310.5182363664878620.74088181675607
180.171256492334130.342512984668260.82874350766587
190.2842778818918120.5685557637836240.715722118108188
200.1958270882827220.3916541765654440.804172911717278
210.1498204935391770.2996409870783540.850179506460823
220.1848936851688660.3697873703377320.815106314831134
230.1212848090253990.2425696180507980.878715190974601
240.1778363942170470.3556727884340930.822163605782953
250.3346573601904120.6693147203808230.665342639809588
260.2634990537731610.5269981075463220.736500946226839
270.2030079166108880.4060158332217770.796992083389112
280.2046241687325150.409248337465030.795375831267485
290.2711821311697470.5423642623394940.728817868830253
300.3361103992426490.6722207984852990.663889600757351
310.2730261611618290.5460523223236580.726973838838171
320.3020824894994510.6041649789989030.697917510500549
330.3653476097614650.730695219522930.634652390238535
340.597790355755910.804419288488180.40220964424409
350.7766486978672040.4467026042655910.223351302132795
360.8006697670611760.3986604658776480.199330232938824
370.7484114264062260.5031771471875490.251588573593774
380.8082211871264560.3835576257470870.191778812873544
390.8429082199731320.3141835600537360.157091780026868
400.811057343009920.3778853139801610.18894265699008
410.8511163007189520.2977673985620960.148883699281048
420.8737593357369370.2524813285261250.126240664263063
430.8657798799358290.2684402401283430.134220120064171
440.8454503690195820.3090992619608360.154549630980418
450.8067161469894170.3865677060211660.193283853010583
460.8014292334748930.3971415330502150.198570766525107
470.7918368213424630.4163263573150740.208163178657537
480.7385515111113570.5228969777772860.261448488888643
490.7075676121096740.5848647757806520.292432387890326
500.6770789287447560.6458421425104880.322921071255244
510.7280016455567740.5439967088864520.271998354443226
520.7710993581816380.4578012836367250.228900641818362
530.709473030286320.581053939427360.29052696971368
540.6875159684658270.6249680630683470.312484031534174
550.6559654180869830.6880691638260350.344034581913017
560.7333064986215160.5333870027569680.266693501378484
570.6596978785786130.6806042428427740.340302121421387
580.8488112628846320.3023774742307360.151188737115368
590.7947119745909860.4105760508180270.205288025409014
600.8579452066786230.2841095866427540.142054793321377
610.9380502754639980.1238994490720040.0619497245360019
620.8991995581039320.2016008837921360.100800441896068
630.9160337153107050.1679325693785910.0839662846892954
640.871133982298050.2577320354039020.128866017701951
650.8099762448695220.3800475102609560.190023755130478
660.7088794571122270.5822410857755460.291120542887773
670.6558069783074550.688386043385090.344193021692545
680.9566914852983450.08661702940330950.0433085147016548
690.8826906009027220.2346187981945560.117309399097278

\begin{tabular}{lllllllll}
\hline
Goldfeld-Quandt test for Heteroskedasticity \tabularnewline
p-values & Alternative Hypothesis \tabularnewline
breakpoint index & greater & 2-sided & less \tabularnewline
16 & 0.410470996199494 & 0.820941992398988 & 0.589529003800506 \tabularnewline
17 & 0.259118183243931 & 0.518236366487862 & 0.74088181675607 \tabularnewline
18 & 0.17125649233413 & 0.34251298466826 & 0.82874350766587 \tabularnewline
19 & 0.284277881891812 & 0.568555763783624 & 0.715722118108188 \tabularnewline
20 & 0.195827088282722 & 0.391654176565444 & 0.804172911717278 \tabularnewline
21 & 0.149820493539177 & 0.299640987078354 & 0.850179506460823 \tabularnewline
22 & 0.184893685168866 & 0.369787370337732 & 0.815106314831134 \tabularnewline
23 & 0.121284809025399 & 0.242569618050798 & 0.878715190974601 \tabularnewline
24 & 0.177836394217047 & 0.355672788434093 & 0.822163605782953 \tabularnewline
25 & 0.334657360190412 & 0.669314720380823 & 0.665342639809588 \tabularnewline
26 & 0.263499053773161 & 0.526998107546322 & 0.736500946226839 \tabularnewline
27 & 0.203007916610888 & 0.406015833221777 & 0.796992083389112 \tabularnewline
28 & 0.204624168732515 & 0.40924833746503 & 0.795375831267485 \tabularnewline
29 & 0.271182131169747 & 0.542364262339494 & 0.728817868830253 \tabularnewline
30 & 0.336110399242649 & 0.672220798485299 & 0.663889600757351 \tabularnewline
31 & 0.273026161161829 & 0.546052322323658 & 0.726973838838171 \tabularnewline
32 & 0.302082489499451 & 0.604164978998903 & 0.697917510500549 \tabularnewline
33 & 0.365347609761465 & 0.73069521952293 & 0.634652390238535 \tabularnewline
34 & 0.59779035575591 & 0.80441928848818 & 0.40220964424409 \tabularnewline
35 & 0.776648697867204 & 0.446702604265591 & 0.223351302132795 \tabularnewline
36 & 0.800669767061176 & 0.398660465877648 & 0.199330232938824 \tabularnewline
37 & 0.748411426406226 & 0.503177147187549 & 0.251588573593774 \tabularnewline
38 & 0.808221187126456 & 0.383557625747087 & 0.191778812873544 \tabularnewline
39 & 0.842908219973132 & 0.314183560053736 & 0.157091780026868 \tabularnewline
40 & 0.81105734300992 & 0.377885313980161 & 0.18894265699008 \tabularnewline
41 & 0.851116300718952 & 0.297767398562096 & 0.148883699281048 \tabularnewline
42 & 0.873759335736937 & 0.252481328526125 & 0.126240664263063 \tabularnewline
43 & 0.865779879935829 & 0.268440240128343 & 0.134220120064171 \tabularnewline
44 & 0.845450369019582 & 0.309099261960836 & 0.154549630980418 \tabularnewline
45 & 0.806716146989417 & 0.386567706021166 & 0.193283853010583 \tabularnewline
46 & 0.801429233474893 & 0.397141533050215 & 0.198570766525107 \tabularnewline
47 & 0.791836821342463 & 0.416326357315074 & 0.208163178657537 \tabularnewline
48 & 0.738551511111357 & 0.522896977777286 & 0.261448488888643 \tabularnewline
49 & 0.707567612109674 & 0.584864775780652 & 0.292432387890326 \tabularnewline
50 & 0.677078928744756 & 0.645842142510488 & 0.322921071255244 \tabularnewline
51 & 0.728001645556774 & 0.543996708886452 & 0.271998354443226 \tabularnewline
52 & 0.771099358181638 & 0.457801283636725 & 0.228900641818362 \tabularnewline
53 & 0.70947303028632 & 0.58105393942736 & 0.29052696971368 \tabularnewline
54 & 0.687515968465827 & 0.624968063068347 & 0.312484031534174 \tabularnewline
55 & 0.655965418086983 & 0.688069163826035 & 0.344034581913017 \tabularnewline
56 & 0.733306498621516 & 0.533387002756968 & 0.266693501378484 \tabularnewline
57 & 0.659697878578613 & 0.680604242842774 & 0.340302121421387 \tabularnewline
58 & 0.848811262884632 & 0.302377474230736 & 0.151188737115368 \tabularnewline
59 & 0.794711974590986 & 0.410576050818027 & 0.205288025409014 \tabularnewline
60 & 0.857945206678623 & 0.284109586642754 & 0.142054793321377 \tabularnewline
61 & 0.938050275463998 & 0.123899449072004 & 0.0619497245360019 \tabularnewline
62 & 0.899199558103932 & 0.201600883792136 & 0.100800441896068 \tabularnewline
63 & 0.916033715310705 & 0.167932569378591 & 0.0839662846892954 \tabularnewline
64 & 0.87113398229805 & 0.257732035403902 & 0.128866017701951 \tabularnewline
65 & 0.809976244869522 & 0.380047510260956 & 0.190023755130478 \tabularnewline
66 & 0.708879457112227 & 0.582241085775546 & 0.291120542887773 \tabularnewline
67 & 0.655806978307455 & 0.68838604338509 & 0.344193021692545 \tabularnewline
68 & 0.956691485298345 & 0.0866170294033095 & 0.0433085147016548 \tabularnewline
69 & 0.882690600902722 & 0.234618798194556 & 0.117309399097278 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155354&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.410470996199494[/C][C]0.820941992398988[/C][C]0.589529003800506[/C][/ROW]
[ROW][C]17[/C][C]0.259118183243931[/C][C]0.518236366487862[/C][C]0.74088181675607[/C][/ROW]
[ROW][C]18[/C][C]0.17125649233413[/C][C]0.34251298466826[/C][C]0.82874350766587[/C][/ROW]
[ROW][C]19[/C][C]0.284277881891812[/C][C]0.568555763783624[/C][C]0.715722118108188[/C][/ROW]
[ROW][C]20[/C][C]0.195827088282722[/C][C]0.391654176565444[/C][C]0.804172911717278[/C][/ROW]
[ROW][C]21[/C][C]0.149820493539177[/C][C]0.299640987078354[/C][C]0.850179506460823[/C][/ROW]
[ROW][C]22[/C][C]0.184893685168866[/C][C]0.369787370337732[/C][C]0.815106314831134[/C][/ROW]
[ROW][C]23[/C][C]0.121284809025399[/C][C]0.242569618050798[/C][C]0.878715190974601[/C][/ROW]
[ROW][C]24[/C][C]0.177836394217047[/C][C]0.355672788434093[/C][C]0.822163605782953[/C][/ROW]
[ROW][C]25[/C][C]0.334657360190412[/C][C]0.669314720380823[/C][C]0.665342639809588[/C][/ROW]
[ROW][C]26[/C][C]0.263499053773161[/C][C]0.526998107546322[/C][C]0.736500946226839[/C][/ROW]
[ROW][C]27[/C][C]0.203007916610888[/C][C]0.406015833221777[/C][C]0.796992083389112[/C][/ROW]
[ROW][C]28[/C][C]0.204624168732515[/C][C]0.40924833746503[/C][C]0.795375831267485[/C][/ROW]
[ROW][C]29[/C][C]0.271182131169747[/C][C]0.542364262339494[/C][C]0.728817868830253[/C][/ROW]
[ROW][C]30[/C][C]0.336110399242649[/C][C]0.672220798485299[/C][C]0.663889600757351[/C][/ROW]
[ROW][C]31[/C][C]0.273026161161829[/C][C]0.546052322323658[/C][C]0.726973838838171[/C][/ROW]
[ROW][C]32[/C][C]0.302082489499451[/C][C]0.604164978998903[/C][C]0.697917510500549[/C][/ROW]
[ROW][C]33[/C][C]0.365347609761465[/C][C]0.73069521952293[/C][C]0.634652390238535[/C][/ROW]
[ROW][C]34[/C][C]0.59779035575591[/C][C]0.80441928848818[/C][C]0.40220964424409[/C][/ROW]
[ROW][C]35[/C][C]0.776648697867204[/C][C]0.446702604265591[/C][C]0.223351302132795[/C][/ROW]
[ROW][C]36[/C][C]0.800669767061176[/C][C]0.398660465877648[/C][C]0.199330232938824[/C][/ROW]
[ROW][C]37[/C][C]0.748411426406226[/C][C]0.503177147187549[/C][C]0.251588573593774[/C][/ROW]
[ROW][C]38[/C][C]0.808221187126456[/C][C]0.383557625747087[/C][C]0.191778812873544[/C][/ROW]
[ROW][C]39[/C][C]0.842908219973132[/C][C]0.314183560053736[/C][C]0.157091780026868[/C][/ROW]
[ROW][C]40[/C][C]0.81105734300992[/C][C]0.377885313980161[/C][C]0.18894265699008[/C][/ROW]
[ROW][C]41[/C][C]0.851116300718952[/C][C]0.297767398562096[/C][C]0.148883699281048[/C][/ROW]
[ROW][C]42[/C][C]0.873759335736937[/C][C]0.252481328526125[/C][C]0.126240664263063[/C][/ROW]
[ROW][C]43[/C][C]0.865779879935829[/C][C]0.268440240128343[/C][C]0.134220120064171[/C][/ROW]
[ROW][C]44[/C][C]0.845450369019582[/C][C]0.309099261960836[/C][C]0.154549630980418[/C][/ROW]
[ROW][C]45[/C][C]0.806716146989417[/C][C]0.386567706021166[/C][C]0.193283853010583[/C][/ROW]
[ROW][C]46[/C][C]0.801429233474893[/C][C]0.397141533050215[/C][C]0.198570766525107[/C][/ROW]
[ROW][C]47[/C][C]0.791836821342463[/C][C]0.416326357315074[/C][C]0.208163178657537[/C][/ROW]
[ROW][C]48[/C][C]0.738551511111357[/C][C]0.522896977777286[/C][C]0.261448488888643[/C][/ROW]
[ROW][C]49[/C][C]0.707567612109674[/C][C]0.584864775780652[/C][C]0.292432387890326[/C][/ROW]
[ROW][C]50[/C][C]0.677078928744756[/C][C]0.645842142510488[/C][C]0.322921071255244[/C][/ROW]
[ROW][C]51[/C][C]0.728001645556774[/C][C]0.543996708886452[/C][C]0.271998354443226[/C][/ROW]
[ROW][C]52[/C][C]0.771099358181638[/C][C]0.457801283636725[/C][C]0.228900641818362[/C][/ROW]
[ROW][C]53[/C][C]0.70947303028632[/C][C]0.58105393942736[/C][C]0.29052696971368[/C][/ROW]
[ROW][C]54[/C][C]0.687515968465827[/C][C]0.624968063068347[/C][C]0.312484031534174[/C][/ROW]
[ROW][C]55[/C][C]0.655965418086983[/C][C]0.688069163826035[/C][C]0.344034581913017[/C][/ROW]
[ROW][C]56[/C][C]0.733306498621516[/C][C]0.533387002756968[/C][C]0.266693501378484[/C][/ROW]
[ROW][C]57[/C][C]0.659697878578613[/C][C]0.680604242842774[/C][C]0.340302121421387[/C][/ROW]
[ROW][C]58[/C][C]0.848811262884632[/C][C]0.302377474230736[/C][C]0.151188737115368[/C][/ROW]
[ROW][C]59[/C][C]0.794711974590986[/C][C]0.410576050818027[/C][C]0.205288025409014[/C][/ROW]
[ROW][C]60[/C][C]0.857945206678623[/C][C]0.284109586642754[/C][C]0.142054793321377[/C][/ROW]
[ROW][C]61[/C][C]0.938050275463998[/C][C]0.123899449072004[/C][C]0.0619497245360019[/C][/ROW]
[ROW][C]62[/C][C]0.899199558103932[/C][C]0.201600883792136[/C][C]0.100800441896068[/C][/ROW]
[ROW][C]63[/C][C]0.916033715310705[/C][C]0.167932569378591[/C][C]0.0839662846892954[/C][/ROW]
[ROW][C]64[/C][C]0.87113398229805[/C][C]0.257732035403902[/C][C]0.128866017701951[/C][/ROW]
[ROW][C]65[/C][C]0.809976244869522[/C][C]0.380047510260956[/C][C]0.190023755130478[/C][/ROW]
[ROW][C]66[/C][C]0.708879457112227[/C][C]0.582241085775546[/C][C]0.291120542887773[/C][/ROW]
[ROW][C]67[/C][C]0.655806978307455[/C][C]0.68838604338509[/C][C]0.344193021692545[/C][/ROW]
[ROW][C]68[/C][C]0.956691485298345[/C][C]0.0866170294033095[/C][C]0.0433085147016548[/C][/ROW]
[ROW][C]69[/C][C]0.882690600902722[/C][C]0.234618798194556[/C][C]0.117309399097278[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155354&T=5

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155354&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.4104709961994940.8209419923989880.589529003800506
170.2591181832439310.5182363664878620.74088181675607
180.171256492334130.342512984668260.82874350766587
190.2842778818918120.5685557637836240.715722118108188
200.1958270882827220.3916541765654440.804172911717278
210.1498204935391770.2996409870783540.850179506460823
220.1848936851688660.3697873703377320.815106314831134
230.1212848090253990.2425696180507980.878715190974601
240.1778363942170470.3556727884340930.822163605782953
250.3346573601904120.6693147203808230.665342639809588
260.2634990537731610.5269981075463220.736500946226839
270.2030079166108880.4060158332217770.796992083389112
280.2046241687325150.409248337465030.795375831267485
290.2711821311697470.5423642623394940.728817868830253
300.3361103992426490.6722207984852990.663889600757351
310.2730261611618290.5460523223236580.726973838838171
320.3020824894994510.6041649789989030.697917510500549
330.3653476097614650.730695219522930.634652390238535
340.597790355755910.804419288488180.40220964424409
350.7766486978672040.4467026042655910.223351302132795
360.8006697670611760.3986604658776480.199330232938824
370.7484114264062260.5031771471875490.251588573593774
380.8082211871264560.3835576257470870.191778812873544
390.8429082199731320.3141835600537360.157091780026868
400.811057343009920.3778853139801610.18894265699008
410.8511163007189520.2977673985620960.148883699281048
420.8737593357369370.2524813285261250.126240664263063
430.8657798799358290.2684402401283430.134220120064171
440.8454503690195820.3090992619608360.154549630980418
450.8067161469894170.3865677060211660.193283853010583
460.8014292334748930.3971415330502150.198570766525107
470.7918368213424630.4163263573150740.208163178657537
480.7385515111113570.5228969777772860.261448488888643
490.7075676121096740.5848647757806520.292432387890326
500.6770789287447560.6458421425104880.322921071255244
510.7280016455567740.5439967088864520.271998354443226
520.7710993581816380.4578012836367250.228900641818362
530.709473030286320.581053939427360.29052696971368
540.6875159684658270.6249680630683470.312484031534174
550.6559654180869830.6880691638260350.344034581913017
560.7333064986215160.5333870027569680.266693501378484
570.6596978785786130.6806042428427740.340302121421387
580.8488112628846320.3023774742307360.151188737115368
590.7947119745909860.4105760508180270.205288025409014
600.8579452066786230.2841095866427540.142054793321377
610.9380502754639980.1238994490720040.0619497245360019
620.8991995581039320.2016008837921360.100800441896068
630.9160337153107050.1679325693785910.0839662846892954
640.871133982298050.2577320354039020.128866017701951
650.8099762448695220.3800475102609560.190023755130478
660.7088794571122270.5822410857755460.291120542887773
670.6558069783074550.688386043385090.344193021692545
680.9566914852983450.08661702940330950.0433085147016548
690.8826906009027220.2346187981945560.117309399097278






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 level10.0185185185185185OK

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

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


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