The Pyramids of Giza Are One of the Most Visited

question 17

Essay

The Pyramids of Giza are one of the most visited monuments in Egypt. The number of visitors per quarter has been recorded (in thousands) as shown in the accompanying table: $$\begin{array}{l}\text { Year }\\\begin{array} { | l | c c c c | } \hline \text { Quarter } & 1995 & 1996 & 1997 & 1998 \\\hline \text { Winter } & 210 & 215 & 218 & 220 \\\text { Spring } & 260 & 275 & 282 & 290 \\\text { Summer } & 480 & 490 & 505 & 525 \\\text { Autumn } & 250 & 255 & 265 & 270 \\\hline\end{array}\end{array}$$ a. Plot the time series.
b. Discuss why exponential smoothing is not recommended as a forecasting method in this case.
c. Calculate the four-quarter centred moving averages.
d. Use the moving averages computed in (c) to calculate the seasonal (quarterly) indexes.
e. Use the seasonal indexes computed in (d) to deseasonalise the original time-series data, and plot the deseasonalised time series.
f. Use regression analysis to develop the trend line.
g. Use the seasonal indexes calculated in (d) and the linear trend calculated in (f) to forecast the number of visitors in the next four quarters and describe the seasonal fluctuations in the number of visitors.

---

Definitions:

Self-Employed Individuals

Persons who operate their own businesses or work as freelancers, responsible for their taxes and often not entitled to employee benefits.

Title VII

A section of the Civil Rights Act of 1964 that makes it illegal to discriminate in employment on the grounds of race, color, religion, gender, or ethnic background.

Civil Rights Act

A significant law in the United States that prohibited discrimination on the basis of race, color, religion, sex, or national origin.

Bona Fide Occupational Qualification

A legal defense used by employers to justify discrimination based on religion, age, sex, etc., if it is reasonably necessary to the normal operation of that particular business.