stats

profileraysny
Home>Homework Answsers>Business & Finance homework help

7-12: Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the Excel file New Car Sales. 

Tips for problem 7-12: This is a multiple regression problem based on monthly data. You will need to create dummy variables for the months to represent seasonality in the model.

Here is a video about the concept:

http://www.youtube.com/watch?v=H07l1zgM-cw

Here is part of what want to do:

YearMonthUnitstFebMarAprMayJunJulAugSepOctNovDec
1Jan39,810100000000000
1Feb40,081210000000000
1Mar47,440301000000000
1Apr47,297400100000000
1May49,211500010000000
 


You will fill all entries for three years, then run regression in excl.

    • 13 years ago
    • 5
    Report issue
    Answer(2)
    profile
    kalfree
    4.9 (176)
    5.0 (4)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      new_car_sales_question.xlsx
    • attachment
      new_car_sales_forecasting_solution.xlsx
    profile
    MathematicsExpert
    4.8 (1k+)
    4.7 (18)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      solution_7.12.docx
    • attachment
      solution_7.12.xls
    • attachment
      solution_8.4.docx
    Bids(0)