Question
Can you help solve a linear regression forecasting for at least 6 more quarters using excel functionalities? The table of values is really just market
Can you help solve a linear regression forecasting for at least 6 more quarters using excel functionalities? The table of values is really just market share (in %) for the vertical axis and the quarters, beginning 1st quarter 2015 up to 2nd quarter 2019. I want to get the forecasts for the next 6 quarters, using excel solver for linear regression.
Quarters 1st Qtr 2015 2nd Qtr 2015 3rd Qtr 2015 4th Qtr 2015 1st Qtr 2016 2nd Qtr 2016 3rd Qtr 2016 4th Qtr 2016 1st Qtr 2017 2nd Qtr 2017 3rd Qtr 2017 4th Qtr 2017 1st Qtr 2018 2nd Qtr 2018 3rd Qtr 2018 4th Qtr 2018 1st Qtr 2019 2nd Qtr 2019
% Market Share 2.2 2.8 3.2 3.6 5.9 6.6 7.1 7.3 7.5 8 8.1 6.9 7.4 8.6 8.4 7.8 7.4 8.9
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started