A hospital records the number of floral deliveries its patients receive each day

profiletutor4helpyou
 (Not rated)
 (Not rated)
Chat

Question 1

           A hospital records the number of floral deliveries its patients receive each day.  For a two week period (14 days), the records show:                               

      Day 1     25

       Day 2     37

       Day 3     36

        Day 4    34

        Day 5     38

       Day 6     31

        Day 7     36

        Day 8     29

        Day 9     25

       Day 10   38

       Day 11    35

      Day 12   36

      Day 13   27

      Day 14   33

             Use exponential smoothing with a smoothing constant of .35 to forecast the number of deliveries. (Be sure to provide a forecast for day fifteen, the point of the whole exercise)

Question 2

In order to forecast the attendance at an annual tennis tournament, a model has been developed which uses attendance from the previous year and the amount spent for advertising this year. From the years shown in the table, forecast the attendance for years 2-5 and calculate the forecast error using the following multiple regression model: 

            Attendance = 6000 + .3($) + .2 (Attlag) 

            Note: ‘Attlag’ means last-year’s actual attendance. So in forecasting the second year’s attendance, we’d use the first year’s actual attendance value, and so forth.  

 

Year

 

Attendance

Advertising Expenditure

 

Forecast

 

Error

1

  7363

 1750

 

 

2

  8426

2250

 

 

3

  8318

4200

 

 

4

 9206

5500

 

 

5

 9918

6600

 

 

 

Question 3

The following table shows the annual maintenance costs for several cars, as well as their age. 

age of car

annual expenses ($)

1

100

2

375

2

325

3

455

3

520

4

485

4

530

5

595

5

515

6

700

6

800

7

1000

7

950

What would a regression model that relates maintenance costs (dependant variable) as a function of age (independent variable) predict the annual cost of maintaining an eight-year-old car to be? 

 

    • 12 years ago
    A hospital records the number of floral deliveries its patients receive each day
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      data.xlsx
    • attachment
      answer.docx