Question: show excel work Q2. (40 polnts) The data shous the Sales Revenue for an erganization for $ years for each cqaater. a. Ule mutiple regression

show excel work show excel work Q2. (40 polnts) The data shous
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!