II$.$ Problems:

Using the data in the Excel file Demographics, apply the Excel Regression tool using unemployment rate as the dependent variable and cost of living index as the independent variable. Interpret all key regression results, hypothesis tests, and confidence intervals in the output$\mathrm{.}1.($refer to Problem #$10$ in textbook, page $319)$

Datafile: Demographics

Develop a Regression model with $$unemployment$$ rate as Y and $$cost of living$$ index as X$.$

$(1\mathrm{.}1)$ The regression equation is: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Value of R$2$: $\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Value of Adjusted R$2$: $\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Value of Significance F: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Value of p$-$value for $\backslash$beta $1($i$.$e$.$ for X variable$)$: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

Confidence Interval for $\backslash$beta $1($i$.$e$.$ for X variable$)$: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$(1\mathrm{.}2)$ The proportion of the variations of $$unemployment$$ explained by $$cost of living$$ as in the regression equation is $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$(1\mathrm{.}3)$ Is this regression statistically significant?

a$.$ Yes b$.$ No

$(1\mathrm{.}4)$ Is $$unemployment rate$$ significantly related to $$cost of living index$$ according to regression results $?$

a$.$ Yes b$.$ No$.$