### Moving average time series of company liquidations

Assignment Help Basic Statistics
##### 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.

(c) Comment on the pattern of company liquidations over this time period.

### Previous Q& A

#### 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..

#### Health care system and absorbs a significant portion

The insurance industry plays a major role in the American health care system and absorbs a significant portion of the health care dollar. A single payer system, whether it is a private company or the U. S. government, would eliminate the complex insu..

#### What is the common-size percentage for the net income

Foreign Travel Services has net income of \$48.400. total assets of \$219,000. total equity of \$154800, and total sales of \$311,700. What is the common-size percentage for the net income? Healthy Foods has total assets of \$129,800, net fixed assets of ..

#### Actual average settlement time

Estimate, with 95% confidence, the actual average settlement time (in days) for claims received by the Explorer Fund only. Interpret the result.

#### Implemented on an individual and a business scale

Explain, with an example, how eco-efficiency can be implemented on an individual and a business scale.

#### Calculate the mean poverty rate for gender on pei

The Canadian council of social development (CCSD) has the following poverty information on males and females in PEI, Calculate the mean poverty rate for gender on PEI. Calculate the median poverty rate for gender on PEI

#### What characteristics make diversity training most effective

Discuss what characteristics make diversity training most effective along with at least three different approaches to diversity training.

### Similar Q& A

#### Multiple least square regression equation

From her district, consisting of several hundred stores, she selects a random sample of 30 stores. For each store she gathered the following information.

#### Seamstress performing at an acceptable quality level

A sample has just been taken with the following lengths: 21.25, 22.0, 21.5, 20.75, 21.25, 21.35, 21.35, 21.35, 21.35, 21.35, 21.35, and 21.35. Is the new seamstress performing at an acceptable quality level?

#### Warrant rejection of the null hypothesis

Suppose that you perform a significance test regarding a population mean and that the evidence does not warrant rejection of the null hypothesis.

#### Approximate mean for the sample proportions

The instructor plans to draw a histogram of the 1,100 sample proportions. What will be the approximate mean for the 1,100 sample proportions?

#### Expression for the expected utility of the payment

Assume that you only receive 210 dollars if any number greater than or equal to ten tosses are required to obtain the first head. Show that your expected value for this modified game is finite and find its value.

#### Find probability of guessing exactly three answers correctly

Find the probability of guessing (a) exactly three answers correctly, (b) at least three answers correctly, and (c) less than three answers correctly.

#### Find the p-value for a test of the manufacturers claim

A manufacturer claims that fewer than 6% of its fax machines are defective. In a random sample of 97 such fax machines, 4% are defective. Find the P-value for a test of the manufacturer's claim.

#### Find standard deviation of the probability distribution

0.8 of all college students like the idea of a new curriculum. If we select 87 students (ASSUME INDEPENDENCE), what is the Standard Deviation of the Probability Distribution that would list the number of students.

#### Outliers on the dependent variables

Did you find any outliers on the dependent variables that were due to errors of coding? If so, what and why? How would you correct an error of coding?

#### Probability that two patients have genetic disorder

The probability of having a particular genetic disorder is 0.004. If 25 patients are tested for this disorder, what is the probability that 2 of them have this disorder?

#### Confidence interval for the proportion-type of discomfort

Construct a 95% confidence interval for the proportion of all those who experience some type of discomfort.

#### A random sample of six cars from a particular model has the

a random sample of six cars from a particular model has the following fuel consumption figure in miles per gallon 18 16

#### Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!