Average number of daily visitors to hotel shown:

Year ======= Quarter ==== Av.No Daily ====== Trend

1 -------------- 1 --------- 90 ------------ 103

-------------- 2 ---------120 ---------- 108

-------------- 3 --------- 200 ---------- 101

-------------- 4 --------- 28 ---------- 85

2 -------------- 1 -------- 22 ----------- 73

-------------- 2 -------- 60 ----------- 67

-------------- 3 -------- 164 ----------- 64

--------------- 4 -------- 16 ------- 65**

3 --------------- 1 -------- 10 --------- 71

--------------- 2 -------- 80 --------- 76

--------------- 3 ------- 192 ----------- 78

--------------- 4 ------- 25 ---------- 82

--

(i) If trend values were calculated using centred four point moving averages, show how value of 65 was calculated

(ii) estimate four quarterly (seasonal) components using ALL the given trend values

(iii) Assuming the trend is broadly linear over the three year period, estimate average number of daily visitors for each quarter of year 4[DO NOT USE REGRESSION ANALYSIS]

Thanks ( sorry for the messy presentation)

Thanks