Multiple Linear Regression - Estimated Regression Equation |
TimeSpent[t] = + 23882.9460387288 + 1426.12003716736BlogComput[t] + 0.724337979198851CharaComp[t] + 398.661037465215Blogscomp[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) | 23882.9460387288 | 7395.808284 | 3.2293 | 0.001547 | 0.000773 |
BlogComput | 1426.12003716736 | 249.463392 | 5.7168 | 0 | 0 |
CharaComp | 0.724337979198851 | 0.220311 | 3.2878 | 0.001277 | 0.000638 |
Blogscomp | 398.661037465215 | 233.616285 | 1.7065 | 0.090136 | 0.045068 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.81851703354865 |
R-squared | 0.669970134209282 |
Adjusted R-squared | 0.662898065656623 |
F-TEST (value) | 94.7346775870057 |
F-TEST (DF numerator) | 3 |
F-TEST (DF denominator) | 140 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 43011.9072304537 |
Sum Squared Residuals | 259003382904.162 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 158258 | 121910.742953279 | 36347.2570467208 |
2 | 186739 | 140968.494522081 | 45770.505477919 |
3 | 7215 | 24913.6789831287 | -17698.6789831287 |
4 | 122689 | 133854.581951938 | -11165.5819519381 |
5 | 226968 | 205668.617638153 | 21299.3823618474 |
6 | 494047 | 383706.70949213 | 110340.29050787 |
7 | 171007 | 148878.830118734 | 22128.1698812661 |
8 | 174432 | 178368.133561482 | -3936.13356148205 |
9 | 149604 | 141021.26941555 | 8582.73058444951 |
10 | 275702 | 191998.796625394 | 83703.2033746057 |
11 | 121844 | 150817.100236371 | -28973.1002363708 |
12 | 176637 | 197253.085961063 | -20616.0859610634 |
13 | 92070 | 112355.262100835 | -20285.2621008351 |
14 | 208880 | 207272.19980995 | 1607.80019004999 |
15 | 157095 | 129787.411927965 | 27307.5880720355 |
16 | 147893 | 154898.355550466 | -7005.3555504664 |
17 | 134175 | 229090.519142947 | -94915.5191429468 |
18 | 68818 | 35882.7778560734 | 32935.2221439266 |
19 | 149555 | 180556.53364222 | -31001.5336422198 |
20 | 27997 | 90959.3055128944 | -62962.3055128944 |
21 | 69866 | 65127.0525092388 | 4738.94749076119 |
22 | 227357 | 253692.78817688 | -26335.78817688 |
23 | 188137 | 119865.778084837 | 68271.221915163 |
24 | 127994 | 129972.972742097 | -1978.97274209747 |
25 | 143682 | 139353.351119926 | 4328.6488800744 |
26 | 164820 | 135422.309251567 | 29397.6907484332 |
27 | 187214 | 179524.683240989 | 7689.31675901103 |
28 | 176178 | 199993.097062195 | -23815.0970621949 |
29 | 351374 | 201607.619631807 | 149766.380368193 |
30 | 192399 | 154578.817086863 | 37820.1829131374 |
31 | 165257 | 134683.240841816 | 30573.7591581844 |
32 | 173687 | 148304.777846427 | 25382.2221535726 |
33 | 126338 | 177029.717171114 | -50691.7171711142 |
34 | 224762 | 187502.12498742 | 37259.8750125805 |
35 | 219428 | 174455.461395793 | 44972.538604207 |
36 | 0 | 23882.9460387287 | -23882.9460387287 |
37 | 208669 | 136323.25870686 | 72345.7412931396 |
38 | 99706 | 121074.291391209 | -21368.2913912086 |
39 | 136733 | 131008.398840037 | 5724.60115996271 |
40 | 249965 | 250782.456541898 | -817.456541898439 |
41 | 232951 | 257390.589529432 | -24439.5895294315 |
42 | 143748 | 126128.707579205 | 17619.2924207947 |
43 | 94332 | 148833.760166382 | -54501.7601663822 |
44 | 189893 | 190724.642706411 | -831.642706410918 |
45 | 114811 | 188133.509419431 | -73322.5094194314 |
46 | 156861 | 133764.604283943 | 23096.3957160569 |
47 | 81293 | 95530.0488504382 | -14237.0488504382 |
48 | 204965 | 167710.06645266 | 37254.9335473401 |
49 | 223771 | 167484.334591477 | 56286.6654085235 |
50 | 160254 | 172884.606014325 | -12630.6060143248 |
51 | 48188 | 62763.6974924275 | -14575.6974924275 |
52 | 143776 | 183581.325579041 | -39805.3255790414 |
53 | 286674 | 212818.309234284 | 73855.6907657162 |
54 | 234829 | 151551.172501504 | 83277.827498496 |
55 | 195583 | 158784.4410289 | 36798.5589710999 |
56 | 145942 | 113214.978685852 | 32727.0213141482 |
57 | 203260 | 147935.205383325 | 55324.7946166753 |
58 | 93764 | 92938.5289951233 | 825.471004876668 |
59 | 151913 | 159237.298128758 | -7324.29812875773 |
60 | 190487 | 135592.385830052 | 54894.6141699482 |
61 | 143389 | 140421.777816553 | 2967.22218344692 |
62 | 124825 | 130042.436256671 | -5217.4362566714 |
63 | 124234 | 154602.997399903 | -30368.9973999031 |
64 | 111501 | 132920.173017726 | -21419.1730177259 |
65 | 153813 | 83638.9439620308 | 70174.0560379692 |
66 | 97548 | 121640.88316512 | -24092.8831651199 |
67 | 178613 | 198698.214836678 | -20085.2148366784 |
68 | 138708 | 210681.108664624 | -71973.108664624 |
69 | 111869 | 171514.347884852 | -59645.3478848517 |
70 | 31970 | 36416.5854288864 | -4446.58542888643 |
71 | 224494 | 152942.116244951 | 71551.8837550486 |
72 | 116999 | 133770.979138582 | -16771.9791385817 |
73 | 113504 | 206333.398803935 | -92829.3988039354 |
74 | 105932 | 121742.174086466 | -15810.1740864658 |
75 | 159167 | 215045.959118065 | -55878.9591180654 |
76 | 90204 | 51155.6754969374 | 39048.3245030626 |
77 | 165210 | 185958.558742926 | -20748.5587429257 |
78 | 156752 | 217366.762209826 | -60614.7622098258 |
79 | 69233 | 70624.0822809618 | -1391.08228096175 |
80 | 84971 | 124899.939646178 | -39928.9396461779 |
81 | 80506 | 150454.974660344 | -69948.974660344 |
82 | 267162 | 134149.793955246 | 133012.206044754 |
83 | 62974 | 86939.5900287076 | -23965.5900287076 |
84 | 119802 | 123050.633478798 | -3248.63347879811 |
85 | 75132 | 100618.423000242 | -25486.4230002422 |
86 | 154426 | 128308.07979463 | 26117.9202053703 |
87 | 222914 | 193325.592231638 | 29588.407768362 |
88 | 115019 | 138720.714633586 | -23701.7146335861 |
89 | 99114 | 134720.369730242 | -35606.3697302416 |
90 | 149326 | 132514.049521785 | 16811.9504782155 |
91 | 144425 | 163589.408848476 | -19164.4088484762 |
92 | 159599 | 219081.342802882 | -59482.3428028818 |
93 | 151465 | 120600.778245973 | 30864.2217540265 |
94 | 133686 | 121097.745741326 | 12588.2542586741 |
95 | 58059 | 102095.015346497 | -44036.0153464972 |
96 | 234131 | 158586.304982275 | 75544.6950177254 |
97 | 193233 | 243819.267216483 | -50586.2672164827 |
98 | 19349 | 50825.0574753969 | -31476.0574753969 |
99 | 205449 | 120023.219674102 | 85425.7803258976 |
100 | 151538 | 119959.01412613 | 31578.9858738704 |
101 | 59117 | 62983.2010321043 | -3866.20103210432 |
102 | 58280 | 121694.52792429 | -63414.5279242901 |
103 | 126653 | 138400.153146964 | -11747.1531469636 |
104 | 112265 | 86527.6316652481 | 25737.3683347519 |
105 | 83829 | 90623.5023547015 | -6794.50235470153 |
106 | 27676 | 31365.4296250083 | -3689.42962500835 |
107 | 134211 | 183724.729262659 | -49513.7292626593 |
108 | 117451 | 61374.5047457431 | 56076.4952542569 |
109 | 0 | 23882.9460387287 | -23882.9460387287 |
110 | 85610 | 180132.188368028 | -94522.1883680282 |
111 | 107205 | 100173.868473048 | 7031.13152695167 |
112 | 144664 | 139025.775978023 | 5638.22402197663 |
113 | 136540 | 157211.872803533 | -20671.8728035325 |
114 | 71894 | 121374.557853834 | -49480.5578538342 |
115 | 3616 | 23882.9460387287 | -20266.9460387287 |
116 | 0 | 23882.9460387287 | -23882.9460387287 |
117 | 167611 | 114296.400052532 | 53314.5999474678 |
118 | 138047 | 205164.941875297 | -67117.9418752967 |
119 | 152826 | 102831.839770963 | 49994.1602290374 |
120 | 113245 | 114751.126840112 | -1506.12684011241 |
121 | 43410 | 36278.8312565174 | 7131.16874348256 |
122 | 175762 | 179076.347498981 | -3314.34749898125 |
123 | 90591 | 94668.7406920962 | -4077.74069209616 |
124 | 114942 | 142921.774809612 | -27979.7748096116 |
125 | 60493 | 53433.8345021229 | 7059.16549787711 |
126 | 19764 | 46297.1488414062 | -26533.1488414062 |
127 | 164062 | 127602.647818716 | 36459.3521812841 |
128 | 125970 | 106229.274608301 | 19740.7253916992 |
129 | 151495 | 147978.245655723 | 3516.754344277 |
130 | 11796 | 25309.0660758961 | -13513.0660758961 |
131 | 10674 | 23882.9460387287 | -13208.9460387287 |
132 | 138547 | 161868.268481129 | -23321.2684811295 |
133 | 6836 | 23882.9460387287 | -17046.9460387287 |
134 | 153278 | 156916.981424264 | -3638.98142426387 |
135 | 5118 | 31013.5462245655 | -25895.5462245655 |
136 | 40248 | 41627.1685196174 | -1379.16851961741 |
137 | 0 | 23882.9460387287 | -23882.9460387287 |
138 | 117954 | 103189.592431612 | 14764.4075683878 |
139 | 88837 | 112185.52176853 | -23348.5217685303 |
140 | 7131 | 23882.9460387287 | -16751.9460387287 |
141 | 8812 | 29447.8888700552 | -20635.8888700552 |
142 | 68916 | 57461.7894508781 | 11454.2105491219 |
143 | 132697 | 160980.079228721 | -28283.0792287208 |
144 | 100681 | 73915.1259781063 | 26765.8740218937 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
7 | 0.112294662659157 | 0.224589325318313 | 0.887705337340843 |
8 | 0.0820323150030702 | 0.16406463000614 | 0.91796768499693 |
9 | 0.0340795624015882 | 0.0681591248031763 | 0.965920437598412 |
10 | 0.0889817703115942 | 0.177963540623188 | 0.911018229688406 |
11 | 0.303687080476959 | 0.607374160953917 | 0.696312919523042 |
12 | 0.359645744594124 | 0.719291489188248 | 0.640354255405876 |
13 | 0.286154976864191 | 0.572309953728382 | 0.713845023135809 |
14 | 0.211272711209299 | 0.422545422418598 | 0.788727288790701 |
15 | 0.153086381899888 | 0.306172763799776 | 0.846913618100112 |
16 | 0.160782705781281 | 0.321565411562562 | 0.839217294218719 |
17 | 0.730476469945784 | 0.539047060108431 | 0.269523530054216 |
18 | 0.740007669916859 | 0.519984660166282 | 0.259992330083141 |
19 | 0.727636928137046 | 0.544726143725908 | 0.272363071862954 |
20 | 0.775983952978273 | 0.448032094043453 | 0.224016047021726 |
21 | 0.724533808085999 | 0.550932383828001 | 0.275466191914001 |
22 | 0.718119144488479 | 0.563761711023042 | 0.281880855511521 |
23 | 0.795017323460481 | 0.409965353079038 | 0.204982676539519 |
24 | 0.74345492684498 | 0.513090146310039 | 0.25654507315502 |
25 | 0.686500154832886 | 0.626999690334227 | 0.313499845167114 |
26 | 0.64334658650628 | 0.71330682698744 | 0.35665341349372 |
27 | 0.581670060123364 | 0.836659879753271 | 0.418329939876636 |
28 | 0.555048354287933 | 0.889903291424135 | 0.444951645712067 |
29 | 0.903669933409145 | 0.19266013318171 | 0.0963300665908552 |
30 | 0.895391062451994 | 0.209217875096013 | 0.104608937548006 |
31 | 0.875551383531105 | 0.248897232937791 | 0.124448616468895 |
32 | 0.851071496586905 | 0.29785700682619 | 0.148928503413095 |
33 | 0.899053938040107 | 0.201892123919786 | 0.100946061959893 |
34 | 0.881937320398028 | 0.236125359203944 | 0.118062679601972 |
35 | 0.879840921231633 | 0.240318157536733 | 0.120159078768367 |
36 | 0.855987182062942 | 0.288025635874116 | 0.144012817937058 |
37 | 0.890152995004146 | 0.219694009991709 | 0.109847004995854 |
38 | 0.868964502079659 | 0.262070995840683 | 0.131035497920341 |
39 | 0.839218549095363 | 0.321562901809273 | 0.160781450904637 |
40 | 0.817461790693036 | 0.365076418613928 | 0.182538209306964 |
41 | 0.792025534068389 | 0.415948931863222 | 0.207974465931611 |
42 | 0.756455867589211 | 0.487088264821578 | 0.243544132410789 |
43 | 0.785252583152327 | 0.429494833695346 | 0.214747416847673 |
44 | 0.746698161471058 | 0.506603677057883 | 0.253301838528941 |
45 | 0.785451436917132 | 0.429097126165736 | 0.214548563082868 |
46 | 0.767003475442744 | 0.465993049114512 | 0.232996524557256 |
47 | 0.731403291018779 | 0.537193417962442 | 0.268596708981221 |
48 | 0.713833417625933 | 0.572333164748133 | 0.286166582374067 |
49 | 0.730210556183658 | 0.539578887632683 | 0.269789443816342 |
50 | 0.702089651120501 | 0.595820697758999 | 0.297910348879499 |
51 | 0.660514001078014 | 0.678971997843972 | 0.339485998921986 |
52 | 0.692313260713531 | 0.615373478572938 | 0.307686739286469 |
53 | 0.79274760117274 | 0.414504797654519 | 0.20725239882726 |
54 | 0.882574764933377 | 0.234850470133246 | 0.117425235066623 |
55 | 0.879331573941273 | 0.241336852117454 | 0.120668426058727 |
56 | 0.871198842320463 | 0.257602315359074 | 0.128801157679537 |
57 | 0.89234000658995 | 0.215319986820099 | 0.10765999341005 |
58 | 0.867696069146911 | 0.264607861706179 | 0.132303930853089 |
59 | 0.849362063138227 | 0.301275873723546 | 0.150637936861773 |
60 | 0.868710507592923 | 0.262578984814154 | 0.131289492407077 |
61 | 0.842521706702635 | 0.314956586594729 | 0.157478293297365 |
62 | 0.814150687560551 | 0.371698624878897 | 0.185849312439449 |
63 | 0.805101776574061 | 0.389796446851879 | 0.194898223425939 |
64 | 0.78004645492354 | 0.439907090152921 | 0.21995354507646 |
65 | 0.8429729856978 | 0.3140540286044 | 0.1570270143022 |
66 | 0.821884042557261 | 0.356231914885477 | 0.178115957442739 |
67 | 0.811295618164007 | 0.377408763671985 | 0.188704381835993 |
68 | 0.850819812390014 | 0.298360375219973 | 0.149180187609986 |
69 | 0.879661978434165 | 0.24067604313167 | 0.120338021565835 |
70 | 0.854126398085435 | 0.29174720382913 | 0.145873601914565 |
71 | 0.908801355139867 | 0.182397289720266 | 0.0911986448601332 |
72 | 0.890758101992084 | 0.218483796015831 | 0.109241898007916 |
73 | 0.94823910702462 | 0.103521785950759 | 0.0517608929753797 |
74 | 0.935197037775918 | 0.129605924448163 | 0.0648029622240816 |
75 | 0.944235918397804 | 0.111528163204392 | 0.0557640816021961 |
76 | 0.94269878740624 | 0.114602425187519 | 0.0573012125937597 |
77 | 0.929674751427744 | 0.140650497144512 | 0.0703252485722561 |
78 | 0.941423962979498 | 0.117152074041003 | 0.0585760370205017 |
79 | 0.925733856781525 | 0.14853228643695 | 0.074266143218475 |
80 | 0.924309514220069 | 0.151380971559862 | 0.0756904857799311 |
81 | 0.945579496540444 | 0.108841006919112 | 0.0544205034595559 |
82 | 0.997850020650707 | 0.00429995869858515 | 0.00214997934929257 |
83 | 0.997294969575989 | 0.0054100608480228 | 0.0027050304240114 |
84 | 0.996052830273782 | 0.00789433945243563 | 0.00394716972621782 |
85 | 0.994972415928873 | 0.0100551681422536 | 0.00502758407112679 |
86 | 0.993765886902963 | 0.012468226194075 | 0.0062341130970375 |
87 | 0.992502291370349 | 0.0149954172593024 | 0.00749770862965121 |
88 | 0.99004670651205 | 0.0199065869758996 | 0.0099532934879498 |
89 | 0.988406372263516 | 0.023187255472969 | 0.0115936277364845 |
90 | 0.985164688460436 | 0.0296706230791276 | 0.0148353115395638 |
91 | 0.980263079975949 | 0.0394738400481019 | 0.0197369200240509 |
92 | 0.983542958231636 | 0.0329140835367271 | 0.0164570417683635 |
93 | 0.982653949331003 | 0.0346921013379936 | 0.0173460506689968 |
94 | 0.977643832170697 | 0.0447123356586071 | 0.0223561678293035 |
95 | 0.977502906088807 | 0.044994187822386 | 0.022497093911193 |
96 | 0.993409327544267 | 0.0131813449114655 | 0.00659067245573273 |
97 | 0.992858411602099 | 0.0142831767958012 | 0.00714158839790061 |
98 | 0.991889786806678 | 0.0162204263866447 | 0.00811021319332233 |
99 | 0.999169041821403 | 0.00166191635719478 | 0.000830958178597389 |
100 | 0.999200395670364 | 0.00159920865927178 | 0.000799604329635888 |
101 | 0.998707974560861 | 0.00258405087827852 | 0.00129202543913926 |
102 | 0.999321863316649 | 0.0013562733667025 | 0.000678136683351249 |
103 | 0.998892718691163 | 0.00221456261767355 | 0.00110728130883677 |
104 | 0.998695330697481 | 0.00260933860503794 | 0.00130466930251897 |
105 | 0.997892053004158 | 0.0042158939916839 | 0.00210794699584195 |
106 | 0.996644537447623 | 0.00671092510475298 | 0.00335546255237649 |
107 | 0.997905767794285 | 0.00418846441143079 | 0.00209423220571539 |
108 | 0.999044480367537 | 0.00191103926492654 | 0.000955519632463272 |
109 | 0.998650511382818 | 0.00269897723436441 | 0.00134948861718221 |
110 | 0.999740112446546 | 0.000519775106907027 | 0.000259887553453514 |
111 | 0.999582812609152 | 0.000834374781695776 | 0.000417187390847888 |
112 | 0.999267701064493 | 0.00146459787101328 | 0.000732298935506641 |
113 | 0.998902048878656 | 0.00219590224268857 | 0.00109795112134428 |
114 | 0.999225772527529 | 0.0015484549449419 | 0.000774227472470949 |
115 | 0.998767151335628 | 0.00246569732874494 | 0.00123284866437247 |
116 | 0.998214270255862 | 0.00357145948827633 | 0.00178572974413816 |
117 | 0.999415390743485 | 0.00116921851303015 | 0.000584609256515075 |
118 | 0.999936738851418 | 0.000126522297164029 | 6.32611485820147e-05 |
119 | 0.999992006962516 | 1.59860749683785e-05 | 7.99303748418924e-06 |
120 | 0.999979747520208 | 4.05049595839711e-05 | 2.02524797919856e-05 |
121 | 0.999959300816716 | 8.13983665671244e-05 | 4.06991832835622e-05 |
122 | 0.999913736054799 | 0.000172527890402626 | 8.62639452013131e-05 |
123 | 0.999794116474774 | 0.000411767050452304 | 0.000205883525226152 |
124 | 0.99997739596358 | 4.52080728400366e-05 | 2.26040364200183e-05 |
125 | 0.99998392736105 | 3.21452778991779e-05 | 1.6072638949589e-05 |
126 | 0.999978509024317 | 4.29819513661467e-05 | 2.14909756830734e-05 |
127 | 0.99996426695677 | 7.14660864596029e-05 | 3.57330432298014e-05 |
128 | 0.999953787175392 | 9.24256492169499e-05 | 4.6212824608475e-05 |
129 | 0.999864545076559 | 0.000270909846882313 | 0.000135454923441156 |
130 | 0.999579005376437 | 0.000841989247126919 | 0.000420994623563459 |
131 | 0.998737339928863 | 0.00252532014227409 | 0.00126266007113704 |
132 | 0.996936784712831 | 0.00612643057433734 | 0.00306321528716867 |
133 | 0.99177476615788 | 0.0164504676842409 | 0.00822523384212043 |
134 | 0.980344686165509 | 0.039310627668983 | 0.0196553138344915 |
135 | 0.973697441540486 | 0.0526051169190276 | 0.0263025584595138 |
136 | 0.931135318718811 | 0.137729362562379 | 0.0688646812811894 |
137 | 0.873469845030652 | 0.253060309938697 | 0.126530154969348 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 37 | 0.282442748091603 | NOK |
5% type I error level | 53 | 0.404580152671756 | NOK |
10% type I error level | 55 | 0.419847328244275 | NOK |