Statistics Forecasting Case Study

profilemimiem

attached is useful data set on Lenovo investor relations website. It includes sales for each quarter for the past 6 years. I did some analysis in Excel and the data set has trend and seasonal pattern. I calculated seasonal indexes,i need help to deseasonalize the data, compute trend and write estimated regression equation. Also please do forecast for the next time periods. Additionally, please forecast the past sales using the regression and compute forecast accuracy. Next, please use alternative approach and forecast sales using regression with dummy variables.

 
  • 13 years ago
  • 20
Answer(2)

Purchase the answer to view it

blurred-text
  • attachment
    forecast_analysis.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    reg2.xlsx