Original data series and the de-seasonalised data

Reference no: EM13990591

The following table reports both the seasonal indexes for all national park visitors and the number of visitors to the Addo National Park, near Port Elizabeth, on a quarterly basis (in 1 000s) for 2008, 2009 and 2010.

Season	Seasonal indexes	2008	2009	2010
Summer	112	196	199	214
Autumn	94	147	152	163
Winter	88	124	132	145
Spring	106	177	190	198

Assume that the seasonal pattern of visitors to the Addo National Park follows the national profile of visitors to all national parks.

(a) Remove the influence of seasonal factors on the number of visitors to the Addo National Park for each of the periods from 2008 to 2010.

(b) Plot both the original data series and the de-seasonalised data series of the number of visitors to the Addo National Park over the three-year period on the same axis.

(d) Use Excel's Line with Marker option in the Insert > Chart tab to plot the data in (b).

Reference no: EM13990591

Questions Cloud

What was the outcome of this change situation : Resistance to change is more likely to succeed if the forces resisting the change are stronger than the forces driving the need for change. Describe some of the specific tactics that resisters could employ to thwart change efforts.

Describe the cultural differences in international business : Describe the Cultural differences in international business environments. What is the role of culture in the management of diversity and communicate across cultures. Discuss the keys for successful international management. Discussion should be appro..

Prepare a performance report for april that can be used : Prepare a performance report for April that can be used to judge Paragon's success or failure in meeting budgeted targets. Comment on your findings.

Healthcare claims using the ratio-to- moving-average method : (a) Calculate quarterly seasonal indexes for healthcare claims using the ratio-to- moving-average method. (b) Derive a trendline using the method of least squares. (c) Estimate the seasonally adjusted trend value of healthcare claims for each quarter..

Original data series and the de-seasonalised data : (a) Remove the influence of seasonal factors on the number of visitors to the Addo National Park for each of the periods from 2008 to 2010. (b) Plot both the original data series and the de-seasonalised data series of the number of visitors to the..

Analyze data and explain which would be better medication : A cold and flu study is looking at how two different medications work on sore throats and fever. Analyze the data and explain which one would be the better medication for both a sore throat and a fever

Problem regarding the price of the netron share : A share trader has a policy of selling a share if its share price drops more than one-third of its purchase price. In January, the investor bought shares in Netron (an electronics company) for 90c per share. The table below shows the price of the ..

The main purpose of the book : State as accurately as possible the author's purpose for writing the book. In other words, what motivated him/her to write it, what did he/she hope to accomplish? A strong answer will require several sentences.]

Define and describe the ethical issue : As you read in Chapter 10, global risks will continue to occur. Look at one of the risk areas (e.g., economic, environmental, geopolitical, societal, and technological) and consider a topic of future ethical consideration. Define and describe the ..

User Account

All Pages