# Question: Consider the following time series data representing quarterly s

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

The scatter plot of the data above shows seasonality with trend. Hence, a multiple regression model is run to forecast the demand. We denote sales (Y) as the depend variable, and denote time (t, with t = 1 represent the first quarter of 2010) and dummy variables (S2, S3, and S4) as independent variables. Here, we choose quarter 1 as the baseline and adopt three seasonality dummy variables, such that S2 = 1 represents quarter 2, S3 = 1 represents quarter 3, and S4 = 1 represents quarter 4. Answer the following questions. Use α = 0.05.

a. Use the above variable definition to code the data above.

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

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

The scatter plot of the data above shows seasonality with trend. Hence, a multiple regression model is run to forecast the demand. We denote sales (Y) as the depend variable, and denote time (t, with t = 1 represent the first quarter of 2010) and dummy variables (S2, S3, and S4) as independent variables. Here, we choose quarter 1 as the baseline and adopt three seasonality dummy variables, such that S2 = 1 represents quarter 2, S3 = 1 represents quarter 3, and S4 = 1 represents quarter 4. Answer the following questions. Use α = 0.05.

a. Use the above variable definition to code the data above.

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

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

**View Solution:**## Answer to relevant Questions

Steel bars of length 11 meters arrive at a company from its supplier. The bars must be cut into smaller lengths to meet weekly demand and minimize wastage. For each bar the company must decide:(i) Whether to cut it into two ...The cost function of a certain commodity is C(x) = 78 + .16x − .0006x 2 + .000003x 3.(a) Find C ′ (100). (What does this mean?) (b) Find the total cost of producing 101 items. The bar chart, pie chart, and the Pareto diagram for the estimated green power sales by renewable energy source in 2008 are given below. Based on this information, what conclusions can you reach about the sources of green ...A property manager is interested in exploring the relationship between the same price of a residential property and the appraised land value, home value and size value. The appraiser selects a random sample of 40 properties ...An investor has two investments A and B. The investor believes that investment A is equally likely to increase by $1,000 or to decrease by $1,000 by the end of the year. The investor also believes that investment B is ...Post your question