Multiple Linear Regression - Estimated Regression Equation |
Prijs[t] = -322.58694197154 + 0.00514787064784414Geheugen[t] + 4.68681735490495Gewicht[t] -2.82360601880905Batterij[t] + 69.4417009327331WiFi[t] + e[t] |
Multiple Linear Regression - Ordinary Least Squares | |||||
Variable | Parameter | S.D. | T-STAT H0: parameter = 0 | 2-tail p-value | 1-tail p-value |
(Intercept) | -322.58694197154 | 77.149675 | -4.1813 | 0.000105 | 5.2e-05 |
Geheugen | 0.00514787064784414 | 0.001781 | 2.8908 | 0.005492 | 0.002746 |
Gewicht | 4.68681735490495 | 0.750894 | 6.2417 | 0 | 0 |
Batterij | -2.82360601880905 | 3.698535 | -0.7634 | 0.448464 | 0.224232 |
WiFi | 69.4417009327331 | 32.486244 | 2.1376 | 0.037012 | 0.018506 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.884102158206179 |
R-squared | 0.781636626144823 |
Adjusted R-squared | 0.76575565350081 |
F-TEST (value) | 49.2184353985082 |
F-TEST (DF numerator) | 4 |
F-TEST (DF denominator) | 55 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 85.5495001122596 |
Sum Squared Residuals | 402529.433320163 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 129.99 | 150.863148197177 | -20.873148197177 |
2 | 59.99 | 59.3736761942728 | 0.616323805727191 |
3 | 49.99 | 60.7913264783404 | -10.8013264783404 |
4 | 84.99 | 97.0027590743716 | -12.0127590743716 |
5 | 179.99 | 216.587667125989 | -36.597667125989 |
6 | 329.99 | 265.266922529608 | 64.7230774703919 |
7 | 25.99 | -14.7015896855128 | 40.6915896855128 |
8 | 499.99 | 427.250517717785 | 72.7394822822147 |
9 | 89.99 | 133.841463037943 | -43.8514630379427 |
10 | 119.99 | 111.377115235223 | 8.61288476477732 |
11 | 79.99 | 88.5758025708049 | -8.58580257080489 |
12 | 199.99 | 232.269026382326 | -32.2790263823255 |
13 | 449.99 | 303.022695032591 | 146.967304967409 |
14 | 549.99 | 506.494002588817 | 43.4959974111827 |
15 | 529.99 | 386.874794830406 | 143.115205169594 |
16 | 639.99 | 465.609876881729 | 174.380123118271 |
17 | 749.99 | 547.975807247236 | 202.014192752764 |
18 | 399.99 | 363.302688944727 | 36.6873110552728 |
19 | 169.99 | 239.270463400018 | -69.2804634000178 |
20 | 189.99 | 406.64003696207 | -216.65003696207 |
21 | 199.99 | 406.64003696207 | -206.65003696207 |
22 | 69.99 | 86.623350298222 | -16.633350298222 |
23 | 69.99 | 86.623350298222 | -16.633350298222 |
24 | 109.99 | 116.630082995902 | -6.6400829959019 |
25 | 159.99 | 221.530562724889 | -61.5405627248893 |
26 | 159.99 | 221.530562724889 | -61.5405627248893 |
27 | 199.99 | 356.486912333115 | -156.496912333115 |
28 | 75 | 45.9052758199604 | 29.0947241800396 |
29 | 349.99 | 323.087819338059 | 26.9021806619409 |
30 | 439.99 | 435.721335774212 | 4.26866422578751 |
31 | 309.99 | 292.14330918982 | 17.8466908101797 |
32 | 379.99 | 286.496097152202 | 93.4939028477978 |
33 | 349.99 | 245.275135640771 | 104.714864359229 |
34 | 169.99 | 165.14194511238 | 4.84805488762026 |
35 | 239.99 | 287.672384563701 | -47.6823845637012 |
36 | 229.99 | 282.76967448001 | -52.7796744800104 |
37 | 69.99 | 59.1803608039888 | 10.8096391960112 |
38 | 99.99 | 98.3116046708192 | 1.6783953291808 |
39 | 29.99 | -18.9896972847753 | 48.9796972847753 |
40 | 39.99 | 31.7521620835843 | 8.23783791641567 |
41 | 21.99 | -46.1386911256257 | 68.1286911256257 |
42 | 499.99 | 347.979069281281 | 152.010930718719 |
43 | 29.99 | -7.21080634218609 | 37.2008063421861 |
44 | 29.99 | 21.2916885908372 | 8.69831140916281 |
45 | 49.99 | 101.112461274997 | -51.1224612749971 |
46 | 49.99 | 41.1155010520985 | 8.87449894790146 |
47 | 55.99 | 17.4202417058347 | 38.5697582941653 |
48 | 59.99 | 86.5609659181627 | -26.5709659181627 |
49 | 79.99 | 68.2714128376347 | 11.7185871623653 |
50 | 139.99 | 158.270371867143 | -18.2803718671431 |
51 | 159.99 | 147.709278109704 | 12.2807218902965 |
52 | 169.99 | 209.221424628898 | -39.2314246288981 |
53 | 229.99 | 467.395252378878 | -237.405252378878 |
54 | 249.99 | 265.939941956912 | -15.9499419569124 |
55 | 309.99 | 313.354881243524 | -3.36488124352394 |
56 | 499.99 | 432.350747070703 | 67.6392529292966 |
57 | 65.99 | 92.5974703147791 | -26.6074703147791 |
58 | 89.99 | 182.649409712438 | -92.6594097124375 |
59 | 89.99 | 113.857593947145 | -23.8675939471452 |
60 | 449.99 | 527.441319148877 | -77.4513191488766 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
8 | 0.076096768984234 | 0.152193537968468 | 0.923903231015766 |
9 | 0.0411647771485234 | 0.0823295542970468 | 0.958835222851477 |
10 | 0.0135869262022536 | 0.0271738524045071 | 0.986413073797746 |
11 | 0.00418341478349426 | 0.00836682956698852 | 0.995816585216506 |
12 | 0.0021985941296148 | 0.00439718825922961 | 0.997801405870385 |
13 | 0.0771550386921002 | 0.1543100773842 | 0.9228449613079 |
14 | 0.0499627002781311 | 0.0999254005562622 | 0.950037299721869 |
15 | 0.052772689980473 | 0.105545379960946 | 0.947227310019527 |
16 | 0.0468200269566683 | 0.0936400539133365 | 0.953179973043332 |
17 | 0.12702724979097 | 0.254054499581941 | 0.87297275020903 |
18 | 0.0894901148682653 | 0.178980229736531 | 0.910509885131735 |
19 | 0.118934292918815 | 0.23786858583763 | 0.881065707081185 |
20 | 0.880529439711154 | 0.238941120577692 | 0.119470560288846 |
21 | 0.989212066864859 | 0.0215758662702819 | 0.010787933135141 |
22 | 0.982377227996444 | 0.0352455440071114 | 0.0176227720035557 |
23 | 0.97215903988447 | 0.05568192023106 | 0.02784096011553 |
24 | 0.964285080156548 | 0.0714298396869034 | 0.0357149198434517 |
25 | 0.960711946938905 | 0.0785761061221901 | 0.0392880530610951 |
26 | 0.963198142123089 | 0.0736037157538228 | 0.0368018578769114 |
27 | 0.991306719806891 | 0.0173865603862181 | 0.00869328019310903 |
28 | 0.986328387800112 | 0.0273432243997766 | 0.0136716121998883 |
29 | 0.979936332704822 | 0.0401273345903558 | 0.0200636672951779 |
30 | 0.968524573700929 | 0.0629508525981412 | 0.0314754262990706 |
31 | 0.95364552526493 | 0.0927089494701404 | 0.0463544747350702 |
32 | 0.958526075112049 | 0.0829478497759021 | 0.041473924887951 |
33 | 0.967009096821178 | 0.0659818063576441 | 0.032990903178822 |
34 | 0.94991957828353 | 0.10016084343294 | 0.05008042171647 |
35 | 0.939001927823446 | 0.121996144353108 | 0.0609980721765539 |
36 | 0.939770227755124 | 0.120459544489752 | 0.0602297722448761 |
37 | 0.909390554721204 | 0.181218890557592 | 0.090609445278796 |
38 | 0.868033320894114 | 0.263933358211771 | 0.131966679105886 |
39 | 0.831218610426557 | 0.337562779146886 | 0.168781389573443 |
40 | 0.771196109137364 | 0.457607781725272 | 0.228803890862636 |
41 | 0.739308809861699 | 0.521382380276603 | 0.260691190138301 |
42 | 0.892311078052515 | 0.21537784389497 | 0.107688921947485 |
43 | 0.844581977759874 | 0.310836044480251 | 0.155418022240126 |
44 | 0.776293759651593 | 0.447412480696814 | 0.223706240348407 |
45 | 0.72035391054008 | 0.55929217891984 | 0.27964608945992 |
46 | 0.622996942526228 | 0.754006114947544 | 0.377003057473772 |
47 | 0.542907433492681 | 0.914185133014638 | 0.457092566507319 |
48 | 0.436458021574662 | 0.872916043149324 | 0.563541978425338 |
49 | 0.325824384308236 | 0.651648768616473 | 0.674175615691764 |
50 | 0.220198386581202 | 0.440396773162405 | 0.779801613418798 |
51 | 0.434836383424763 | 0.869672766849526 | 0.565163616575237 |
52 | 0.605708086930665 | 0.78858382613867 | 0.394291913069335 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 2 | 0.0444444444444444 | NOK |
5% type I error level | 8 | 0.177777777777778 | NOK |
10% type I error level | 19 | 0.422222222222222 | NOK |