ECON306 --- Linear regressions
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
WWWWWWWWWWWW
2
PARAMETERSnSIMULATIONSESTIMATESCOMPUTATIONS
3
Error termsData
4
parametervalueu1u2e1e2(x,y)estmatorvaluehatyee^2
(y-bary)^2
(x-barx)^2
5
b0210.0780.575-1.031-2.007(8.439,13.280)hatb06.64545.20-31.921018.81449.625.50
6
b1520.1020.0891.1361.808(1.625,44.192)hatb14.56814.0730.12907.3894.2419.97
7
x0130.2990.4780.219-1.539(3.800,27.567)barY34.48524.003.5612.6947.865.26
8
x11140.6050.676-0.895-0.450(9.027,20.276)barX6.09447.88-27.61762.04201.878.60
9
var(e)3050.6250.1580.8130.529(1.846,35.619)15.0820.54421.911.2918.04
10
60.4310.0430.3471.250(3.003,27.424)TSS109343.98420.377.0649.8349.859.55
11
70.0560.583-1.203-2.079(2.909,-19.533)RSS85447.47419.94-39.471557.802917.9310.14
12
80.8190.1690.5520.309(1.226,24.695)R^20.21912.2512.45154.9595.8423.70
13
90.2510.967-0.3431.626(8.009,31.747)n10043.23-11.49131.937.493.67
14
100.2000.584-0.903-1.551(11.930,34.567)61.14-26.58706.260.0134.05
15
110.0770.1321.6751.525(2.533,64.927)18.2246.712181.74926.7712.68
16
120.4210.983-0.1381.308(1.806,6.884)14.90-8.0164.18761.7818.39
17
130.4910.2801.171-0.225(5.801,66.140)33.1433.001088.791002.090.09
18
140.5930.1760.9130.461(10.950,84.138)56.6727.47754.672465.4723.58
19
150.1030.2442.1310.080(2.054,76.189)16.0360.163619.561739.2916.32
20
160.4760.873-0.8730.850(8.225,16.942)44.22-27.28744.08307.754.54
21
170.0930.667-1.893-1.080(6.573,-21.940)36.67-58.613435.323183.710.23
22
180.2020.3021.693-0.574(7.818,91.891)42.3649.532453.273295.512.97
23
190.8250.3920.390-0.482(4.711,37.267)28.169.1082.857.741.91
24
200.7620.1270.5280.514(10.453,70.105)54.4015.71246.711268.8519.00
25
210.4100.748-1.336-0.018(4.389,-16.138)26.69-42.831834.562562.692.91
26
220.1570.715-1.878-0.426(11.458,2.942)58.99-56.053141.46994.9128.78
27
230.6710.3810.610-0.654(9.721,68.896)51.0517.84318.371184.1313.15
28
240.3040.3381.313-0.812(11.183,97.302)57.7339.571565.733946.0725.90
29
250.4660.685-1.133-0.492(11.671,26.375)59.96-33.591128.1265.7731.10
30
260.8200.533-0.129-0.617(8.671,41.499)46.26-4.7622.6549.206.64
31
270.0710.938-0.8692.131(2.392,-12.112)17.57-29.68881.122171.2513.71
32
280.5470.4290.473-0.992(1.989,26.120)15.7310.39107.9469.9716.85
33
290.3740.732-1.394-0.156(2.941,-25.108)20.08-45.192042.023551.229.94
34
300.2890.577-0.731-1.395(4.463,2.372)27.03-24.66608.191031.242.66
35
310.9940.3580.087-0.070(5.403,31.634)31.330.310.108.130.48
36
320.5440.4490.346-1.047(1.706,20.921)14.446.4842.01183.9719.25
37
330.9900.3980.083-0.111(11.958,64.293)61.273.029.12888.5534.38
38
340.1590.562-0.725-1.775(11.762,39.063)60.38-21.31454.2820.9632.12
39
350.7790.884-0.4700.529(11.739,46.601)60.27-13.67186.90146.8031.86
40
360.7320.885-0.5230.593(10.756,40.099)55.78-15.68245.9231.5221.73
41
370.9980.0400.0170.066(8.323,44.121)44.67-0.540.3092.864.97
42
380.2790.0300.2971.571(2.030,21.057)15.925.1426.41180.3116.52
43
390.5550.791-1.0480.278(1.692,-20.991)14.37-35.371250.723077.5919.38
44
400.1570.4980.023-1.924(10.909,57.225)56.480.740.55517.1223.19
45
410.8000.968-0.1350.655(4.452,20.206)26.98-6.7845.92203.892.70
46
420.4720.1531.0060.700(3.854,51.445)24.2527.20739.65287.675.02
47
430.7860.3300.609-0.334(9.838,69.473)51.5917.88319.811224.1914.02
48
440.2490.937-0.6451.538(9.132,28.321)48.36-20.04401.7037.999.23
49
450.9020.3540.360-0.275(10.747,66.539)55.7410.80116.551027.4721.65
50
460.4440.784-1.2450.271(3.025,-20.212)20.47-40.681654.702991.759.42
51
470.7100.0000.0030.827(2.022,12.190)15.88-3.6913.65497.0616.58
52
480.4790.630-0.886-0.828(4.603,-1.578)27.67-29.25855.571300.502.22
53
490.6870.535-0.190-0.846(1.828,5.454)15.00-9.5491.06842.7818.20
54
500.3490.3800.994-1.058(1.898,41.313)15.3126.00675.9846.6317.61
55
510.7380.834-0.6740.391(5.064,7.113)29.78-22.66513.69749.201.06
56
520.5140.718-1.130-0.233(1.828,-22.753)14.99-37.751424.923276.1718.20
57
530.7360.509-0.047-0.782(10.801,54.608)55.99-1.381.90404.9422.15
58
540.7350.686-0.722-0.309(7.898,19.830)42.72-22.89524.10214.753.25
59
550.0620.622-1.636-1.695(6.201,-16.073)34.97-51.052605.742556.110.01
60
560.7020.0130.0710.839(7.929,43.778)42.870.910.8386.373.37
61
570.1210.701-1.958-0.623(7.764,-17.915)42.11-60.033603.312745.692.79
62
580.8500.3000.543-0.175(8.054,58.566)43.4415.13228.85579.933.84
63
590.0360.2962.472-0.736(4.172,97.009)25.7071.315084.513909.333.69
64
600.9950.2690.095-0.011(9.682,53.253)50.882.385.65352.2712.87
65
610.3170.3071.420-0.529(4.049,64.839)25.1439.701575.73921.394.18
66
620.5200.503-0.020-1.143(4.183,22.303)25.75-3.4511.90148.403.65
67
630.0970.884-1.4411.607(4.307,-19.694)26.32-46.012117.202935.353.20
68
640.6590.2270.9030.129(5.737,57.787)32.8524.93621.72542.990.13
69
650.6460.793-0.9010.250(6.099,5.466)34.51-29.04843.45842.100.00
70
660.0810.981-0.2742.226(9.020,38.882)47.85-8.9780.4919.348.56
71
670.2760.747-1.604-0.027(5.086,-20.698)29.88-50.572557.823045.091.02
72
680.3530.2311.4330.176(7.630,83.139)41.5041.641733.822367.302.36
73
690.4140.3571.041-0.825(3.381,50.130)22.0928.04786.28244.777.36
74
700.0760.3142.087-0.889(10.089,115.063)52.7462.333884.726492.9215.96
75
710.5670.0370.2431.038(1.281,15.694)12.503.2010.22353.1023.17
76
720.4420.3790.878-0.927(3.746,47.080)23.7623.32543.91158.635.51
77
730.1570.4180.947-1.676(1.324,37.046)12.7024.35592.966.5622.75
78
740.7090.3740.590-0.583(9.398,66.677)49.5817.10292.451036.3610.91
79
750.7040.551-0.262-0.795(4.060,14.431)25.19-10.76115.80402.144.14
80
760.6410.503-0.017-0.943(5.257,27.760)30.66-2.908.4045.220.70
81
770.6440.4630.216-0.914(5.954,38.247)33.854.4019.3714.160.02
82
780.2550.991-0.0931.650(2.265,10.536)16.99-6.4641.70573.5514.66
83
790.1290.4510.617-1.929(7.284,56.940)39.9217.02289.69504.261.42
84
800.3190.4390.561-1.404(11.283,75.241)58.1917.05290.751661.1326.93
85
810.5570.799-1.0310.325(7.657,9.342)41.62-32.281042.10632.162.44
86
820.9200.535-0.089-0.399(3.573,17.205)22.97-5.7633.23298.606.35
87
830.1690.513-0.157-1.879(8.684,40.718)46.32-5.6031.3338.866.71
88
840.0830.3831.494-1.654(10.106,97.360)52.8144.551984.473953.3716.10
89
850.0090.0400.7622.986(1.405,31.876)13.0618.81353.956.8021.99
90
860.8550.2800.550-0.106(7.606,56.531)41.3915.14229.20486.052.29
91
870.7400.868-0.5730.522(8.639,28.009)46.11-18.10327.6341.936.48
92
880.4790.3011.152-0.379(6.141,67.279)34.7032.581061.411075.500.00
93
890.2940.3950.961-1.235(7.716,69.421)41.8927.53757.691220.522.63
94
900.3150.688-1.407-0.574(2.355,-28.425)17.40-45.832100.083957.6013.98
95
910.0780.4071.244-1.883(6.912,73.872)38.2235.651270.811551.330.67
96
920.9050.672-0.395-0.211(1.663,-1.525)14.24-15.77248.611296.6619.63
97
930.5580.0630.4140.998(10.683,67.832)55.4512.38153.371112.0721.06
98
940.1720.982-0.2061.864(3.706,14.348)23.57-9.2385.13405.485.70
99
950.3060.3151.411-0.615(2.941,59.032)20.0838.951517.19602.599.94
100
960.0900.0590.7962.043(10.852,80.136)56.2223.92571.962084.0922.64
Loading...
 
 
 
Sheet1
 
 
Main menu