Question 10 - Chapter 13 Homework - Connect Chapter 13 Homework Saved Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. 10 Exercise 13-47 (Static) (LO13-4) points City planners believe that larger cities are populated by older residen age in 10 large cities were collected. Population CITY millions ) Median age Dallas , TX 1: 233 30.5 Houston, TX 3: 849 new York, NY 8. 214 delphia, PA 1. 448 34.2 San Antonio, TX san Jose, CA 1.257 32.5 Click here for the Excel Data File a. Create a scatter plot of the data. What do you observe? 1. On the graph b to the first Population City and its Median age Population 1). 2. Repeat the process for the ulation 2, Population 3, . ). . To enter exact coordinates, double-click on the point and enter the exact coordinates of x and y. Graph Score: 0% Plot of Age and Population Medium age Population (in milions) b-1. Calculate the correlation coefficient. (Round your answer to 3 decimal places.) Answer is complete and correct. correlation coefficient b-2. What does it indicate about the relationship between median age and population? Answer is complete and correct. The correlation coefficient indicates a weak positive re between population and median age. c-1. Compute the slope Answer is complete but not entirely correct. 32.080 63 c-2. Report and interpret the coefficient of determination. Answer is complete but not entirely correct. Coefficient of determination 0.19 3 % d. Write the regression equation that predicts median age. e. Is the slope of the regression line significantly different from zero? Answer is complete and correct. The p-value to test if the slope of the regression line significantly different from zero 0.1901 With a significance level of 0.05 and the p-value, we would all to reject the null hypothesis that the slope is f. Summarize the results of this analysis. Answer is complete and correct. The results indicate no significant ity's median age and its population