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 Below

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 dependentvariableandUrbanandRegionastheXorindependentvariables. Sketch the model you fit in the Dropout vs. Urban plane. Interpret your model in the context of high school dropout rates.

State	ColGrad%	Dropout	EdSpend	Urban	Age	Femlab	Region
AL	15.6	35.3	3627	60.4	33	51.8	Southeast
AK	23	31.6	8330	67.5	29.4	64.9	West
AZ	20.3	27.5	4309	87.5	32.2	55.6	West
AR	13.4	23.3	3700	53.5	33.8	53.6	Southeast
CA	23.4	32.2	4491	92.6	31.5	56	West
CO	27	25.9	5064	82.4	32.5	63.3	West
CT	27.2	25.1	7602	79.1	34.4	63.9	Northeast
DE	21.4	31.5	5865	73	32.9	60.7	Northeast
FL	18.3	38.9	5276	84.8	36.4	54.6	Southeast
GA	19.3	37.3	4466	63.2	31.6	57.4	Southeast
HI	22.9	13.2	5166	89	32.6	61.7	West
ID	17.7	20.6	3386	57.4	31.5	57.8	West
IL	21.1	23.4	5520	84.6	32.8	58.3	Midwest
IN	15.6	25	4930	64.9	32.8	57.4	Midwest
IA	16.9	12.5	4679	60.6	34	62.2	Midwest
KS	21.1	18	4874	69.1	32.9	60.4	Midwest
KY	13.6	31	4354	51.8	33	52.9	Southeast
LA	16.1	43.3	4146	68.1	31	52.7	Southeast
ME	18.8	22.4	5458	44.6	33.9	61	Northeast
MD	26.5	27.2	6566	81.3	33	62.8	Northeast
MA	27.2	23	6366	84.3	33.6	59.9	Northeast
MI	17.3	29.9	5883	70.5	32.6	55.7	Midwest
MN	21.9	10.3	5239	69.9	32.5	66.6	Midwest
MS	14.8	35.8	3187	47.1	31.2	54.1	Southeast
MO	17.8	27.8	4754	68.7	33.5	60.2	Midwest
MT	19.8	16.7	5204	52.5	33.8	60.8	West
NE	19	14.5	5038	66.1	33	63.4	Midwest
NV	15.3	22.8	4653	88.3	33.3	61.6	West
NH	24.3	26	5672	51	32.8	65.3	Northeast
NJ	24.8	20.2	8645	89.4	34.5	57.4	Northeast
NM	20.4	31.8	3895	73	31.3	54.8	West
NY	23.1	34.9	8565	84.3	33.9	52.6	Northeast
NC	17.4	32	4488	50.4	33.1	60.5	Southeast
ND	18	11.9	4199	53.3	32.4	59.9	Midwest
OH	17	26	5245	74.1	33.3	56.8	Midwest
OK	17.8	22.5	3791	67.7	33.2	54.3	Midwest
OR	20.6	28.4	5683	70.5	34.5	58.4	West
PA	17.9	20.9	6541	68.9	35	54.1	Northeast
RI	21.3	30.4	6343	86	34	59.9	Northeast
SC	16.6	41.5	4351	54.6	32	59.5	Southeast
SD	17.2	14.3	3965	50	32.5	62.7	Midwest
TN	15.9	32.1	3782	60.9	33.6	53.9	Southeast
TX	20.4	35.9	4438	80.3	30.8	58.7	West
UT	22.2	16.9	2960	87	26.2	61.2	West
VT	24.3	18.4	6738	32.2	33	63.8	Northeast
VA	24.5	26.4	4836	69.4	32.6	64	Southeast
WA	22.9	22.8	5000	76.4	33.1	59.3	West
WV	12.3	22.7	4911	36.1	35.4	44.2	Southeast
WI	17.7	15.8	5871	65.7	32.9	63.1	Midwest
WY	18.8	21.4	5723	65	32	61.8	West