See attached Data. This file contains data collected from a sample of college students. Create a scatter plot of the two quantitative variables and find the regression line for these data.
(a) Write the equation of the line and indicate what the variables x and y represent in the equation.
(b) Is there a clear choice of explanatory variable and response variable in this data set? Why or why not?
(c) Describe what your scatter plot and line show.
(d) There is one clearly unusual data point in the data set-the male who estimated he saw 200 movies at a theater last year. Delete this case and look at the scatter plot for these adjusted data. Write the equation of this adjusted line and describe how the least-squares line changed when the outier was deleted.© BrainMass Inc. brainmass.com March 4, 2021, 9:23 pm ad1c9bdddf
This solution shows how to create a scatterplot in Excel and analyze the given data.