Application Assignment #5 20 points Part 1) Exercise and Life Expectancy (16 points) Review the Health data given in the Excel spreadsheet, named as MATH215-DATA for Application Assignment-5. The variable of Exercise Time (mins) is the average daily exercise time in minutes for residents per state, and the Life Expectancy (years) variable is the average life expectancy in years per state. 1. Create a scatterplot to see the relationship between the variables Exercise Time and Life Expectancy. [Hint: you might consider changing the x-axis scale] Copy and paste your graph here and answer the following questions. a. What is the independent variable? b. What is the dependent variable? c. Explain if there seems to be a linear association between the two variables? Find the correlation coefficient, r and describe the relationship between Exercise-Time and Life Expectancy using r. Round your answer to 3 decimals. Is the relationship positive or negative; strong, moderate, or weak? Find the equation of the estimated linear regression line, y. Write the equation below and paste the scatterplot with the regression line below. If the average Exercise Time in a state is 65 minutes, what would you predict the average Life Expectancy of that state to be? (Use the estimated linear regression line, , in question 3) Can an Exercise Time of 120 minutes be used to estimate the average Life Expectancy for a state? Why or why not? A. Choose one of the provided states and find the Exercise Time and Life Expectancy in that state. What is the state you chose? What is the Exercise Time in that state? What is the Life Expectancy in that state? B. Find the estimated average Life Expectancy in this state using the estimated regression line y. C. Is the estimated average Life Expectancy in this state higher or lower than the actual Life Expectancy. By-howe.much will (Life Expectancy) change with one-minute increase in Exercise Time? 8. Ifthe average Life Expectancy of a state is 75.9 years, what would you expect the average Exercise Time of that state to be? (Use the estimated linear regression line, , in question 3) Part 2) Student Interpretation and Reflection 4 pts Write a summary of your learning from this assignment by addressing the following questions: e Based on the analysis performed above, what can be said about the relationship between Exercise Time and the average Life Expectancy in years? How did the regression analysis you completed above help you understand the relationship? Include a few sentences in your summary whether Exercise Time and Life Expectancy have any causal relationship. Explain