Repository of Reproducible Computations

Free Statistics

of Irreproducible Research!

Author's title

Author

*The author of this computation has been verified*

R Software Module

rwasp_multipleregression.wasp

Title produced by software

Multiple Regression

Date of computation

Mon, 11 Dec 2017 14:29:19 +0100

Cite this page as follows

Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2017/Dec/11/t151300029030kfzsi02gjq4jz.htm/, Retrieved Wed, 15 May 2024 22:17:49 +0000

Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=308982, Retrieved Wed, 15 May 2024 22:17:49 +0000

QR Codes:

Paste this QR Code to cite your computation.

Original text written by user:

IsPrivate?

No (this computation is public)

User-defined keywords

Estimated Impact

133

Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)

-       [Multiple Regression] [] [2017-12-11 13:29:19] [20141777ecd6b11d9726230b5f8289b4] [Current]

Feedback Forum

Post a new message

Dataseries X:

Download CSV

Histogram

Boxplots

120.7	157.9	52
134.1	196.3	54.9
143.6	197.2	60.5
115.1	161	54.8
135.1	196.5	60.1
123.6	179.6	60.3
110.7	161.6	49.8
104.3	175	53.8
143.7	201.4	64.8
149.7	192	62
143.3	165.4	65.2
115.3	136.9	60.1
136.2	175.1	61.2
137.4	176.1	63.6
147.6	199.3	68.6
123.7	158.3	63.1
131.6	182.1	66.5
132.7	180.3	71.9
123	175.2	58.1
108.2	175.8	61.5
140.9	182.3	66.2
149.2	158.9	72.3
134.5	134.9	67
103.2	104.5	62.9
136.2	144.1	66.4
135.6	175.1	65.6
139.7	166.7	70.9
131	143.7	68.4
124.4	173.8	66.4
123.6	169.8	67.6
125.1	168.2	64.1
106.2	145.3	62.1
144.4	147.4	70
153.7	167.3	74.4
131.5	127.8	67
105.5	111.1	64.8
136.3	135.2	70.7
133.4	131	64
129.8	136.9	72.5
129.1	135.4	70.4
113	116.4	63.6
117.1	134.3	69.8
115.4	140.3	67.7
96.5	115.9	66.4
141	131.2	78.9
141.3	138.6	79.9
121	115.8	69.1
106	112.2	81.2
121.9	114.6	66
122.4	129.2	71.8
137.4	133.9	86.1
118.9	121.8	76.1
106.7	118.7	70.5
126.5	148.8	83.3
110.8	135.2	74.8
99.3	116.9	73.4
138.7	131.4	86.5
128.9	108.8	82
121.9	108.3	80.8
106	103.6	91.5
113.1	101.8	77
124.2	102.6	72.3
129.2	125.5	83.5
116.5	94.1	79
105.7	108.4	76.7
122	130	83.1
105.1	135	71.1
100.8	109.1	75.5
131.8	130.2	90.9
119.9	112	85.4
127.1	127.3	84.8
107.1	102.5	83.8
115.8	119.1	79.3
122.9	118.4	79.9
137.5	131.8	93
108.9	100.4	78.1
114.9	123.3	82.3
129.7	125.4	87.3
111.8	123.4	74.6
103.4	124.2	80
140.3	134.4	91.3
140.7	125.7	94.2
136.1	111.8	90.9
106.3	81.4	88
127.7	114.1	81.6
136.4	118.1	77.4
145.1	119.2	91
116.5	103.4	79.9
117.6	116.2	83.4
129	137.2	91.6
117.4	129.3	85.2
107.2	127.8	84.1
130.9	148.7	87
145.1	117.9	92.8
127.8	95.2	89.2
96.6	105.4	87.3
126	122.7	89.5
130.1	121.8	86.8
124.5	133.7	92
137.4	125.7	92.2
105.6	146.7	86.4
113.3	136.2	92.9
108.4	153.1	91.2
83.5	125.4	80.3
116.2	130.5	102
115.6	107	99
95.6	87.7	89.2
83.5	81.2	103
95.3	97.9	80.4
95.8	106.3	83.4
100.4	102.9	97.6
90.9	89.1	87
80	94.6	84.4
93.8	116.8	94.1
92.3	130	88.9
74.3	112.9	82.3
101.4	105.5	94.7
103.7	95	94.5
92.4	79.2	91.6
83.4	85.2	96.8
91.6	100.8	87.9
101.2	102.5	99.9
109.2	106.5	109.5
100.3	87.1	91.2
91	86.1	89.4
110.9	104.4	109.7
96.3	131.5	96.9
80.4	116.5	94.1
114.5	113.5	104.4
109.9	85.4	100.8
104.1	81.7	107.4
90.7	84	108.9
94.6	88.5	95.2
100.4	102.7	102.7
115.9	98.7	130.9
94.4	84.5	104
102.5	102.5	106.5
97.3	93.1	106.1
90	115.4	97.8
81.1	109	112.2
107.3	103.1	114.5
100.5	71.5	105.8
95.4	82.3	101
81.1	82.2	101.2
92.2	98.2	96.5
98.4	81.7	99.5
98.6	97.9	123.8
81.4	76.6	94.6
85.5	98.8	95.8
90.4	124.4	105.4
83.7	146.9	104.4
73.3	107.7	105.2
89.8	94.6	112.7
101.6	91.5	114.8
87.5	94.3	108.9
65.3	86.4	103.8
87.1	123.3	102.5
89.9	89.5	98.1
91.5	101.6	118.2
84.7	93.6	114.8
84.1	128.1	109.9
86.7	129.5	116.7
89.6	155.6	116.9
65.7	123	104.4
92.9	109.8	113.5
97.7	95.5	123.8
84.4	101.3	116.4
68.1	111.5	114.1
95	118.5	102.8
96.3	108.4	112.7
94.7	121.4	121.1
89.7	128.7	120.8
81.3	139	117.8
89.3	142	130.4
94.2	164.8	110.9
68.7	130.8	105.4
105.7	133.1	137.6
102	114.8	133.3
84.3	95.9	123.3
74.9	97.7	122.8
92.9	104.5	110.2
100.4	100.2	101.4
99.4	125.3	128.7
94.6	125.5	120.6
84	126.9	110.1
102.2	151	121.6
91.4	149.2	113
79.8	123.7	115.9
101	124.1	131.1
97.5	112.5	127.4
87.8	98.5	123.9
77.1	93.7	120.8
89.6	98.2	108.5
100.9	98.6	112.9
97.8	115.7	129.6
90.5	112.5	121.3
84.2	139.8	119.1
96.8	151.8	140.8
82.9	146.4	127.4
75.6	118.2	128.1
91.9	117.9	136.6
85.4	121	126.5
90.4	109.8	120.8
74	93.7	144.3
93.1	108.9	116
94.9	89.3	123.4
102.9	99.7	138.6
80.7	97.4	118.3
91.7	125.9	124.2
95.5	137.1	136
84.8	126.9	127.4
74.4	100	131.6

Summary of computational transaction
Raw Input	view raw input (R code)
Raw Output	view raw output of R engine
Computing time	9 seconds
R Server	Big Analytics Cloud Computing Center

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input view raw input (R code)  \tabularnewline
Raw Outputview raw output of R engine  \tabularnewline
Computing time9 seconds \tabularnewline
R ServerBig Analytics Cloud Computing Center \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&T=0

[TABLE]
[ROW]

Summary of computational transaction[/C][/ROW] [ROW]

Raw Input[/C]

view raw input (R code) [/C][/ROW] [ROW]

Raw Output[/C]

view raw output of R engine [/C][/ROW] [ROW]

Computing time[/C]

9 seconds[/C][/ROW] [ROW]

R Server[/C]

Big Analytics Cloud Computing Center[/C][/ROW] [/TABLE] Source: https://freestatistics.org/blog/index.php?pk=308982&T=0

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

As an alternative you can also use a QR Code:

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

Summary of computational transaction
Raw Input	view raw input (R code)
Raw Output	view raw output of R engine
Computing time	9 seconds
R Server	Big Analytics Cloud Computing Center

Multiple Linear Regression - Estimated Regression Equation
Texkled[t] = + 17.3129 + 0.0635625Leerprod[t] + 0.241825Consprod[t] + 0.224612`Texkled(t-1)`[t] + 0.224951`Texkled(t-2)`[t] + 0.211956`Texkled(t-3)`[t] -0.00670425`Texkled(t-4)`[t] + 0.0731289`Texkled(t-5)`[t] + 0.260896`Texkled(t-6)`[t] -0.11077`Texkled(t-7)`[t] + 0.0111181`Texkled(t-8)`[t] + 0.00923464`Texkled(t-9)`[t] -0.106694`Texkled(t-10)`[t] -11.0767M1[t] -35.6453M2[t] -5.51688M3[t] + 0.397115M4[t] -9.93729M5[t] -19.7174M6[t] -21.1704M7[t] -11.3089M8[t] -19.4184M9[t] -30.6906M10[t] -1.36229M11[t] -0.12076t + e[t]

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Estimated Regression Equation \tabularnewline
Texkled[t] =  +  17.3129 +  0.0635625Leerprod[t] +  0.241825Consprod[t] +  0.224612`Texkled(t-1)`[t] +  0.224951`Texkled(t-2)`[t] +  0.211956`Texkled(t-3)`[t] -0.00670425`Texkled(t-4)`[t] +  0.0731289`Texkled(t-5)`[t] +  0.260896`Texkled(t-6)`[t] -0.11077`Texkled(t-7)`[t] +  0.0111181`Texkled(t-8)`[t] +  0.00923464`Texkled(t-9)`[t] -0.106694`Texkled(t-10)`[t] -11.0767M1[t] -35.6453M2[t] -5.51688M3[t] +  0.397115M4[t] -9.93729M5[t] -19.7174M6[t] -21.1704M7[t] -11.3089M8[t] -19.4184M9[t] -30.6906M10[t] -1.36229M11[t] -0.12076t  + e[t] \tabularnewline
 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&T=1

[TABLE]
[ROW][C]Multiple Linear Regression - Estimated Regression Equation[/C][/ROW]
[ROW][C]Texkled[t] =  +  17.3129 +  0.0635625Leerprod[t] +  0.241825Consprod[t] +  0.224612`Texkled(t-1)`[t] +  0.224951`Texkled(t-2)`[t] +  0.211956`Texkled(t-3)`[t] -0.00670425`Texkled(t-4)`[t] +  0.0731289`Texkled(t-5)`[t] +  0.260896`Texkled(t-6)`[t] -0.11077`Texkled(t-7)`[t] +  0.0111181`Texkled(t-8)`[t] +  0.00923464`Texkled(t-9)`[t] -0.106694`Texkled(t-10)`[t] -11.0767M1[t] -35.6453M2[t] -5.51688M3[t] +  0.397115M4[t] -9.93729M5[t] -19.7174M6[t] -21.1704M7[t] -11.3089M8[t] -19.4184M9[t] -30.6906M10[t] -1.36229M11[t] -0.12076t  + e[t][/C][/ROW]
[ROW][C][/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=308982&T=1

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

As an alternative you can also use a QR Code:

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

Multiple Linear Regression - Estimated Regression Equation
Texkled[t] = + 17.3129 + 0.0635625Leerprod[t] + 0.241825Consprod[t] + 0.224612`Texkled(t-1)`[t] + 0.224951`Texkled(t-2)`[t] + 0.211956`Texkled(t-3)`[t] -0.00670425`Texkled(t-4)`[t] + 0.0731289`Texkled(t-5)`[t] + 0.260896`Texkled(t-6)`[t] -0.11077`Texkled(t-7)`[t] + 0.0111181`Texkled(t-8)`[t] + 0.00923464`Texkled(t-9)`[t] -0.106694`Texkled(t-10)`[t] -11.0767M1[t] -35.6453M2[t] -5.51688M3[t] + 0.397115M4[t] -9.93729M5[t] -19.7174M6[t] -21.1704M7[t] -11.3089M8[t] -19.4184M9[t] -30.6906M10[t] -1.36229M11[t] -0.12076t + e[t]

Multiple Linear Regression - Ordinary Least Squares
Variable	Parameter	S.D.	T-STATH0: parameter = 0	2-tail p-value	1-tail p-value
(Intercept)	+17.31	9.899	+1.7490e+00	0.08203	0.04102
Leerprod	+0.06356	0.02322	+2.7370e+00	0.006828	0.003414
Consprod	+0.2418	0.0838	+2.8860e+00	0.00439	0.002195
`Texkled(t-1)`	+0.2246	0.06993	+3.2120e+00	0.001566	0.000783
`Texkled(t-2)`	+0.225	0.07139	+3.1510e+00	0.001911	0.0009557
`Texkled(t-3)`	+0.212	0.07638	+2.7750e+00	0.006114	0.003057
`Texkled(t-4)`	-0.006704	0.0747	-8.9750e-02	0.9286	0.4643
`Texkled(t-5)`	+0.07313	0.07232	+1.0110e+00	0.3133	0.1567
`Texkled(t-6)`	+0.2609	0.07066	+3.6920e+00	0.0002958	0.0001479
`Texkled(t-7)`	-0.1108	0.07314	-1.5150e+00	0.1317	0.06584
`Texkled(t-8)`	+0.01112	0.07096	+1.5670e-01	0.8757	0.4378
`Texkled(t-9)`	+0.009235	0.06947	+1.3290e-01	0.8944	0.4472
`Texkled(t-10)`	-0.1067	0.06757	-1.5790e+00	0.1161	0.05807
M1	-11.08	3.717	-2.9800e+00	0.00329	0.001645
M2	-35.65	4.772	-7.4690e+00	3.546e-12	1.773e-12
M3	-5.517	4.918	-1.1220e+00	0.2635	0.1317
M4	+0.3971	3.522	+1.1280e-01	0.9103	0.4552
M5	-9.937	4.319	-2.3010e+00	0.02257	0.01128
M6	-19.72	4.682	-4.2110e+00	4.038e-05	2.019e-05
M7	-21.17	4.079	-5.1900e+00	5.716e-07	2.858e-07
M8	-11.31	3.345	-3.3810e+00	0.0008902	0.0004451
M9	-19.42	4.089	-4.7490e+00	4.2e-06	2.1e-06
M10	-30.69	4.616	-6.6490e+00	3.534e-10	1.767e-10
M11	-1.362	4.166	-3.2700e-01	0.7441	0.372
t	-0.1208	0.03433	-3.5180e+00	0.0005528	0.0002764

\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) & +17.31 &  9.899 & +1.7490e+00 &  0.08203 &  0.04102 \tabularnewline
Leerprod & +0.06356 &  0.02322 & +2.7370e+00 &  0.006828 &  0.003414 \tabularnewline
Consprod & +0.2418 &  0.0838 & +2.8860e+00 &  0.00439 &  0.002195 \tabularnewline
`Texkled(t-1)` & +0.2246 &  0.06993 & +3.2120e+00 &  0.001566 &  0.000783 \tabularnewline
`Texkled(t-2)` & +0.225 &  0.07139 & +3.1510e+00 &  0.001911 &  0.0009557 \tabularnewline
`Texkled(t-3)` & +0.212 &  0.07638 & +2.7750e+00 &  0.006114 &  0.003057 \tabularnewline
`Texkled(t-4)` & -0.006704 &  0.0747 & -8.9750e-02 &  0.9286 &  0.4643 \tabularnewline
`Texkled(t-5)` & +0.07313 &  0.07232 & +1.0110e+00 &  0.3133 &  0.1567 \tabularnewline
`Texkled(t-6)` & +0.2609 &  0.07066 & +3.6920e+00 &  0.0002958 &  0.0001479 \tabularnewline
`Texkled(t-7)` & -0.1108 &  0.07314 & -1.5150e+00 &  0.1317 &  0.06584 \tabularnewline
`Texkled(t-8)` & +0.01112 &  0.07096 & +1.5670e-01 &  0.8757 &  0.4378 \tabularnewline
`Texkled(t-9)` & +0.009235 &  0.06947 & +1.3290e-01 &  0.8944 &  0.4472 \tabularnewline
`Texkled(t-10)` & -0.1067 &  0.06757 & -1.5790e+00 &  0.1161 &  0.05807 \tabularnewline
M1 & -11.08 &  3.717 & -2.9800e+00 &  0.00329 &  0.001645 \tabularnewline
M2 & -35.65 &  4.772 & -7.4690e+00 &  3.546e-12 &  1.773e-12 \tabularnewline
M3 & -5.517 &  4.918 & -1.1220e+00 &  0.2635 &  0.1317 \tabularnewline
M4 & +0.3971 &  3.522 & +1.1280e-01 &  0.9103 &  0.4552 \tabularnewline
M5 & -9.937 &  4.319 & -2.3010e+00 &  0.02257 &  0.01128 \tabularnewline
M6 & -19.72 &  4.682 & -4.2110e+00 &  4.038e-05 &  2.019e-05 \tabularnewline
M7 & -21.17 &  4.079 & -5.1900e+00 &  5.716e-07 &  2.858e-07 \tabularnewline
M8 & -11.31 &  3.345 & -3.3810e+00 &  0.0008902 &  0.0004451 \tabularnewline
M9 & -19.42 &  4.089 & -4.7490e+00 &  4.2e-06 &  2.1e-06 \tabularnewline
M10 & -30.69 &  4.616 & -6.6490e+00 &  3.534e-10 &  1.767e-10 \tabularnewline
M11 & -1.362 &  4.166 & -3.2700e-01 &  0.7441 &  0.372 \tabularnewline
t & -0.1208 &  0.03433 & -3.5180e+00 &  0.0005528 &  0.0002764 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&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]+17.31[/C][C] 9.899[/C][C]+1.7490e+00[/C][C] 0.08203[/C][C] 0.04102[/C][/ROW]
[ROW][C]Leerprod[/C][C]+0.06356[/C][C] 0.02322[/C][C]+2.7370e+00[/C][C] 0.006828[/C][C] 0.003414[/C][/ROW]
[ROW][C]Consprod[/C][C]+0.2418[/C][C] 0.0838[/C][C]+2.8860e+00[/C][C] 0.00439[/C][C] 0.002195[/C][/ROW]
[ROW][C]`Texkled(t-1)`[/C][C]+0.2246[/C][C] 0.06993[/C][C]+3.2120e+00[/C][C] 0.001566[/C][C] 0.000783[/C][/ROW]
[ROW][C]`Texkled(t-2)`[/C][C]+0.225[/C][C] 0.07139[/C][C]+3.1510e+00[/C][C] 0.001911[/C][C] 0.0009557[/C][/ROW]
[ROW][C]`Texkled(t-3)`[/C][C]+0.212[/C][C] 0.07638[/C][C]+2.7750e+00[/C][C] 0.006114[/C][C] 0.003057[/C][/ROW]
[ROW][C]`Texkled(t-4)`[/C][C]-0.006704[/C][C] 0.0747[/C][C]-8.9750e-02[/C][C] 0.9286[/C][C] 0.4643[/C][/ROW]
[ROW][C]`Texkled(t-5)`[/C][C]+0.07313[/C][C] 0.07232[/C][C]+1.0110e+00[/C][C] 0.3133[/C][C] 0.1567[/C][/ROW]
[ROW][C]`Texkled(t-6)`[/C][C]+0.2609[/C][C] 0.07066[/C][C]+3.6920e+00[/C][C] 0.0002958[/C][C] 0.0001479[/C][/ROW]
[ROW][C]`Texkled(t-7)`[/C][C]-0.1108[/C][C] 0.07314[/C][C]-1.5150e+00[/C][C] 0.1317[/C][C] 0.06584[/C][/ROW]
[ROW][C]`Texkled(t-8)`[/C][C]+0.01112[/C][C] 0.07096[/C][C]+1.5670e-01[/C][C] 0.8757[/C][C] 0.4378[/C][/ROW]
[ROW][C]`Texkled(t-9)`[/C][C]+0.009235[/C][C] 0.06947[/C][C]+1.3290e-01[/C][C] 0.8944[/C][C] 0.4472[/C][/ROW]
[ROW][C]`Texkled(t-10)`[/C][C]-0.1067[/C][C] 0.06757[/C][C]-1.5790e+00[/C][C] 0.1161[/C][C] 0.05807[/C][/ROW]
[ROW][C]M1[/C][C]-11.08[/C][C] 3.717[/C][C]-2.9800e+00[/C][C] 0.00329[/C][C] 0.001645[/C][/ROW]
[ROW][C]M2[/C][C]-35.65[/C][C] 4.772[/C][C]-7.4690e+00[/C][C] 3.546e-12[/C][C] 1.773e-12[/C][/ROW]
[ROW][C]M3[/C][C]-5.517[/C][C] 4.918[/C][C]-1.1220e+00[/C][C] 0.2635[/C][C] 0.1317[/C][/ROW]
[ROW][C]M4[/C][C]+0.3971[/C][C] 3.522[/C][C]+1.1280e-01[/C][C] 0.9103[/C][C] 0.4552[/C][/ROW]
[ROW][C]M5[/C][C]-9.937[/C][C] 4.319[/C][C]-2.3010e+00[/C][C] 0.02257[/C][C] 0.01128[/C][/ROW]
[ROW][C]M6[/C][C]-19.72[/C][C] 4.682[/C][C]-4.2110e+00[/C][C] 4.038e-05[/C][C] 2.019e-05[/C][/ROW]
[ROW][C]M7[/C][C]-21.17[/C][C] 4.079[/C][C]-5.1900e+00[/C][C] 5.716e-07[/C][C] 2.858e-07[/C][/ROW]
[ROW][C]M8[/C][C]-11.31[/C][C] 3.345[/C][C]-3.3810e+00[/C][C] 0.0008902[/C][C] 0.0004451[/C][/ROW]
[ROW][C]M9[/C][C]-19.42[/C][C] 4.089[/C][C]-4.7490e+00[/C][C] 4.2e-06[/C][C] 2.1e-06[/C][/ROW]
[ROW][C]M10[/C][C]-30.69[/C][C] 4.616[/C][C]-6.6490e+00[/C][C] 3.534e-10[/C][C] 1.767e-10[/C][/ROW]
[ROW][C]M11[/C][C]-1.362[/C][C] 4.166[/C][C]-3.2700e-01[/C][C] 0.7441[/C][C] 0.372[/C][/ROW]
[ROW][C]t[/C][C]-0.1208[/C][C] 0.03433[/C][C]-3.5180e+00[/C][C] 0.0005528[/C][C] 0.0002764[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=308982&T=2

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

As an alternative you can also use a QR Code:

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

Multiple Linear Regression - Ordinary Least Squares
Variable	Parameter	S.D.	T-STATH0: parameter = 0	2-tail p-value	1-tail p-value
(Intercept)	+17.31	9.899	+1.7490e+00	0.08203	0.04102
Leerprod	+0.06356	0.02322	+2.7370e+00	0.006828	0.003414
Consprod	+0.2418	0.0838	+2.8860e+00	0.00439	0.002195
`Texkled(t-1)`	+0.2246	0.06993	+3.2120e+00	0.001566	0.000783
`Texkled(t-2)`	+0.225	0.07139	+3.1510e+00	0.001911	0.0009557
`Texkled(t-3)`	+0.212	0.07638	+2.7750e+00	0.006114	0.003057
`Texkled(t-4)`	-0.006704	0.0747	-8.9750e-02	0.9286	0.4643
`Texkled(t-5)`	+0.07313	0.07232	+1.0110e+00	0.3133	0.1567
`Texkled(t-6)`	+0.2609	0.07066	+3.6920e+00	0.0002958	0.0001479
`Texkled(t-7)`	-0.1108	0.07314	-1.5150e+00	0.1317	0.06584
`Texkled(t-8)`	+0.01112	0.07096	+1.5670e-01	0.8757	0.4378
`Texkled(t-9)`	+0.009235	0.06947	+1.3290e-01	0.8944	0.4472
`Texkled(t-10)`	-0.1067	0.06757	-1.5790e+00	0.1161	0.05807
M1	-11.08	3.717	-2.9800e+00	0.00329	0.001645
M2	-35.65	4.772	-7.4690e+00	3.546e-12	1.773e-12
M3	-5.517	4.918	-1.1220e+00	0.2635	0.1317
M4	+0.3971	3.522	+1.1280e-01	0.9103	0.4552
M5	-9.937	4.319	-2.3010e+00	0.02257	0.01128
M6	-19.72	4.682	-4.2110e+00	4.038e-05	2.019e-05
M7	-21.17	4.079	-5.1900e+00	5.716e-07	2.858e-07
M8	-11.31	3.345	-3.3810e+00	0.0008902	0.0004451
M9	-19.42	4.089	-4.7490e+00	4.2e-06	2.1e-06
M10	-30.69	4.616	-6.6490e+00	3.534e-10	1.767e-10
M11	-1.362	4.166	-3.2700e-01	0.7441	0.372
t	-0.1208	0.03433	-3.5180e+00	0.0005528	0.0002764

Multiple Linear Regression - Regression Statistics
Multiple R	0.9661
R-squared	0.9334
Adjusted R-squared	0.9244
F-TEST (value)	103.4
F-TEST (DF numerator)	24
F-TEST (DF denominator)	177
p-value	0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation	5.525
Sum Squared Residuals	5403

\begin{tabular}{lllllllll}
\hline
Multiple Linear Regression - Regression Statistics \tabularnewline
Multiple R &  0.9661 \tabularnewline
R-squared &  0.9334 \tabularnewline
Adjusted R-squared &  0.9244 \tabularnewline
F-TEST (value) &  103.4 \tabularnewline
F-TEST (DF numerator) & 24 \tabularnewline
F-TEST (DF denominator) & 177 \tabularnewline
p-value &  0 \tabularnewline
Multiple Linear Regression - Residual Statistics \tabularnewline
Residual Standard Deviation &  5.525 \tabularnewline
Sum Squared Residuals &  5403 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&T=3

[TABLE]
[ROW][C]Multiple Linear Regression - Regression Statistics[/C][/ROW]
[ROW][C]Multiple R[/C][C] 0.9661[/C][/ROW]
[ROW][C]R-squared[/C][C] 0.9334[/C][/ROW]
[ROW][C]Adjusted R-squared[/C][C] 0.9244[/C][/ROW]
[ROW][C]F-TEST (value)[/C][C] 103.4[/C][/ROW]
[ROW][C]F-TEST (DF numerator)[/C][C]24[/C][/ROW]
[ROW][C]F-TEST (DF denominator)[/C][C]177[/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] 5.525[/C][/ROW]
[ROW][C]Sum Squared Residuals[/C][C] 5403[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=308982&T=3

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

As an alternative you can also use a QR Code:

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

Multiple Linear Regression - Regression Statistics
Multiple R	0.9661
R-squared	0.9334
Adjusted R-squared	0.9244
F-TEST (value)	103.4
F-TEST (DF numerator)	24
F-TEST (DF denominator)	177
p-value	0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation	5.525
Sum Squared Residuals	5403

Menu of Residual Diagnostics
Description	Link
Histogram	Compute
Central Tendency	Compute
QQ Plot	Compute
Kernel Density Plot	Compute
Skewness/Kurtosis Test	Compute
Skewness-Kurtosis Plot	Compute
Harrell-Davis Plot	Compute
Bootstrap Plot -- Central Tendency	Compute
Blocked Bootstrap Plot -- Central Tendency	Compute
(Partial) Autocorrelation Plot	Compute
Spectral Analysis	Compute
Tukey lambda PPCC Plot	Compute
Box-Cox Normality Plot	Compute
Summary Statistics	Compute

\begin{tabular}{lllllllll}
\hline
Menu of Residual Diagnostics \tabularnewline
Description & Link \tabularnewline
Histogram & Compute \tabularnewline
Central Tendency & Compute \tabularnewline
QQ Plot & Compute \tabularnewline
Kernel Density Plot & Compute \tabularnewline
Skewness/Kurtosis Test & Compute \tabularnewline
Skewness-Kurtosis Plot & Compute \tabularnewline
Harrell-Davis Plot & Compute \tabularnewline
Bootstrap Plot -- Central Tendency & Compute \tabularnewline
Blocked Bootstrap Plot -- Central Tendency & Compute \tabularnewline
(Partial) Autocorrelation Plot & Compute \tabularnewline
Spectral Analysis & Compute \tabularnewline
Tukey lambda PPCC Plot & Compute \tabularnewline
Box-Cox Normality Plot & Compute \tabularnewline
Summary Statistics & Compute \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&T=4

[TABLE]
[ROW][C]Menu of Residual Diagnostics[/C][/ROW]
[ROW][C]Description[/C][C]Link[/C][/ROW]
[ROW][C]Histogram[/C][C]Compute[/C][/ROW]
[ROW][C]Central Tendency[/C][C]Compute[/C][/ROW]
[ROW][C]QQ Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Kernel Density Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Skewness/Kurtosis Test[/C][C]Compute[/C][/ROW]
[ROW][C]Skewness-Kurtosis Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Harrell-Davis Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Bootstrap Plot -- Central Tendency[/C][C]Compute[/C][/ROW]
[ROW][C]Blocked Bootstrap Plot -- Central Tendency[/C][C]Compute[/C][/ROW]
[ROW][C](Partial) Autocorrelation Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Spectral Analysis[/C][C]Compute[/C][/ROW]
[ROW][C]Tukey lambda PPCC Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Box-Cox Normality Plot[/C][C]Compute[/C][/ROW]
[ROW][C]Summary Statistics[/C][C]Compute[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=308982&T=4

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

As an alternative you can also use a QR Code:

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

Menu of Residual Diagnostics
Description	Link
Histogram	Compute
Central Tendency	Compute
QQ Plot	Compute
Kernel Density Plot	Compute
Skewness/Kurtosis Test	Compute
Skewness-Kurtosis Plot	Compute
Harrell-Davis Plot	Compute
Bootstrap Plot -- Central Tendency	Compute
Blocked Bootstrap Plot -- Central Tendency	Compute
(Partial) Autocorrelation Plot	Compute
Spectral Analysis	Compute
Tukey lambda PPCC Plot	Compute
Box-Cox Normality Plot	Compute
Summary Statistics	Compute

Ramsey RESET F-Test for powers (2 and 3) of fitted values
> reset_test_fitted RESET test data: mylm RESET = 7.4034, df1 = 2, df2 = 175, p-value = 0.0008195
Ramsey RESET F-Test for powers (2 and 3) of regressors
> reset_test_regressors RESET test data: mylm RESET = 1.2034, df1 = 48, df2 = 129, p-value = 0.2064
Ramsey RESET F-Test for powers (2 and 3) of principal components
> reset_test_principal_components RESET test data: mylm RESET = 6.3988, df1 = 2, df2 = 175, p-value = 0.002079

\begin{tabular}{lllllllll}
\hline
Ramsey RESET F-Test for powers (2 and 3) of fitted values \tabularnewline
> reset_test_fitted
	RESET test
data:  mylm
RESET = 7.4034, df1 = 2, df2 = 175, p-value = 0.0008195
 \tabularnewline
Ramsey RESET F-Test for powers (2 and 3) of regressors \tabularnewline
> reset_test_regressors
	RESET test
data:  mylm
RESET = 1.2034, df1 = 48, df2 = 129, p-value = 0.2064
 \tabularnewline
Ramsey RESET F-Test for powers (2 and 3) of principal components \tabularnewline
> reset_test_principal_components
	RESET test
data:  mylm
RESET = 6.3988, df1 = 2, df2 = 175, p-value = 0.002079
 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&T=5

[TABLE]
[ROW][C]Ramsey RESET F-Test for powers (2 and 3) of fitted values[/C][/ROW]
[ROW][C]> reset_test_fitted
	RESET test
data:  mylm
RESET = 7.4034, df1 = 2, df2 = 175, p-value = 0.0008195
[/C][/ROW]
[ROW][C]Ramsey RESET F-Test for powers (2 and 3) of regressors[/C][/ROW]
[ROW][C]> reset_test_regressors
	RESET test
data:  mylm
RESET = 1.2034, df1 = 48, df2 = 129, p-value = 0.2064
[/C][/ROW]
[ROW][C]Ramsey RESET F-Test for powers (2 and 3) of principal components[/C][/ROW]
[ROW][C]> reset_test_principal_components
	RESET test
data:  mylm
RESET = 6.3988, df1 = 2, df2 = 175, p-value = 0.002079
[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=308982&T=5

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

As an alternative you can also use a QR Code:

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

Ramsey RESET F-Test for powers (2 and 3) of fitted values
> reset_test_fitted RESET test data: mylm RESET = 7.4034, df1 = 2, df2 = 175, p-value = 0.0008195
Ramsey RESET F-Test for powers (2 and 3) of regressors
> reset_test_regressors RESET test data: mylm RESET = 1.2034, df1 = 48, df2 = 129, p-value = 0.2064
Ramsey RESET F-Test for powers (2 and 3) of principal components
> reset_test_principal_components RESET test data: mylm RESET = 6.3988, df1 = 2, df2 = 175, p-value = 0.002079

Variance Inflation Factors (Multicollinearity)

> vif
       Leerprod        Consprod  `Texkled(t-1)`  `Texkled(t-2)`  `Texkled(t-3)` 
       2.156797       20.370814       13.134221       13.832163       15.808600 
 `Texkled(t-4)`  `Texkled(t-5)`  `Texkled(t-6)`  `Texkled(t-7)`  `Texkled(t-8)` 
      15.077516       14.057023       13.538440       14.485674       13.810545 
 `Texkled(t-9)` `Texkled(t-10)`              M1              M2              M3 
      13.160700       12.424717        7.047281       11.615403       12.336091 
             M4              M5              M6              M7              M8 
       6.325279        9.513420       11.180627        8.485054        5.707588 
             M9             M10             M11               t 
       8.525811       10.865931        8.376678       26.511825

\begin{tabular}{lllllllll}
\hline
Variance Inflation Factors (Multicollinearity) \tabularnewline
> vif
       Leerprod        Consprod  `Texkled(t-1)`  `Texkled(t-2)`  `Texkled(t-3)` 
       2.156797       20.370814       13.134221       13.832163       15.808600 
 `Texkled(t-4)`  `Texkled(t-5)`  `Texkled(t-6)`  `Texkled(t-7)`  `Texkled(t-8)` 
      15.077516       14.057023       13.538440       14.485674       13.810545 
 `Texkled(t-9)` `Texkled(t-10)`              M1              M2              M3 
      13.160700       12.424717        7.047281       11.615403       12.336091 
             M4              M5              M6              M7              M8 
       6.325279        9.513420       11.180627        8.485054        5.707588 
             M9             M10             M11               t 
       8.525811       10.865931        8.376678       26.511825 
 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=308982&T=6

[TABLE]
[ROW][C]Variance Inflation Factors (Multicollinearity)[/C][/ROW]
[ROW][C]> vif
       Leerprod        Consprod  `Texkled(t-1)`  `Texkled(t-2)`  `Texkled(t-3)` 
       2.156797       20.370814       13.134221       13.832163       15.808600 
 `Texkled(t-4)`  `Texkled(t-5)`  `Texkled(t-6)`  `Texkled(t-7)`  `Texkled(t-8)` 
      15.077516       14.057023       13.538440       14.485674       13.810545 
 `Texkled(t-9)` `Texkled(t-10)`              M1              M2              M3 
      13.160700       12.424717        7.047281       11.615403       12.336091 
             M4              M5              M6              M7              M8 
       6.325279        9.513420       11.180627        8.485054        5.707588 
             M9             M10             M11               t 
       8.525811       10.865931        8.376678       26.511825 
[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=308982&T=6

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

As an alternative you can also use a QR Code:

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

Variance Inflation Factors (Multicollinearity)

> vif
       Leerprod        Consprod  `Texkled(t-1)`  `Texkled(t-2)`  `Texkled(t-3)` 
       2.156797       20.370814       13.134221       13.832163       15.808600 
 `Texkled(t-4)`  `Texkled(t-5)`  `Texkled(t-6)`  `Texkled(t-7)`  `Texkled(t-8)` 
      15.077516       14.057023       13.538440       14.485674       13.810545 
 `Texkled(t-9)` `Texkled(t-10)`              M1              M2              M3 
      13.160700       12.424717        7.047281       11.615403       12.336091 
             M4              M5              M6              M7              M8 
       6.325279        9.513420       11.180627        8.485054        5.707588 
             M9             M10             M11               t 
       8.525811       10.865931        8.376678       26.511825

Figure 1

PNG link

Postscript link

PDF link

Figure 2

PNG link

Postscript link

PDF link

Figure 3

PNG link

Postscript link

PDF link

Figure 4

PNG link

Postscript link

PDF link

Figure 5

PNG link

Postscript link

PDF link

Figure 6

PNG link

Postscript link

PDF link

Figure 7

PNG link

Postscript link

PDF link

Figure 8

PNG link

Postscript link

PDF link

Figure 9

PNG link

Postscript link

PDF link

Figure 10

PNG link

Postscript link

PDF link

Parameters (Session):

par1 = 1 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ; par4 = 0 ; par5 = 0 ; par6 = 12 ;

Parameters (R input):

par1 = 1 ; par2 = Include Seasonal Dummies ; par3 = Linear Trend ; par4 = 10 ; par5 = 0 ; par6 = 12 ;

R code (references can be found in the software module):

par6 <- '12'
par5 <- '0'
par4 <- '4'
par3 <- 'Linear Trend'
par2 <- 'Include Seasonal Dummies'
par1 <- '1'
library(lattice)
library(lmtest)
library(car)
library(MASS)
n25 <- 25 #minimum number of obs. for Goldfeld-Quandt test
mywarning <- ''
par6 <- as.numeric(par6)
if(is.na(par6)) {
par6 <- 12
mywarning = 'Warning: you did not specify the seasonality. The seasonal period was set to s = 12.'
}
par1 <- as.numeric(par1)
if(is.na(par1)) {
par1 <- 1
mywarning = 'Warning: you did not specify the column number of the endogenous series! The first column was selected by default.'
}
if (par4=='') par4 <- 0
par4 <- as.numeric(par4)
if (!is.numeric(par4)) par4 <- 0
if (par5=='') par5 <- 0
par5 <- as.numeric(par5)
if (!is.numeric(par5)) par5 <- 0
x <- na.omit(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'){
(n <- n -1)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-B)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
}
if (par3 == 'Seasonal Differences (s)'){
(n <- n - par6)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-Bs)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+par6,j] - x[i,j]
}
}
x <- x2
}
if (par3 == 'First and Seasonal Differences (s)'){
(n <- n -1)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-B)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
(n <- n - par6)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-Bs)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+par6,j] - x[i,j]
}
}
x <- x2
}
if(par4 > 0) {
x2 <- array(0, dim=c(n-par4,par4), dimnames=list(1:(n-par4), paste(colnames(x)[par1],'(t-',1:par4,')',sep='')))
for (i in 1:(n-par4)) {
for (j in 1:par4) {
x2[i,j] <- x[i+par4-j,par1]
}
}
x <- cbind(x[(par4+1):n,], x2)
n <- n - par4
}
if(par5 > 0) {
x2 <- array(0, dim=c(n-par5*par6,par5), dimnames=list(1:(n-par5*par6), paste(colnames(x)[par1],'(t-',1:par5,'s)',sep='')))
for (i in 1:(n-par5*par6)) {
for (j in 1:par5) {
x2[i,j] <- x[i+par5*par6-j*par6,par1]
}
}
x <- cbind(x[(par5*par6+1):n,], x2)
n <- n - par5*par6
}
if (par2 == 'Include Seasonal Dummies'){
x2 <- array(0, dim=c(n,par6-1), dimnames=list(1:n, paste('M', seq(1:(par6-1)), sep ='')))
for (i in 1:(par6-1)){
x2[seq(i,n,par6),i] <- 1
}
x <- cbind(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[n,]))
if (par3 == 'Linear Trend'){
x <- cbind(x, c(1:n))
colnames(x)[k+1] <- 't'
}
print(x)
(k <- length(x[n,]))
head(x)
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')
sresid <- studres(mylm)
hist(sresid, freq=FALSE, main='Distribution of Studentized Residuals')
xfit<-seq(min(sresid),max(sresid),length=40)
yfit<-dnorm(xfit)
lines(xfit, yfit)
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')
qqPlot(mylm, main='QQ Plot')
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)
print(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, signif(mysum$coefficients[i,1],6), 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.row.start(a)
a<-table.element(a, mywarning)
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,'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,formatC(signif(mysum$coefficients[i,1],5),format='g',flag='+'))
a<-table.element(a,formatC(signif(mysum$coefficients[i,2],5),format='g',flag=' '))
a<-table.element(a,formatC(signif(mysum$coefficients[i,3],4),format='e',flag='+'))
a<-table.element(a,formatC(signif(mysum$coefficients[i,4],4),format='g',flag=' '))
a<-table.element(a,formatC(signif(mysum$coefficients[i,4]/2,4),format='g',flag=' '))
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,formatC(signif(sqrt(mysum$r.squared),6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'R-squared',1,TRUE)
a<-table.element(a,formatC(signif(mysum$r.squared,6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Adjusted R-squared',1,TRUE)
a<-table.element(a,formatC(signif(mysum$adj.r.squared,6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (value)',1,TRUE)
a<-table.element(a,formatC(signif(mysum$fstatistic[1],6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF numerator)',1,TRUE)
a<-table.element(a, signif(mysum$fstatistic[2],6))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF denominator)',1,TRUE)
a<-table.element(a, signif(mysum$fstatistic[3],6))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'p-value',1,TRUE)
a<-table.element(a,formatC(signif(1-pf(mysum$fstatistic[1],mysum$fstatistic[2],mysum$fstatistic[3]),6),format='g',flag=' '))
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,formatC(signif(mysum$sigma,6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Sum Squared Residuals',1,TRUE)
a<-table.element(a,formatC(signif(sum(myerror*myerror),6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
myr <- as.numeric(mysum$resid)
myr
a <-table.start()
a <- table.row.start(a)
a <- table.element(a,'Menu of Residual Diagnostics',2,TRUE)
a <- table.row.end(a)
a <- table.row.start(a)
a <- table.element(a,'Description',1,TRUE)
a <- table.element(a,'Link',1,TRUE)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Histogram',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_histogram.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Central Tendency',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_centraltendency.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'QQ Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_fitdistrnorm.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Kernel Density Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_density.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Skewness/Kurtosis Test',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_skewness_kurtosis.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Skewness-Kurtosis Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_skewness_kurtosis_plot.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Harrell-Davis Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_harrell_davis.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Bootstrap Plot -- Central Tendency',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_bootstrapplot1.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Blocked Bootstrap Plot -- Central Tendency',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_bootstrapplot.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'(Partial) Autocorrelation Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_autocorrelation.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Spectral Analysis',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_spectrum.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Tukey lambda PPCC Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_tukeylambda.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Box-Cox Normality Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_boxcoxnorm.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <- table.element(a,'Summary Statistics',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_summary1.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable7.tab')
if(n < 200) {
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,formatC(signif(x[i],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(x[i]-mysum$resid[i],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(mysum$resid[i],6),format='g',flag=' '))
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,formatC(signif(gqarr[mypoint-kp3+1,1],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(gqarr[mypoint-kp3+1,2],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(gqarr[mypoint-kp3+1,3],6),format='g',flag=' '))
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,signif(numsignificant1,6))
a<-table.element(a,formatC(signif(numsignificant1/numgqtests,6),format='g',flag=' '))
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,signif(numsignificant5,6))
a<-table.element(a,signif(numsignificant5/numgqtests,6))
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,signif(numsignificant10,6))
a<-table.element(a,signif(numsignificant10/numgqtests,6))
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')
}
}
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Ramsey RESET F-Test for powers (2 and 3) of fitted values',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
reset_test_fitted <- resettest(mylm,power=2:3,type='fitted')
a<-table.element(a,paste('',RC.texteval('reset_test_fitted'),'
',sep=''))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Ramsey RESET F-Test for powers (2 and 3) of regressors',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
reset_test_regressors <- resettest(mylm,power=2:3,type='regressor')
a<-table.element(a,paste('',RC.texteval('reset_test_regressors'),'
',sep=''))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Ramsey RESET F-Test for powers (2 and 3) of principal components',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
reset_test_principal_components <- resettest(mylm,power=2:3,type='princomp')
a<-table.element(a,paste('',RC.texteval('reset_test_principal_components'),'
',sep=''))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable8.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Variance Inflation Factors (Multicollinearity)',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
vif <- vif(mylm)
a<-table.element(a,paste('',RC.texteval('vif'),'
',sep=''))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable9.tab')

Free Statistics

Description of Statistical Computation

Tree of Dependent Computations

Dataset

Tables (Output of Computation)

Figures (Output of Computation)

Input Parameters & R Code