Demonstrate your understanding of linear regression, your ability to use excel to complete a regression analysis, and to draw valid conclusions.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Objectives:
- Demonstrate your understanding of linear regression, your ability to use excel to complete a regression analysis, and to draw valid conclusions.
– download attachment for use
- (15pts) – Create a scatter chart in excel with MPG City as the dependent variable and Engine Size as the independent variable
- 5 pts – Select the correct variable for each axis
- 5 pts – Select an appropriate chart title and axis titles
- 5 pts – Eliminate any white space by adjusting the axis bounds
- (15pts) Add trend line features to scatter chart
- 5pts Display a trend line
- 5pts Display the equation
- 5pts Display the R-Square value
- (25pts) – Run regression analysis using the data analysis tool and answer the associated questions
- Upload your completed excel file in the last question to show your work.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds