question archive 1)Consider the sales pattern shown in the data set below:  Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015

1)Consider the sales pattern shown in the data set below:  Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015

Subject:EconomicsPrice: Bought3

1)Consider the sales pattern shown in the data set below: 

Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015.  Note, you can use 'Year' as the explanatory variable or the 'Time Index' as the explanatory variable, but not both in the same equation.  In your opinion, is this a good equation for forecasting future sales? Why or why not?

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE