Using 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, a 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. Show all your work--if you want you are in Excel--use some formulas

Regression Statistics 7 Multiple R 0.890245 8 R Square 0.792536 Adjusted R Square 0.757959 10 Standard Error 4.286558 11 Observations 50 12 13 ANOVA 14 SS MS F Significance F 15 Regression 7 2948.108 421.1582 22.92070322 1.93509E-12 16 Residual 42 771.7323 18.37458 17 Total 49 3719.84 18 19 Coefficients tandard Errc t Stat P-value Lower 95% Upper 95%_ower 95.0%pper 95.0% 20 Intercept 94.55016 7.525374 12.56418 8.11748E-16 79.36334223 109.737 79.36334 109.737 21 Age65% -1.28688 0.400961 -3.2095 0.002548513 -2.096054606 -0.47771 -2.09605 -0.47771 22 Urban -0.09827 0.034756 -2.82747 0.007157742 -0.168411865 -0.02813 -0.16841 -0.02813 23 ColGrad% -0.58151 0.193299 -3.00837 0.004425204 -0.971606639 -0.19142 -0.97161 -0.19142 24 Union -0.72808 0.132736 -5.48513 2.17713E-06 -0.995949959 -0.4602 -0.99595 -0.4602 25 MidWest 5.671459 2.034048 2.788262 0.007927807 1.566583628 9.776333 1.566584 9.776333 Neast -1.60634 2.490217 -0.64506 0.522397117 -6.631799109 3.419124 6.6318 3.419124 27 West 3.748271 2.007095 1.867511 0.068819154 -0.302210083 7.798751 -0.30221 7.798751