5) To assess education levels by state, a dataset with the following variables w

Question

5) To assess education levels by state, a dataset with the following variables was developed: ColGrad% = percent of state population with a college degree, Dropout = percent of high school students who do not graduate, EdSpend = per capita spending on K-12 education, Urban = percent of state population living in urban areas, Age = median age of state’s population, FemLab = percent of adult females who are in the labor force, and Region shows in which of the four regions of the country (Northeast, Southeast, West, Midwest) the state resides. The data appears in the ColGrads worksheet of the HW8 data workbook on Moodle.

a) To determine if high school dropout rates depend on region of the county, fit a multiple regression model using Dropout as the Y or dependent variable and Neast, Seast and West as the X or independent variable. Is the model significant at = 0.05? What is the equation of the fit line. Interpret the model parameters in the context of the problem. Note: To perform this analysis you will need to develop indicator variables to represent regions. Using Midwest as the baseline region (the region without an indicator variable) will result in regression models that match the solution.

b) To determine if high school dropout rates depend on both region of the county and living in urban areas, fit a multiple regression model using Dropout as the Y or dependent variable and Urban and Region as the X or independent variables. Sketch the model you fit in the Dropout vs. Urban plane. Interpret your model in the context of high school dropout rates.

EdSpend Urban Age Femlab Region 3627 60.4 33 51.8 Southeast 8330 67.5 29.4 64.9 West 4309 87.5 32.2 55.6 West 3700 53.5 33.8 53.6 Southeast 4491 92.6 31.5 56 West 5064 82.4 32.5 63.3 West 7602 79.1 34.4 63.9 Northeast 5865 73 32.9 60.7 Northeast 5276 84.8 36.4 54.6 Southeast 4466 63.2 31.6 57.4 Southeast 5166 89 32.6 61.7 West 3386 57.4 31.5 57.8 West 5520 84.6 32.8 58.3 Midwest 4930 64.9 32.8 57.4 Midwest 4679 60.6 34 62.2 Midwest 4874 69.1 32.9 60.4 Midwest 4354 51.8 33 52.9 Southeast 4146 68.1 31 52.7 Southeast 5458 44.6 33.9 61 Northeast 6566 81.3 33 62.8 Northeast 6366 84.3 33.6 59.9 Northeast 5883 70.5 32.6 55.7 Midwest 5239 69.9 32.5 66.6 Midwest 3187 47.1 31.2 54.1 Southeast 4754 68.7 33.5 60.2 Midwest 5204 52.5 33.8 60.8 West 5038 66.1 33 63.4 Midwest 4653 88.3 33.3 61.6 West 5672 51 32.8 65.3 Northeast 8645 89.4 34.5 57.4 Northeast 3895 73 31.3 54.8 West 8565 84.3 33.9 52.6 Northeast 4488 50.4 33.1 60.5 Southeast 4199 53.3 32.4 59.9 Midwest 5245 74.1 33.3 56.8 Midwest 3791 67.7 33.2 54.3 Midwest 5683 70.5 34.5 58.4 West 6541 68.9 35 54.1 Northeast 6343 86 34 59.9 Northeast 4351 54.6 32 59.5 Southeast 3965 50 32.5 62.7 Midwest 3782 60.9 33.6 53.9 Southeast 4438 80.3 30.8 58.7 West 2960 87 26.2 61.2 West 6738 32.2 33 63.8 Northeast 4836 69.4 32.6 64 Southeast 5000 76.4 33.1 59.3 West 4911 36.1 35.4 44.2 Southeast 5871 65.7 32.9 63.1 Midwest 5723 65 32 61.8 West

Explanation / Answer

please check this

please check this

please check this

please check this

please check this

please check this

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.