Excel Input for Medical Supply Company (MSC) Y t X1 X2 X3 48.60 1 1 0 0 54.20 1 0 1 0 59.30 1 0 0 1 79.80 1 0 0 0 49.50 2 1 0 0 56.00 2 0 1 0 63.50 2…

Refer to “Medical Supply Company Case Study” computer printout posted at Module 1. The Medical Supply Company (MSC) is a chain of retail department stores in medical supply. The sales figures (both computer input and computer output) of the period 1996-2003 are shown in the computer printout. When t = 1 it means year 1996; when t = 2 it means year 1997; …; when t = 8 it means year 2003. Because the sales are in terms of dollars, the data are adjusted to reflect the changes in the value of dollars.  Alternatively, sales can be shown in terms of units sold whenever possible, assuming that the units do not change much over time. The data are broken down into quarters. There are three dummy variables (X1, X2 and X3). What is the value of 32nd residual?

Select one:

a. predicted sales for 4th quarter 2003 – 141.00b. 77.37 + (5.89 x 8)  c. 141.00 – predicted sales for 4th quarter 2003d. 77.37 – predicted sales for 4th quarter 2003e. predicted sales for 4th quarter 2003 – 77.37