Explore BrainMass

Explore BrainMass

    Solve multiple regression

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years:

    Time Sales
    2010 Quarter 1 20
    2010 Quarter 2 85
    2010 Quarter 3 64
    2010 Quarter 4 30
    2011 Quarter 1 70
    2011 Quarter 2 125
    2011 Quarter 3 105
    2011 Quarter 4 90

    The scatter plot of the data above shows seasonality with trend. Hence, a time-series regression model with trend and seasonality should be run to forecast the demand.

    We denote sales (Y) as the depend variable, and denote time (t) and seasonality dummy variables (S_2, S_3, and S_4) as independent variables. Here, we choose quarter 1 as the baseline and adopt three seasonality dummy variables, such that S_2=1 represents quarter 2, S_3=1 represents quarter 3, and S_4=1 represents quarter 4. Answer the following questions. Use ?=0.05.

    Use the above variable definition to code the data above.

    Time Sales(Y) Time (t) S_2 S_3 S_4
    2010 Quarter 1 20
    2010 Quarter 2 85
    2010 Quarter 3 64
    2010 Quarter 4 30
    2011 Quarter 1 70
    2011 Quarter 2 125
    2011 Quarter 3 105
    2011 Quarter 4 90

    Copy the data into Excel and run the corresponding multiple regression. Write the estimated multiple regression equation use the variables defined above.

    Explain the meaning of the coefficients for time (t) and for seasonally dummy variable S_2. (Note: Use actual variable name and numbers to answer the questions.)

    Test the overall fitness of the model. (Clearly state the hypotheses.)

    Which variables in the current regression model are significant? And which are not significant? Justify your answer.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:47 am ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/solve-multiple-regression-479228

    Attachments

    Solution Summary

    The solution provides detailed explanation how to solve multiple regression.

    $2.19

    ADVERTISEMENT