Home » date » 2009 » Nov » 19 »

ws 7

*The author of this computation has been verified*
R Software Module: /rwasp_multipleregression.wasp (opens new window with default values)
Title produced by software: Multiple Regression
Date of computation: Thu, 19 Nov 2009 11:07:30 -0700
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363.htm/, Retrieved Mon, 20 May 2013 03:21:22 +0000
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
 
System-generated keywords (parent):
t1258035301gehccu34anmb0m8 (pk = 56008)
Estimated Impact
53
 
Dataseries X:
» Textfile « » CSV « » Correlation Matrix « » Notched Boxplots «
 
Output produced by software:

Enter (or paste) a matrix (table) containing all data (time) series. Every column represents a different variable and must be delimited by a space or Tab. Every row represents a period in time (or category) and must be delimited by hard returns. The easiest way to enter data is to copy and paste a block of spreadsheet cells. Please, do not use commas or spaces to seperate groups of digits!


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


Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 4.14999041251723 -0.0152438597880977X[t] + 1.34171092585125Y1[t] -0.632193949965465Y2[t] + 0.0835740790049867M1[t] + 0.0525149196902091M2[t] -0.176803720858912M3[t] -0.0232878832478820M4[t] -0.105116917657922M5[t] -0.129479933541223M6[t] + 0.0778523659487016M7[t] + 0.310812223645426M8[t] -0.447340912981457M9[t] -0.0193029508698561M10[t] + 0.00728265666300871M11[t] -0.00840207262544193t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)4.149990412517230.9906314.18920.000157.5e-05
X-0.01524385978809770.004999-3.04910.0040580.002029
Y11.341710925851250.11603111.563400
Y2-0.6321939499654650.118245-5.34654e-062e-06
M10.08357407900498670.1269530.65830.5141130.257056
M20.05251491969020910.133460.39350.6960490.348025
M3-0.1768037208589120.134934-1.31030.1975690.098784
M4-0.02328788324788200.123139-0.18910.8509570.425478
M5-0.1051169176579220.11934-0.88080.383680.19184
M6-0.1294799335412230.117649-1.10060.2776660.138833
M70.07785236594870160.1183050.65810.5142660.257133
M80.3108122236454260.1610861.92950.0607860.030393
M9-0.4473409129814570.161306-2.77320.008390.004195
M10-0.01930295086985610.13103-0.14730.8836220.441811
M110.007282656663008710.1283880.05670.9550480.477524
t-0.008402072625441930.002576-3.26150.0022690.001135


Multiple Linear Regression - Regression Statistics
Multiple R0.974568997085734
R-squared0.949784730080693
Adjusted R-squared0.930954003860953
F-TEST (value)50.4380297922358
F-TEST (DF numerator)15
F-TEST (DF denominator)40
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.174779636784900
Sum Squared Residuals1.22191685738646


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
18.38.224060071071070.0759399289289281
28.58.6668790122537-0.166879012253704
38.68.6434274051257-0.0434274051257002
48.58.67737136635616-0.177371366356160
58.28.39889608761187-0.198896087611866
68.18.017690800471430.0823091995285654
77.98.14405969752041-0.244059697520411
88.68.547639959078050.0523600409219463
98.78.7232459236311-0.0232459236311051
108.78.578420296286520.121579703713478
118.58.5791160155617-0.0791160155616911
128.48.287467171208940.112532828791058
138.58.475333367322430.0246666326775733
148.78.646982096773170.0530179032268333
158.78.611335401814690.0886645981853136
168.68.434888971519530.165111028480468
178.58.323291334330850.176708665669152
188.38.135733319398990.164266680601011
1988.07923601878905-0.0792360187890467
208.28.42863282852502-0.228632828525016
218.17.953919917742310.146080082257685
228.17.875141711955930.224858288044067
2387.912337448474420.0876625515255819
247.97.863091101202290.0369088987977128
257.97.92981123512445-0.0298112351244543
2687.984057117756980.0159428822430233
2787.880507497167540.119492502832462
287.97.770329233826550.129670766173451
2987.66330475457430.336695245425706
307.77.7943936621134-0.0943936621134074
317.27.44984753130667-0.249847531306671
327.57.56668260325036-0.0666826032503617
337.37.35867711896112-0.0586771189611185
3477.12519123299974-0.125191232999737
3576.810897998928920.189102001071084
3677.07176145542226-0.071761455422262
377.27.29327451576754-0.0932745157675443
387.37.44441178407828-0.144411784078277
397.17.17174056608907-0.0717405660890719
406.86.95785380328929-0.157853803289287
416.46.571731190767-0.171731190766996
426.16.20718377669549-0.107183776695492
436.56.200076024574820.299923975425178
447.77.509207069996540.190792930003459
457.97.96415703966546-0.0641570396654613
467.57.72124675875781-0.221246758757809
476.97.09764853703497-0.197648537034974
486.66.67768027216651-0.0776802721665084
496.96.87752081071450.0224791892854972
507.77.457669989137870.242330010862125
5188.092989129803-0.0929891298030035
5287.959556625008470.0404433749915284
537.77.842776632716-0.142776632715995
547.37.34499844132068-0.0449984413206777
557.47.126780727809050.273219272190951
568.18.047837539150030.0521624608499723


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.05795178137616580.1159035627523320.942048218623834
200.6330953284919590.7338093430160820.366904671508041
210.4891421592256570.9782843184513130.510857840774343
220.3785958695346540.7571917390693070.621404130465346
230.261443653799090.522887307598180.73855634620091
240.1661707514661740.3323415029323480.833829248533826
250.1236683401753870.2473366803507740.876331659824613
260.07027431950391030.1405486390078210.92972568049609
270.043086557881920.086173115763840.95691344211808
280.03003588486034940.06007176972069870.96996411513965
290.3702315022330120.7404630044660240.629768497766988
300.4076825450585580.8153650901171160.592317454941442
310.5323416964417340.9353166071165320.467658303558266
320.4433870633822720.8867741267645440.556612936617728
330.3618297562975960.7236595125951920.638170243702404
340.2830282996283910.5660565992567830.716971700371609
350.5792985034909780.8414029930180440.420701496509022
360.4515881260531340.9031762521062680.548411873946866
370.3626165374487290.7252330748974570.637383462551271


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 level20.105263157894737NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/10ud4l1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/10ud4l1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/1ru1m1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/1ru1m1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/2il5v1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/2il5v1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/3acka1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/3acka1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/4z30b1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/4z30b1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/5ad9t1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/5ad9t1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/6uip91258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/6uip91258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/7qp1o1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/7qp1o1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/8uw9z1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/8uw9z1258654045.ps (opens in new window)
Click here to open pdf file.


http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/9lzwf1258654045.png (opens in new window)
http://www.freestatistics.org/blog/date/2009/Nov/19/t12586541506cjqdoxspnvq363/9lzwf1258654045.ps (opens in new window)
Click here to open pdf file.


 
Parameters (Session):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = Linear Trend ;
 
Parameters (R input):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = Linear Trend ;
 
R code (references can be found in the software module):