Number of new business registrations in gauteng region

Reference no: EM13990573

The number of new business registrations in the Gauteng region was recorded by the Department of Trade and Industries for the period 2007 to 2011.

Year	Quarter
Year	1	2	3	4
2007	1 005	1 222	1 298	1 199
2008	1 173	1 371	1 456	1 376
2009	1 314	1 531	1 605	1 530
2010	1 459	1 671	1 762	1 677
2011	1 604	1 837	1 916	1 819

Use Excel to perform the following calculations:

(a) Plot the number of new business registrations in the Gauteng region for the period 2007 to 2011.

(b) Calculate a four-period centred moving average and plot it on the same axis.

(c) Calculate quarterly seasonal indexes for new business registrations in the Gauteng region using the ratio-to-moving-average method.

(d) Are new business registrations significantly influenced by seasonal forces? Comment.

(e) Calculate the least squares trendline.

(f) Calculate the seasonally adjusted trend estimates of the number of new business registrations in the Gauteng region for the historical data (i.e. from 2007 quarter 1 to 2011 quarter 4).

(g) Plot the actual time series and the seasonally adjusted trend estimates from (f) on the same axis. How close are the two sets of time series data?

(h) Estimate the number of new business registrations in the Gauteng region for each quarter of 2012.

Reference no: EM13990573

Questions Cloud

What type of inventory management model : The Miami bookstore orders MacBook Air from Apple and then sells them to students and faculties. To provide a good customer service, it is critical for the bookstore to manage the inventory of MacBook Air well. What type of inventory management model..

What was the speed of the stone just before collision : It is observed that the stone bounces back at 10 m/s and that the block compresses the spring by 4.0 cm. You are dealing here with an inelastic collision (when total momentum is conserved) followed by a spring compression (when mechanical energy i..

Make handmade and hand-painted tables : Laura and Tyler make handmade and hand-painted tables. Their fixed costs for equipment and workspace are $70 per week. The variable cost per table in wood, paint, and other materials is $36. They believe they can sell the tables for $45 each. What is..

Number of new business registrations in gauteng region : The number of new business registrations in the Gauteng region was recorded by the Department of Trade and Industries for the period 2007 to 2011.

What price will the profit maximizing monopolist charge : What would be the value of consumer surplus if the market were perfectly competitive? What is the value of the dead weight loss when the market is a monopoly?

What is the break-even volume for the company : Ioana's Candles produces candles. The fixed monthly production cost is $3,000 and the variable cost per candle is $2.50. The candles sell for $6.25 a piece. What is the break-even volume for the company? What is the total cost, revenue, and profit fo..

What rate will the water escape : Water flows at a rate of 50 mL/s through an opening at the bottom of the of a tank in which the water is 4 m deep. At what rate will the water escape if additional pressure of 50 kPa is applied to the top of the water?

Give an explanation which theory : Give an explanation which theory is better about why Giza pyramid was built?

User Account

All Pages