The town aquatic center has an indoor pool that has lanes for lap swimming and an open area for recreational swimming and water exercises. When local schools are in session from mid-August to late May, during weekdays the pool operates from 7:00 A.M. to 9:00 P.M. The center requires a lifeguard to pool user ratio of 30:1. The center director has to submit a new yearly budget to the town and wants to develop a forecast of hourly pool attendance in order to determine the number of lifeguards she€™ll have to hire in the coming year. The director believes pool attendance follows a seasonal pattern during the day and she has accumulated the following data for average daily attendance for each hour of the day that the pool is open to the public for the past six years.

Develop a seasonally adjusted forecast for these data for hourly pool attendance. Forecast average pool 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?

Year Time 7:00 AM 56 64 66 72 65 8:00 314137"5246 9:00 15 22 2430 19 26 10.00 34 35 38 3 28 33 1100 45 52 55 57 50 Noon 63 7 57 65 75 0 1:00PM 35 30 4233 45 2:00 24 28 32 30 35 33 3.00 27 223 25 27 6:00 31 3645 40 4 7:00 8:00 14 20 187 23 27 25 35 4 43 39 4 10 8 6 415 18