Age	HRS1
58	32
24	46
32	40
29	40
34	86
49	40
60	40
78	25
39	5
67	15
22	40

1. Develop a scatter plot with HRS1 (how many hours per week oneworks) as the dependent variable and age as the independentvariable. Include the estimated regression equation and thecoefficient of determination on your scatter plot.
2. Does there appear to be a relationship between these variables(HRS1 and age)? Briefly explain and justify your answer.
3. Calculate the slope (b₁) and intercept(b₀) coefficients and use them to develop an estimatedregression equation that can be used to predict HRS1 given age.Conduct your analysis using Alpha (? ) of 0.05. Submit your Exceloutput or workings to receive full points. Hint: Useformulas and Excel, or Excel regression Tool (run a regression withHRS1 as dependent or y variable and age as independent or xvariable).
4. Interpret the slope coefficient b₁ (the coefficientfor the independent variable, age).
5. Use t and F to test for a significant relationship between HRS1and age. Use ? = 0.05 and make sure you know what hypotheses youare using to conduct the significance tests.
6. Calculate and interpret the coefficient of determinationR². Based on this R², did the estimatedregression equation provide a good fit? Briefly justify youranswer. Hint: If you used Excel Regression Tool to answerpart c, R² was reported with your output.
7. Use the estimated regression equation to predict the HRS1 for a60 year old individual.