Using the regression feature of Excel, compute the equation of a trend line to forecast sales in…

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?

 

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-8hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Paper Now