The Hillsboro Aquatic Center has an indoor pool with lanes for lap swimming and an open area for recreational swimming and various exercise and water aerobics programs. From June to mid-August it operates on a summer schedule, and from mid-August to the end of May it operates according to normal weekday and weekend schedules. The center€™s policy for the pool is to have a lifeguard-to-patron ratio of 1:40. The center director wants to develop a forecast of pool attendance for the weekday schedule in order to determine the number of lifeguards to hire. The director believes pool attendance follows a seasonal pattern during the day and has accumulated the following data for average daily attendance for each hour of the day that the pool is open to the public (i.e., there are no swim team practices):

Develop a seasonally adjusted forecast model for these data for hourly pool attendance. Forecast attendance for each hour for year 7 by using a linear trend line estimate for pool attendance in year 7. Do the data appear to have a seasonalpattern?

Transcribed Image Text:

Year Time 3 6 7:00 А.М. 8:00 9:00 10:00 11:00 Noon 1:00 P.M 2:00 3:00 6:00 7:00 8:00 9:00 56 64 66 6072 65 31 4 37 44 52 46 15 22 24 30 19 26 34 35 38 3 28 33 45 52 55 4957 50 63 71 57 6 75 70 35 30 4 33 45 24 28 32 30 35 3:3 27 19 24 23 25 27 31 47 36 45 40 46 25 35 4 43 39 45 14 20 18 17 23 27 8 16 14 15 18 2 10