ECONOMICS HOMEWORK

profileACCOUNTING123
Assign2.4TutorialData1.xlsx
Home>Business & Finance homework help>Economics homework help>ECONOMICS HOMEWORK

ChartCars

Price versus Age of Ford Taurus Cars

0.5 0.5 1 1 1 2 3 3 4 5 14992 13900 11 875 9992 11900 8990 10300 7999 6990 4990

Age (in years)

ChartHouses

Price versus Square Feet of House

830 1050 1124 1378 1518 1700 1904 1969 2070 2078 2350 2439 2448 2467 2490 2550 2708 2800 2843 2927 3100 3171 3400 3400 3400 3470 3600 3600 3800 4200 98000 77000 84000 104650 150500 90300 142300 185500 147000 192500 195650 166600 179200 185500 202300 244650 269500 192500 195600 202650 241500 255500 301000 273000 244650 269500 265650 245000 262500 300300

Square Feet of House

ChartSchooling

Earnings versus Years of Schooling

(Males, 25 to 35 years old)

8 10 12 14 14 16 17714 24517 28772 32354 34670 48688

Years of Schooling

ChartLN

LN( Earnings ) versus Years of Schooling

(Males, 25 - 34)

8 10 12 14 14 16 9.7820999999999998 10.107100000000001 10.267200000000001 10.384499999999999 10.4536 10.793200000000001

Years of Schooling

Data

Educational Attainment, Males, 25-34, '97 Earnings, Full- Educational Attainment, Males, 25-34, '97 Earnings, Full- Educational Attainment, Males, 25-34, '97 LN( Earnings), Full-
Age (years) Asking Price Price Square Feet Time Workers Time Workers Time Workers Asking Price of Ford Taurus
0.5 14,992 $98,000 830 less than 9th grade $17,714 8 $17,714 8 9.7821 Age (in Years) Intercept
0.5 13,900 $77,000 1050 9th-12th grade $24,517 10 $24,517 10 10.1071 Coefficient -1787.89 13947.38
1 11,875 $84,000 1124 H.S. graduate $28,772 12 $28,772 12 10.2672 Std. Error 285.00 734.94
1 9,992 $104,650 1378 Some College $32,354 14 $32,354 14 10.3845 R-sqr 83.1% 1348.8593395374
1 11,900 $150,500 1518 Assoc. Degree $34,670 14 $34,670 14 10.4536 39.3547964308 8
2 8,990 $90,300 1700 Bach. Degree or more $48,688 16 $48,688 16 10.7932 71602963.4571429 14555372.1428571
3 10,300 $142,300 1904 t-stat -6.27 18.98
3 7,999 $185,500 1969
4 6,990 $147,000 2070 Price of House
5 4,990 $192,500 2078 Square Feet Intercept
$195,650 2350 Coefficient 69.40 21190.20
$166,600 2439 Std. Error 5.41 14615.79
$179,200 2448 R-sqr 85.4% 25498.3899121507
$185,500 2467 164.3726916595 28
$202,300 2490 106869845799.529 18204700867.1379
$244,650 2550 t-stat 12.82 1.45
$269,500 2708
$192,500 2800 Earnings, Males, 25-34
$195,600 2843 Schooling (in Years) Intercept
$202,650 2927 Coefficient 3384.73 -10625.85
$241,500 3100 Std. Error 564.06 7120.04
$255,500 3171 R-sqr 90.0% 3713.1294648957
$301,000 3400 36.0072681155 4
$273,000 3400 496444103.141026 55149321.6923077
$244,650 3400 t-stat 6.00 -1.49
$269,500 3470
$265,650 3600 LN( Earnings ), Males, 25-34
$245,000 3600 Schooling (in Years) Intercept
$262,500 3800 Coefficient 0.11 8.90
$300,300 4200 Std. Error 0.01 0.15
R-sqr 95.9% 0.0774706595
92.7160300269 4
0.5564540827 0.0240068123
t-stat 9.63 59.91
Intercept in natural numbers: 7335