Question

A large swimming pool complex in a growing area of New Zealand has both indoor
and outdoor facilities. There are higher numbers of admissions at some times of the
year, for example during the school holidays. The screenshot below shows some of
the data in a spreadsheet.

a. plot the graphs of number of admissions and moving mean. (Level 3, Sta3.2.3.7)
b. on the same graph, fit a trend line for the moving mean along with it equation.
(Level 3, Sta3.2.3.8)

2. A large swimming pool complex in a growing area of New Zealand has both indoor and outdoor facilities. There are higher numbers of admissions at some times of the year, for example during the school holidays. The screenshot below shows some of the data in a spreadsheet. B с D Time Moving period Month Number of moan soasonal number Ivear admissions (order 12 effect 1 Jul-02 4550 2 2 Aug-02 2411 3 Sep-02 3478 4 Oct-02 4611 6 5 Nov-02 3851 7 6 Dec-02 6213 4748 1465 7 Jan-03 7685 4851 2834 9 8 Feb-03 0405 4840 1559 10 9 Mar-03 3605 4856 -1251 11 10 Apr-03 5045 4895 750 12 11 May-03 3825 4900 -1115 13 12 Jun-03 3709 4970 -1201 SO 15 14 Aug-03 3349 5068 -1719 16 15 Sep-03 2605 5097 -1492 17 د- ام ور a. plot the graphs of number of admissions and moving mean. (Level 3, Sta3.2.3.7) b. on the same graph, fit a trend line for the moving mean along with it equation. (Level 3, Sta3.2.3.8)

Answer 1

(a) The graph is:

Forecasting 9000 8000 7000 6000 5000 Value 4000 3000 2000 1000 0+ T 1 3 4 5 5 7 00 N 9 10 11 12 13 14 15 Time Demand -Forecast

(b) The graph is:

Forecasting y = 36.436x + 4547.2 9000 8000 7000 6000 5000 Value 4000 3000 2000 1000 0 1 2 3 4 5 6 7 00 9 10 11 12 13 14 15 Time Demand Forecast Linear (Forecast) Linear (Forecast)