Lines of Best Fit
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
This solution shows how to create a scatterplot in Excel and analyze the given data.
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Motivation
This tests some key elements of major motivation theories.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.