Moving average time series of company liquidations

Reference no: EM13990485

The Economic Statistics Bureau has recorded the number of company liquidations over 27 time periods as follows:

Period	Liquidations	Period	Liquidations	Period	Liquidations
1	246	10	273	19	234
2	243	11	284	20	162
3	269	12	305	21	240
4	357	13	293	22	298
5	163	14	348	23	264
6	154	15	423	24	253
7	109	16	291	25	293
8	162	17	320	26	302
9	222	18	253	27	188

(a) Use Excel to compute both a three-period and a five-period moving average time series of company liquidations.

(b) Plot the original time series of company liquidations and the three-period and five-period moving average values on the same graph. Use Excel's Line graph option in the Insert > Chart tab.

Reference no: EM13990485

Questions Cloud

Construct a normal probability plot from the residuals : Construct a normal probability plot from the residuals - Calculate estimates of the main effects and does there appear to be interaction between the factors?

Difference between accommodation and assimilation : Explain in your own words the difference between accommodation and assimilation. Explain one life situation in which you found it easy to assimilate into a new situation. Explain one life situation in which you had to struggle to assimilate.

Planning for the expansion of the medical facilities : The Medical Officer of Health in charge of day clinics in the Butterworth district is planning for the expansion of the medical facilities at these clinics based on the growth in demand for the clinics' services.

Seasonally adjusted trend forecast : (a) Use Excel to develop a time series model that Hillstone can use to prepare seasonally adjusted trend forecasts of passenger vehicle tyre sales on a quarterly basis. (b) Prepare seasonally adjusted trend forecast estimates for 2012 and 2013 on a..

Moving average time series of company liquidations : (a) Use Excel to compute both a three-period and a five-period moving average time series of company liquidations. (b) Plot the original time series of company liquidations and the three-period and five-period moving average values on the same grap..

In which year would you say the team is doing better why : She wants to compare this year=s team scoring records to last year=s.Last year=s team had a standard deviation of 1.0 for goal scoring against, with a mean of 4.5. In which year would you say the team is doing better? Why

How much does she need to deposit now : Anne wants $15,000 in 5 years. If her savings account earns 6% a year, how much does she need to deposit now? a. $9,725.75 b. $11,208.87 c. $10,500 d. $12,317.51

An investment opportunity having a market price : An investment opportunity having a market price of $1,000,000 is available. You could obtain a $750,000, 25-year mortgage loan requiring equal monthly payments with interest at 7.0 percent.

Makes communications devices for military contracts : An electronics company makes communications devices for military contracts. The company just completed two contracts. The navy contract was for 2,300 devices and took 25 workers two weeks (40 hours per week) to complete. The army contract was for 5,5..

User Account

All Pages