Linear Regression Model
See the attachments.
Problem:
We are using a linear regression model (time series) to predict sales of our "WW" brand. Historically, sales of this product for the period 1982 to date (1982 through summer 2003; assume 1982 was year one) have been approximated by the following data (in thousands of units):
Y = 3.984X + 2.994
Sy = .677
r2 (R squared) = .24
(A) What would be your basic forecast of sales for 2005 (year 23)?
(B) If you wished to add the condition of 95% confidence in your 2005 forecast, what would be the range of prediction?
(C) Would you expect r2 (r squared) to have been computed using Pearson's or Spearman's mthod? Why?
(D) Suggest an alternative to time series that might improve the predictivity of the model. An r2 (r squared) of .24 isn't exactly stellar.
https://brainmass.com/statistics/regression-analysis/marketing-research-statistics-29649
Solution Preview
See attachment for the solution.
Problem:
We are using a linear regression model (time series) to predict sales of our "WW" brand. Historically, sales of this product for the period 1982 to date (1982 through summer 2003; assume 1982 was year one) have been approximated by the following data (in thousdands of units):
Y = 3.984X + 2.994 (1)
Sy = .677
r2 (R squared) = .24
(A) What would be your basic forecast of sales ...
Solution Summary
The solution answers different questions regarding the given data on sales. It discusses what the basic forecast would be for that year, the range of prediction etc.