Question
Can you please help me solve the below: Quarterly sales for a department store over a six-year period are given in the fileP12_52.xlsx. a. Use
Can you please help me solve the below:
Quarterly sales for a department store over a six-year period are given in the fileP12_52.xlsx.
a.Use multiple regression to develop an equation that can be used to predict future quarterly sales. (Hint: Use dummy variables for the quarters and a time variable for the quarter number, 1 to 24.)
LetXrepresent the quarter number (1-24). LetX1represent a dummy for first quarters. LetX2represent a dummy for second quarters. LetX3represent a dummy for third quarters.
If required, round your answers to one decimal place. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)
=______ + _______ X+_______ X1+_______ X2+________ X3
b. Letting Yt be the sales during quarter t, discuss how to estimate the following equation for this series.
Yt= abt1b2x1b3x2b4x3
Here X is a quarter, X1 is a dummy for first quarters, X2 is a dummy for second quarters, and X3 is a dummy for third quarters.
c.Based on your answer in partbdevelop a model that can be used to predict the logarithm of future quarterly sales.
HereXis a quarter,X1is a dummy for first quarters,X2is a dummy for second quarters, andX3is a dummy for third quarters.
If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)
Log= ______ +______ X+________ X1+________ X2+________ X3
https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fcnow.apps.ng.cengage.com%2Filrn%2Fbooks%2Falba07h%2Fdatafile%2Fresource%2Fch12%2FP12_52.xlsx&wdOrigin=BROWSELINK
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started