HW 10 (1)

high low $25,177 63.1 6.6 High 1 0 $25,684 55.8 5.9 High 1 0 $26,422 48.9 5.6 High 1 0 $26,459 58.2 6.6 Low 0 1 $26,645 75.5 6.4 High 1 0 $26,652 61.9 5.8 High 1 0 $26,805 63 5.7 Low 0 1 $26,877 62.6 6.4 High 1 0 $27,992 80.9 5.4 High 1 0 $28,202 55.1 6.2 Medium 0 0 $28,351 68.2 6.5 High 1 0 $28,444 68.1 5.5 Low 0 1 $28,608 66.4 5.8 Low 0 1 $28,793 71.2 5.6 Medium 0 0 $28,824 68.1 5.7 Low 0 1 $28,830 60 7.7 Low 0 1 $28,865 70.3 6.8 Low 0 1 $29,244 82.2 5 Low 0 1 $29,538 71.3 5.2 Low 0 1 $29,674 74.6 5.6 Low 0 1 $29,849 60.1 7.3 Low 0 1 $29,890 70.7 5.2 Medium 0 0 $30,444 48.2 5 Low 0 1 $30,508 61.9 6.3 Low 0 1 $30,627 70.2 5 Low 0 1 $30,882 64.2 4.4 High 1 0 $30,928 67.6 5 Low 0 1 $30,983 56.3 8.1 Medium 0 0 $30,985 73.7 4.2 Low 0 1 $31,010 55.2 9 Low 0 1 $31,066 59.7 5.9 Low 0 1 $31,122 66.2 7.9 Low 0 1 $31,191 55.5 5.7 Medium 0 0 $31,301 47.8 7.6 Medium 0 0 $31,397 73.2 3.9 Low 0 1 $31,793 64.2 4.6 Medium 0 0 $32,074 60.3 5.4 Medium 0 0 $32,139 66.5 4.5 Low 0 1 $32,396 64.1 6.2 Low 0 1 $32,552 64.6 3.7 Low 0 1 $32,611 78.5 3.8 Low 0 1 Median Household Income 2000 Graduation Rate (%) Unemployment Rate 2006 (%) Tobacco Dependency Ranking

$32,868 64.9 5.3 Low 0 1 $32,903 72 6.8 Medium 0 0 $33,046 80.1 5.2 Low 0 1 $33,116 55.8 7.2 High 1 0 $33,230 47.1 5.6 Low 0 1 $33,756 65.2 4.6 Low 0 1 $33,784 66.9 6 Low 0 1 $33,922 68.4 4.1 Low 0 1 $33,942 61.5 4.8 Medium 0 0 $34,084 76.2 4.5 Low 0 1 $34,258 72.1 5.5 Low 0 1 $35,018 64.8 7.2 Medium 0 0 $35,105 65.5 4.9 Medium 0 0 $35,283 62.5 6.4 Medium 0 0 $35,629 60.6 5.8 Low 0 1 $35,647 69 4 Medium 0 0 $35,739 65.7 7.5 Low 0 1 $35,888 56.9 4.5 Low 0 1 $35,902 58.9 4.2 Low 0 1 $35,966 66.9 4.4 Medium 0 0 $36,259 65.9 3.6 High 1 0 $36,660 74.2 4.3 Medium 0 0 $36,666 70.4 3.8 Low 0 1 $36,898 75.5 5.1 Low 0 1 $37,147 60.1 5.6 Medium 0 0 $37,159 75.5 6.2 Medium 0 0 $37,466 64.7 5.5 Low 0 1 $37,494 67.6 5 Low 0 1 $38,109 74.5 3.6 Medium 0 0 $38,344 69.2 4.1 Low 0 1 $38,348 73.4 4.7 Low 0 1 $38,587 77.1 4.3 High 1 0 $38,640 62.6 5.9 Low 0 1 $38,684 70.7 4.9 Low 0 1 $38,808 78.1 4.3 Low 0 1 $38,900 64.2 5.4 Medium 0 0 $38,968 61.5 4.1 Medium 0 0 $39,168 66.7 5.5 Medium 0 0 $39,482 68.1 5.5 Low 0 1 $39,493 76.8 4.3 Low 0 1 $39,965 72.4 5.3 Low 0 1 $40,172 60.4 3.7 Medium 0 0 $40,174 80 4.2 Low 0 1 $40,536 77.6 5.4 Low 0 1

1. State your null and alternative hypotheses: H0: Counties are not dependent on tobacco for employment and income. H1: Counties are dependent on tobacco for employement and income. 2. Create the necessary dummy variables. How may dummy variables were cr 3. Run the regression using the data analysis tool pack. Place your output bel SUMMARY OUTPUT Regression Statistics Multiple R 0.283488555454222 R Square 0.080365761073521 Adjusted R Squ 0.061404230374006 Standard Error 5577.94658792102 Observations 100 ANOVA df SS MS Regression 2 263740221.5531131870111 Residual 97 3018008349.357 31113488 Total 99 3281748570.91 Coefficients Standard Error t Stat Intercept 35393.6923076923 1093.92532683 32.354761 high -4718 1894.734245756 -2.490059 low 152.750315258519 1306.418693707 0.1169229 Tobacco Dependency Ranking : A ranking of how dependent the county is on tobacco for employment and income. Includes both growing, processing, and manufacturing of tobacco products.

4. Write up the results of your regression: We would reject the null hypothesis because counties are dependent The pvalue for high dependency ranking was less than 0.05. The low

t on tobacco for income and employement. wer dependency ranking had a pvalue of 0.907 which is greater than 0.05.

Possible Points 5 5 15 15

Case Birth Weight (Grams) Gestation (weeks) D (Teen) D(40s) 1 2288 33 0 1 2 2792 34 0 0 3 1899 32 0 1 4 3796 38 0 0 5 3606 39 0 0 6 3903 40 0 0 7 2487 33 0 1 8 2335 32 1 0 9 1705 32 1 0 10 2198 33 0 0 11 3432 36 0 0 12 3790 36 0 0 13 2605 35 0 1 14 3583 40 0 0 15 4010 40 0 1 16 1588 32 1 0 17 4085 41 0 1 18 2760 36 0 0 19 2402 35 0 1 20 3843 39 0 0 21 3640 35 0 0 22 3862 37 0 0 23 2312 35 1 0 24 1658 32 1 0 25 1782 33 0 1 26 2191 35 1 0 27 3361 36 0 0 28 2690 36 0 1 29 3787 38 0 0 30 2736 36 0 1 31 3566 37 0 0 32 4020 40 0 1 33 1613 33 1 0

Y = mX + b, where Y = de

Regression 3 19959362.135 6653121 Residual 29 2816621.744 97124.89 Total 32 22775983.879 Coefficients Standard Error t Stat Intercept -4628.528 874.87123885 -5.290525 Gestation (weeks) 219.038 23.587441489 9.286203 D (Teen) -685.147 170.16932238 -4.026264 D(40s) -398.461 126.47689756 -3.150464 ependent variable, m = coefficient, X = independent variable(s), and b = intercept 4. Compute the estimated birth weight of a baby born to a 35 year old mother a y= -4628.528+38*(219.038)+0(-685.1467)+0*(-398.461) 5. Compute the estimated birth weight of a baby born to a teen mother after 36 y=-4628.528+36*(219.038)+0*(-685.147)+0*(-398.461)

of mothers. others. ow: F Significance F ernal age of mothers on the birth weight (in grams) of babies. Use wer the following questions. m 20 - 39.

Possible Points 5 5 15 15

5 5 50