Questions are in the excel
Sheet1 Presidential Election 2000 Result and Selected Characteristics of States StateBush%Age65%Urban%ColGrad%Union%Region1AA regression model was run using the data from the Election_2000 worksheet. AL56.513.069.920.49.6SeastEvaluate the model,i.e., is it a good model? If so, why, or if not, why? Consider all the appropriate tests, use α = 0.05 for t test and α = 0.05 for F test. AK58.65.741.528.121.9West You do not have to put down H0 and H1, you can color code the cell. But for each cell you color code--explain what you are testing and what your result means. AZ51.013.088.224.66.4WestSUMMARY OUTPUT AR51.314.049.918.45.8Seast1BIf you believe the model is OKAY, provide one reason to justify your belief. On the other hand, if you believe the model is not OKAY, CA41.710.696.727.516.0WestRegression Statistics provide one suggestion on how you would improve the model. CO50.89.783.934.69.0WestMultiple R0.8902450028 CT38.413.895.631.616.3NeastR Square0.79253616511CUsing the regression model, what is the model’s predicted value or forecast for a hypothetical state that is in the Northeast region, has a 12% population age 65 or over, DE41.913.080.024.013.3NeastAdjusted R Square0.7579588592a 93% of population living in urban areas, a 32% population with a college degree, and a 14.5% of the labor force belonging to Unions. FL48.817.692.822.86.8SeastStandard Error4.2865578148Show all your work--if you want you are in Excel--use some formulas GA54.79.669.223.16.3SeastObservations50 HI37.513.372.326.324.8West1D Based on the regression model, and only considering Region, rank order the four regions from highest to lowest % voters for Bush. ID67.211.339.920.07.6WestANOVAShow your work. IL42.612.184.927.118.6MidWestdfSSMSFSignificance F IN56.612.472.217.115.6MidWestRegression72948.1077282268421.158246889522.92070322360 IA48.214.945.325.513.6MidWestResidual42771.732271773218.3745778994 KS58.013.356.627.39.0MidWestTotal493719.84 KY56.512.548.820.512.0Seast LA52.611.675.422.57.1SeastCoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0% ME44.014.436.624.114.0NeastIntercept94.55016131227.525373757512.56418144268.11748151455162E-1679.3633422254109.73698039979.3633422254109.736980399 MD40.311.392.732.314.6NeastAge65%-1.28688335190.4009606016-3.20950075110.0025485129-2.0960546055-0.4777120983-2.0960546055-0.4777120983 MA32.513.595.932.714.3NeastUrban%-0.09827144340.034755987-2.82746806950.0071577418-0.1684118649-0.028131022-0.1684118649-0.028131022 MI46.112.382.223.020.8MidWestColGrad%-0.58151391060.1932987785-3.00836826440.0044252044-0.9716066386-0.1914211827-0.9716066386-0.1914211827 MN45.512.170.431.218.2MidWestUnion%-0.72807699020.1327364338-5.48513297610.0000021771-0.9959499585-0.4602040218-0.9959499585-0.4602040218 MS57.612.136.018.76.0SeastMidWest5.67145853172.03404792672.78826199580.00792780741.56658362819.77633343541.56658362819.7763334354 MO50.413.567.826.213.2MidWestNeast-1.60633734292.4902171992-0.64505913110.5223971171-6.63179910863.4191244229-6.63179910863.4191244229 MT58.413.433.923.813.9WestWest3.7482706452.00709452071.86751077560.0688191545-0.30221008317.7987513731-0.30221008317.7987513731 NE62.213.652.624.68.4MidWest NV49.511.087.519.317.1West NH48.112.059.930.110.4Neast NJ40.313.2100.030.120.8Neast NM47.811.756.923.68.1West NY35.212.992.128.725.5Neast NC56.012.067.523.23.6Seast ND60.714.744.222.66.5MidWest OH50.013.381.224.617.3MidWest OK60.313.260.822.56.8MidWest OR46.512.873.127.216.1West PA46.415.684.624.316.9Neast RI31.914.594.126.418.2Neast SC56.812.170.019.04.0Seast SD60.314.334.625.75.5MidWest TN51.112.467.922.08.9Seast TX59.39.984.823.95.8West UT66.88.576.526.47.3West VT40.712.727.828.810.3Neast VA52.511.278.131.95.6Seast WA44.611.283.128.618.2West WV51.915.342.315.314.3Seast WI47.613.167.923.817.6MidWest WY67.811.730.020.68.3West Variable Names: Bush% = percent of voters choosing Bush, Age65% = percent of population age 65 or over, Urban% = percent of population living in urban areas, ColGrad% = percent of population with college degree, Union% = percent of labor force belonging to unions, Region = Midwest, Neast, West, and Seast.