Question
In this assignment use MS Excel to develop a simple linear regression formula. Read How to Create A Simple Linear Regression Equation , https://owlcation.com/stem/How-to-Create-a-Simple-Linear-Regression-Equation it
In this assignment use MS Excel to develop a "simple linear regression formula". Read How to Create A Simple Linear Regression Equation, https://owlcation.com/stem/How-to-Create-a-Simple-Linear-Regression-Equation it will help you with this assignment.
Next, enter the data in an excel sheet with the information, below. After you have installed the Analysis ToolPak, open "Data Analysis" and scroll down to "Regression" and click. The regression window will open. Run a regression analysis on the annual car sales, over the last three years, taken from William and Sam Automotive sales.
Year | Median Income | Car Sales |
2019 | $55,000 | 260 |
2020 | $60,000 | 290 |
2021 | $65,000 | 320 |
First identify the independent and dependent variables. Next explain the relationship between the independent and dependent variable include its strength and direction. Then, explain how the formula can be used to forecast future sales. Finally, if annual income in 2022 rises to $70,000 what is your prediction for car sales in 2022? Please attach or copy the data output in Excel include your scatterplot and graph with your response.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started