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). LetX₁represent a dummy for first quarters. LetX₂represent a dummy for second quarters. LetX₃represent 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+_______ X₁+_______ X₂+________ X₃

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,X₁is a dummy for first quarters,X₂is a dummy for second quarters, andX₃is 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+________ X₁+________ X₂+________ X₃

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