(Solved): Quarterly sales for a department store over a six-year period are given in the file (see attached im ...

Quarterly sales for a department store over a six-year period are given in the file (see attached image). Run multiple regression (use all data points) 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.). Report the forecast sales in the last quarter (year 6 quarter 4)? Round your answer to the nearest integer. Q1-Data Page 1