Purchase Solution

Solve multiple regression

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

The solution provides detailed explanation how to solve multiple regression.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Regression Models Using Excel

    PROBLEM: Using Excel where possible to generate data and analysis, solve the following: (a) Estimate a multiple regression model to explain the variation in employee salaries at Beta Technologies using all of the potential explanatory variables.

  • Regression Analysis

    411028 Statistics: Multiple regression model. Write the least squares regression equation. Please solve the exercise below: Consider the following partial computer output for a multiple regression model.

  • Purpose and interpretation of multiple regression analysis

    To solve the problem, the company applied Multiple Regression Analysis technique. Using Multiple Regression Analysis Technique, one can predict the values of dependent variables by estimating the values of independent variables.

  • Coffee Time: Multiple regression, Hypothesis testing

    53381 Coffee Time: Multiple regression, Hypothesis testing: Laura wanted to build a multiple regression model based on advertising expenditures and the company's price index. Explain the differences in using these different models.

  • Solving a regression analysis

    Solution provides detailed explanation of how to solve a regression analysis. Expert provides equations, along with explanations.

  • Advertising strategy for CoffeeTime based on hypothesis testing

    84660 Advertising strategy for CoffeeTime based on hypothesis testing Problem 1 Laura wanted to build a multiple regression model based on advertising expenditures and coffee time's price index.

  • General Statistics

    Results of multiple regression for Price Summary measures Multiple R 82% R-Square 67% Adj R-Square 54% StErr of Est $ 929 Regression coefficients Coefficient p-value Constant $ 2,135 0.0357 Speed $ 63

  • Suppose that you are interested in examining the determinant

    From your calculated partial slope coefficients and sample means, solve for the value of the intercept (a). What is the complete multiple regression equation? c.

  • Statistics: Hypothesis and Sampling

    This solution provides the assistance necessary for a student to be able to solve these various statistics questions. In order to view the solution, a Word document needs to be opened.

View More Related Solutions