stats
in this assignment you will use MS Excel to develop a “simple linear regression formula”. NOTE TO PRODUCTION- INCLUDE DIRECTIONS FOR EXCEL. I UPLOADED THEMN TO BASECAMP. Read How to Create Your Own Simple Linear Regression Equation, it will help you with this assignment.
Populate 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
Car Sales
2015
200
2016
250
2017
270
What is your regression forecasting formula? Explain how the formula can be used to forecast future sales. Prepare a word document with your explanation and forecasting formula. Upload the word document and excel file to the course upload area.
Reference
https://owlcation.com/stem/How-to-Create-a-Simple-Linear-Regression-Equation
6 years ago 8
Purchase the answer to view it
- Solution.xlsx
- Solution.docx
Purchase the answer to view it
- Solution.xlsx
- Economics work
- your state's governor has put you in charge of water policy for the state. The aquifer beneath your state has been...
- ACCT 567 Quizzes(Week 3 & 6) + Week 4 Midterm
- Assignment for Kim
- for A-plus Writer only
- 4 ASAP
- You have been asked to assess certain risks of an organization and quantify their potential impact on the organization’s profitability. ...
- Smith Case
- Alexander Hamilton
- chmestry