Explore BrainMass

Explore BrainMass

    Lines of Best Fit

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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
    https://brainmass.com/business/strategy-and-business-analysis/creating-analyzing-scatterplot-240316

    Attachments

    Solution Summary

    This solution shows how to create a scatterplot in Excel and analyze the given data.

    $2.49

    ADVERTISEMENT