Series of company liquidations and the three-period

Assignment Help Basic Statistics

Reference no: EM13990599

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: EM13990599

Questions Cloud

What is the experimental frictional torque of the system : If the radius of the aluminum hub is 0.0150 m and its mass Is 0.0889 kg, and the radius of the disk Is 0.125 m and the mass of the disk is 0.8000 kg, then what is the theoretical moment of inertia of the combined disk/hub system? What is % differe..

What is a major concern related to the use of hiv : For an HIV vaccine to be effective, it almost certainly will have to be a live attenuated virus. What is a major concern related to the use of this type of vaccine for HIV?

Distinguish between revenue and capital expenditures : Indentify the factors that are relevant in determining the annual depreciation, and explain whether these factors are determined objectively or whether they are based on judgment.

Find the coordinates of the vertex : Find the coordinates of the vertex and indicate whether it corresponds to the maximum or the minimum of f.

Series of company liquidations and the three-period : (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..

What advice would you give cecilia about the number : What are the benefits and costs of using price data from only the previous 90 trading days? What advice would you give Cecilia about the number of data points to use?

Compute the trendline equation for annual advertising : (a) Use the least squares regression to calculate the trendline equation for advertising expenditure in the financial services sector. (b) Predict the level of advertising expenditure for the sector for 2012. (c) Use Excel to plot a line graph of a..

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.

User Account

All Pages