Multiple Linear Regression - Estimated Regression Equation
Apple[t] = -132.456012888064 -35.1959474240156Omzetgroei[t] + 75.106292792514Omzetgroei_iPhone[t] + 98.1776908801455Omzetgroei_iPad[t] -3.56318540919011e-07Volume[t] + 5.89684838683875Microsoft[t] -0.135120938035962Consumentenvertrouwen[t] + 1.48782043084434t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-132.45601288806410.302002-12.857300
Omzetgroei-35.19594742401566.039471-5.827700
Omzetgroei_iPhone75.10629279251411.2164986.696100
Omzetgroei_iPad98.177690880145511.6144098.453100
Volume-3.56318540919011e-070-2.52240.0130990.006549
Microsoft5.896848386838750.55317710.6600
Consumentenvertrouwen-0.1351209380359620.100211-1.34840.1803350.090168
t1.487820430844340.0799118.618700


Multiple Linear Regression - Regression Statistics
Multiple R0.984436739872282
R-squared0.969115694810368
Adjusted R-squared0.967132299064244
F-TEST (value)488.614386062204
F-TEST (DF numerator)7
F-TEST (DF denominator)109
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation13.7740515450263
Sum Squared Residuals20679.9700601897


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
110.81-1.8738478736159212.6838478736159
29.12-0.6963414173479639.81634141734796
311.03-11.824502078903222.8545020789032
412.7417.9034929800672-5.1634929800672
59.9824.8126323705191-14.8326323705191
611.6234.5795289163873-22.9595289163873
79.421.028405793062-11.628405793062
89.273.673776570128575.59622342987143
97.76-8.4434965492800216.20349654928
108.78-9.01119352841217.791193528412
1110.657.747499447531862.90250055246814
1210.9513.1056580441262-2.15565804412618
1312.3617.082120012113-4.72212001211301
1410.856.158776757425734.69122324257427
1511.8412.285916814422-0.445916814422048
1612.14-2.7290337444199314.8690337444199
1711.65-4.4592494607269616.109249460727
188.864.488029169149644.37197083085036
197.63-8.7765263944360716.4065263944361
207.38-2.518368809821489.89836880982148
217.25-13.968184838009221.2181848380092
228.039.46892508104644-1.43892508104644
237.7520.9943146338078-13.2443146338078
247.169.06385482292435-1.90385482292435
257.182.733274124204054.44672587579595
267.517.332813433043690.177186566956308
277.0711.9873686018732-4.91736860187317
287.1111.5321677602838-4.42216776028384
298.986.333894113425262.64610588657474
309.5315.6739777983254-6.14397779832542
3110.5418.5069985170053-7.96699851700535
3211.3120.3135238975293-9.00352389752929
3310.3627.8665127632704-17.5065127632705
3411.4414.8468899485709-3.40688994857093
3510.4513.4450060471332-2.99500604713323
3610.6923.0695494673374-12.3795494673374
3711.2825.7864293629237-14.5064293629237
3811.9624.5271266268066-12.5671266268066
3913.5215.369862599483-1.84986259948302
4012.8922.5933172097354-9.70331720973538
4114.0326.7658654525098-12.7358654525098
4216.2736.2851935486963-20.0151935486963
4316.1733.8681959221929-17.6981959221929
4417.2532.2249937945656-14.9749937945656
4519.3835.5785166937051-16.1985166937051
4626.220.77174133212515.42825866787494
4733.5330.49272641182253.03727358817749
4832.231.94900906658180.250990933418225
4938.4524.155900118431914.2940998815681
5044.8622.820302045077422.0396979549226
5141.6725.135374359959116.5346256400409
5236.0628.424376161477.63562383853002
5339.7636.33326198486313.42673801513693
5436.8133.51468158640953.29531841359055
5542.6545.9255925532733-3.27559255327335
5646.8958.4195012266221-11.5295012266221
5753.6151.11383994924622.49616005075381
5857.5945.779361517468611.8106384825314
5967.8259.93559561953527.88440438046478
6071.8952.645046167165919.2449538328341
6175.5168.98300734426156.52699265573855
6268.4965.68538443965752.80461556034251
6362.7268.4841289094483-5.76412890944833
6470.3956.059223643463214.3307763565368
6559.7754.7849361848074.985063815193
6657.2758.6423140454912-1.37231404549121
6767.9660.60483002150467.3551699784954
6867.8573.9215533774861-6.07155337748609
6976.9882.283267139184-5.30326713918406
7081.0896.9091518675447-15.8291518675447
7191.66102.14017856041-10.4801785604105
7284.84103.24342438359-18.4034243835898
7385.73104.62941104787-18.8994110478695
7484.6199.8807987398922-15.2707987398922
7592.91100.374211535294-7.46421153529386
7699.8111.97622807706-12.1762280770598
77121.19115.9868671579565.20313284204406
78122.04127.687049988085-5.64704998808459
79131.76128.5028767730833.25712322691724
80138.48131.6165222457556.86347775424504
81153.47137.53151929328615.9384807067142
82189.95185.19545881064.75454118940041
83182.22167.33436346503914.8856365349614
84198.08184.79712780406613.2828721959338
85135.36161.019072281618-25.6590722816176
86125.02140.204125236087-15.184125236087
87143.5151.258864524392-7.75886452439173
88173.95149.23411886197924.7158811380214
89188.75153.08645033623735.6635496637631
90167.44150.37143561132917.0685643886708
91158.95157.4666125637581.4833874362416
92169.53170.879558491093-1.3495584910935
93113.66161.336946005114-47.6769460051138
94107.59109.05551455419-1.46551455419034
9592.67106.45246830808-13.7824683080803
9685.35108.403079380345-23.0530793803452
9790.13101.440734342265-11.3107343422648
9889.3197.4450804694233-8.13508046942326
99105.12111.846032938571-6.72603293857052
100125.83129.924009834042-4.09400983404163
101135.81135.0417333010680.768266698932307
102142.43152.449590568733-10.0195905687326
103163.39144.69677092048418.6932290795164
104168.21153.91553141002714.294468589973
105185.35160.44094169609124.9090583039088
106188.5182.9892642196115.51073578038926
107199.91196.9171923808592.99280761914123
108210.73203.0467743866367.68322561336415
109192.06193.296248672735-1.23624867273481
110204.62203.1829523712731.43704762872715
111235208.06476231880526.935237681195
112261.09280.453843601117-19.3638436011166
113256.88250.2412092683616.63879073163879
114251.53238.56029014979212.9697098502083
115257.25264.520483116307-7.270483116307
116243.1256.769499297147-13.6694992971473
117283.75263.0349992271920.7150007728095


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
110.002091116035113160.004182232070226330.997908883964887
120.0002052926406110970.0004105852812221950.999794707359389
133.02374952689576e-056.04749905379151e-050.999969762504731
142.65306017886598e-065.30612035773195e-060.999997346939821
152.3152069786842e-074.63041395736839e-070.999999768479302
162.65278055673481e-085.30556111346962e-080.999999973472194
172.24333896712527e-094.48667793425054e-090.99999999775666
185.47241072341187e-091.09448214468237e-080.99999999452759
191.728813211714e-093.45762642342801e-090.999999998271187
202.51815580105652e-105.03631160211304e-100.999999999748184
214.53834352371379e-119.07668704742758e-110.999999999954617
225.31257183569923e-121.06251436713985e-110.999999999994687
235.63850237258657e-131.12770047451731e-120.999999999999436
245.5886391675264e-141.11772783350528e-130.999999999999944
256.91767410792069e-151.38353482158414e-140.999999999999993
262.87836360279027e-155.75672720558054e-150.999999999999997
274.44042493306443e-168.88084986612887e-161
288.36819064195867e-171.67363812839173e-161
291.06980664579051e-172.13961329158102e-171
301.56678830747061e-183.13357661494121e-181
314.33485563868307e-198.66971127736614e-191
321.28015662842586e-192.56031325685173e-191
331.4326657924169e-202.8653315848338e-201
341.68412646263596e-213.36825292527192e-211
352.2251029540008e-224.4502059080016e-221
362.54966286416401e-235.09932572832803e-231
372.72730125739697e-245.45460251479393e-241
383.46036371629405e-256.92072743258809e-251
391.13035323634225e-252.26070647268451e-251
401.15257098492381e-262.30514196984762e-261
413.57112633878659e-277.14225267757317e-271
429.52634497205153e-281.90526899441031e-271
431.09493672444003e-282.18987344888005e-281
447.73174922328567e-291.54634984465713e-281
457.56084926846733e-281.51216985369347e-271
463.07245039373297e-266.14490078746595e-261
471.49542544649407e-232.99085089298815e-231
484.6197762902312e-239.2395525804624e-231
499.84412755972917e-241.96882551194583e-231
503.06863371054934e-216.13726742109869e-211
518.4681150814369e-181.69362301628738e-171
522.47017604839935e-184.9403520967987e-181
532.39227307859078e-174.78454615718156e-171
543.19854275333454e-176.39708550666908e-171
552.57437644306072e-155.14875288612145e-150.999999999999997
563.55116421357981e-137.10232842715963e-130.999999999999645
571.38994548078205e-102.77989096156409e-100.999999999861005
581.78444915496861e-093.56889830993723e-090.99999999821555
591.14882186064481e-072.29764372128962e-070.999999885117814
601.25132287586865e-052.5026457517373e-050.999987486771241
611.7893358715915e-053.57867174318299e-050.999982106641284
621.44516297491027e-052.89032594982055e-050.999985548370251
638.31815018728423e-061.66363003745685e-050.999991681849813
641.39073266315129e-052.78146532630257e-050.999986092673368
651.08144442923534e-052.16288885847068e-050.999989185555708
666.62336561012487e-061.32467312202497e-050.99999337663439
671.65957092046844e-053.31914184093688e-050.999983404290795
681.35900279246481e-052.71800558492963e-050.999986409972075
691.51875253832336e-053.03750507664671e-050.999984812474617
701.17096876209271e-052.34193752418541e-050.99998829031238
711.27538319660135e-052.55076639320271e-050.999987246168034
728.16930707626375e-061.63386141525275e-050.999991830692924
738.88677228794262e-061.77735445758852e-050.999991113227712
746.41404627127584e-061.28280925425517e-050.999993585953729
755.70305796957726e-061.14061159391545e-050.99999429694203
767.93710856729225e-061.58742171345845e-050.999992062891433
773.73708379731194e-057.47416759462387e-050.999962629162027
783.04993427967307e-056.09986855934615e-050.999969500657203
791.63366997018461e-053.26733994036922e-050.999983663300298
801.0081146194301e-052.0162292388602e-050.999989918853806
811.43336764199264e-052.86673528398528e-050.99998566632358
821.87256085065181e-053.74512170130363e-050.999981274391494
831.42259309288872e-052.84518618577743e-050.999985774069071
841.76769322474065e-053.5353864494813e-050.999982323067753
850.001175805866026770.002351611732053530.998824194133973
860.002220106067938270.004440212135876530.997779893932062
870.001847793769058360.003695587538116720.998152206230942
880.004917462283195450.00983492456639090.995082537716805
890.04622766326928420.09245532653856850.953772336730716
900.08923095306826570.1784619061365310.910769046931734
910.1892824948858060.3785649897716120.810717505114194
920.8491805612020150.301638877595970.150819438797985
930.954817921927120.09036415614576040.0451820780728802
940.9520991440200240.09580171195995140.0479008559799757
950.9318971413293540.1362057173412920.068102858670646
960.9211924336757050.1576151326485890.0788075663242945
970.8873713958917330.2252572082165340.112628604108267
980.838708121987090.3225837560258210.16129187801291
990.7947624668210010.4104750663579980.205237533178999
1000.7268345851305090.5463308297389820.273165414869491
1010.7431488440917280.5137023118165440.256851155908272
1020.6997841873706170.6004316252587650.300215812629383
1030.6452739294061050.709452141187790.354726070593895
1040.5334797140514050.933040571897190.466520285948595
1050.4494797293622790.8989594587245590.550520270637721
1060.3518920836735610.7037841673471210.64810791632644


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level780.8125NOK
5% type I error level780.8125NOK
10% type I error level810.84375NOK