Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Working with the file County1.csv that concerns unemployment in different counties in the United States. We will consider the variables HS (high school graduate percentage),

Working with the file County1.csv that concerns unemployment in different counties in the United States. We will consider the variables HS (high school graduate percentage), Bachelor (bachelor's degree percentage), and Poverty along with the binary variables (Reg1, Reg2, Reg3, Reg4) that represent four regions in the country to build a regression model to predict the Unemployment variable.

a. Run a multiple regression analysis to predict Unemployed as function of HS, Bachelor, Poverty, Reg1, Reg2, and Reg3. Call this model R1. Calculate R^2 and Adjusted R^2.

b. Use R1 to predict Unemployment for a county in region 2 with a high school graduation percentage of 83, a bachelor's degree percentage of 23, and Poverty level of 10.

c. By how much would the previous prediction change if the county were in region 4 instead of region 2?

d. Test the variables for significance. If any variables are not significant remove them, one at a time, and run a new regression on the remaining variables. Continue this process until all variables are significant. Call this model R2. Calculate R^2 and Adjusted R^2.

e. Use R2 to predict Unemployment for a county in region 2 with a high school graduation percentage of 83, a bachelor's degree percentage of 23, and Poverty level of 10.

f. Run a multiple regression analysis to predict Unemployed as a function of HS, Bachelor, Poverty, Reg2, Reg3, and Reg4. Call this model R3. Calculate R^2 and Adjusted R^2.

g. Use R3 to predict Unemployment for a county in region 2 with a high school graduation percentage of 83, a bachelor's degree percentage of 23, and Poverty level of 10.

h. By how much would the previous prediction change if the county were in region 4 instead of region 2?

i. Run a multiple regression analysis to predict Unemployed as a function of HS, Bachelor, Poverty, Reg1, Reg2, Reg3, and Reg4. What is wrong with this model?

j. Run a multiple regression analysis to predict Unemployed as a function of HS, Bachelor, and Poverty. Call this model R4. Calculate R^2 and Adjusted R^2.

k. Use R4 to predict Unemployment for a county in region 2 with a high school graduation percentage of 83, a bachelor's degree percentage of 23, and Poverty level of 10.

l. Perform the partial F-test on R1 and R4 to determine if, collectively, the regions are significant variables.

County1: https://docs.google.com/spreadsheets/d/1-JaxeP1ru-la8KUA3F9VDCjTvjUQfUNU8kYvA3GKnsE/edit?usp=sharing

County2: https://docs.google.com/spreadsheets/d/1A3jDRxdZErTUlvL5UpTukd4rgfljVrPzKsAwRWD6Gp8/edit?usp=sharing

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Prealgebra

Authors: Elayn Martin Gay

7th edition

321955048, 978-0321955043

More Books

Students also viewed these Mathematics questions