show excel work

Q2. (40 polnts) The data shous the Sales Revenue for an erganization for $ years for each cqaater. a. Ule mutiple regression model with dummy varaibles as below to develop an cquation to accoant for seasonal effects in the data. Qur =1 if Qur 1,0 otherwise; Qur 2=1 if Q+r2,0 echerwive; Qtr3 1 if Qer5, 0 otherwise; b. Based on (a), coengute estimates for quarterly sales for ycar 6 . c. Let Period = 1 refer to observation in quaner 1 of year 1 , Period =2 refer to observation in quarter 2 of year 1 , ..Period= 20 refer bo obsenation in quarter 4 of year 5 . Based on the dummy variables defined in (a) and the variable Peried, develop at equatice to aceount for any seasonal effects and linear trend in the time series. d. Based on the seasonal effects and the lisear trend, coempute estimates for quarterty sales for year 6 . 4. Is the model in (a) os that in Yc), more effective? Gerve reason