Original and the de-seasonalised quarterly turnover

Reference no: EM13990554

The seasonal indexes and actual quarterly turnover (in R millions) for 2008, 2009 and 2010 in the hotel industry in Cape Town are as follows:

Season	Seasonal index	2008	2009	2010
Summer	136	568	604	662
Autumn	112	495	544	605
Winter	62	252	270	310
Spring	90	315	510	535

(a) De-seasonalise the hotel industry turnover data for 2008 to 2010.

(b) Plot both the original and the de-seasonalised quarterly turnover data for the Cape Town hotel industry from 2008 to 2010 on the same axis.

(d) Estimate the seasonally adjusted turnover in the Cape Town hotel industry for the summer and autumn seasons in 2011.

(e) Repeat (b) above using the Insert > Chart > Line option in Excel.

(f) Re-compute the trendline equation in (c) using Excel's Add Trendline option.

Reference no: EM13990554

Questions Cloud

What is the magnitude of the tension t in the cable : The system in the figure is in equilibrium. A concrete block of mass 225 kg hangs from the end of the uniform strut whose mass is 46.0 kg. What is the magnitude of the tension T in the cable?

Phrase implied the commission of sodomy : Sharon Yeagle was an assistant to the vice president of student affairs at Virginia Polytechnic Institute and State University (Virginia Tech). As part of her duties, Yeagle helped students participate in the Governor’s Fellows Program. She argued t..

What are the contradictions in the practice of honor killing : Explain the justification given for "honor killings" discussed by Aysan Sev'er and Gökçeçiçek Yurdakul in "Culture of Honor, Culture of Change: A Feminist Analysis of Honor Killings in Rural Turkey." What are the contradictions in the practice of ..

The anthropology department to use for displays : A wealthy former student has donated them to the Anthropology Department to use for displays and in training students. Schoolcraft's President, asks that you look at the objects and give a recommendation about what would be the ethical course of acti..

Original and the de-seasonalised quarterly turnover : De-seasonalise the hotel industry turnover data for 2008 to 2010. Plot both the original and the de-seasonalised quarterly turnover data for the Cape Town hotel industry from 2008 to 2010 on the same axis.

Carefully explain what will happen to the number of firms : Suppose that, in a perfectly competitive market at the profit-maximizing quantity, the market price is greater than average total cost. Carefully explain what will happen to the number of firms, the market supply, and the price of the good as we move..

How far have you moved the box : A 4.0 kg box is initially at rest on a smooth surface. You then push on the box with a constant 200 N force to the right. How fast is the box moving after you've been pushing for 5.0 s?

Perform a degree-of-freedom analysis for the system : Perform a degree-of-freedom analysis for the system and write the equations you would solve to calculate the values of all unknown variables on the flowchart (including the purge fraction).

Prepare a similar table for velocity with respect to time : Prepare a position time graph for all three objects and compare their motion. For time interval t=10 sec and t= 15sec, which of them moves faster. For time interval t=20sec and t=25 sec, which of the objects move slower.

User Account

All Pages