Explain find the seasonal index and trend line and forecast, Ask an Expert

Statistics

describe find the seasonal index and trend line and forecast it.

Quarterly billing for water usage is shown below-

	Year
Quarter	1	2	3	4
Winter	64	66	68	73
Spring	103	103	104	120
Summer	152	160	162	176
Fall	73	72	78	88

1) Find the seasonal index for each quarter.

2) Depersonalize the data.

3) Find the trend line.

4) Presume there is no cyclical component (don't forget- there IS a seasonal component). Forecast the summer billing for year 5.

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M923430

Have any Question?

Related Questions in Statistics and Probability

1i your company currently hasnbsp1000nbspparnbsp65

1 i. Your company currently has $1,000 ?par, 6.5 % coupon bonds with 10 years to maturity and a price of $1,082. If you want to issue new? 10-year coupon bonds at? par, what coupon rate do you need to? set? Assume that f ...

Question 1co6 from a random sample of 68 businesses it is

Question 1 (CO6) From a random sample of 68 businesses, it is found that the mean time that employees spend on personal issues each week is 4.9 hours with a standard deviation of 0.35 hours. What is the 95% confidence in ...

Consider a binomial probability distribution with p03

Consider a binomial probability distribution with p=0.3. Complete parts a through c below. a. Determine the probability of exactly four successes when n=5 P(4)=

Suppose that you have 5000 and you are contemplating the

Suppose that you have $5000 and you are contemplating the purchase of two investments, IBM and Walgreen's. One year from now, IBM can be sold at $ X per dollar invested, and Walgreen's can be sold for $ Y per dollar inve ...

Can you look for multicollinearity between a categorical

Can you look for multicollinearity between a categorical independent variable and a continuous dependent variable or can you only look for multicollinearity between a continuous independent variable and a continuous depe ...

In a club with 9 male and 10 female members a 4-member

In a club with 9 male and 10 female? members, a 4?-member committee will be randomly chosen. Find the probability that the committee contains at least 3 women.

1 dominos pizza is willing is willing to pay kes 250

1. Domino's pizza is willing is willing to pay Kes 250 in airtime to each person interviewed about his or likes and dislikes of types of pizza crust. Of the people interviewed, 220 liked a thin crust, 270 like a thick cr ...

Find the mean and the standard deviation of a binomial

Find the mean and the standard deviation of a Binomial Distribution with n = 65 and p = 0.32 Mean = 24; Stand. Deviation= 4.1 Mean = 20.8; Stand. Deviation= 3.76 Mean = 28; Stand. Deviation= 3.66 Mean = 21.8; Stand. Devi ...

What are the differences between the federal deficit and

What are the differences between the Federal deficit and Federal Debt? How does a government budget deficit affect the economy, specifically the unemployment rate and job creation? Identify two periods in recent history ...

How many years and months will it take 2 million to grow to

How many years (and months) will it take $2 million to grow to $5.60 million with an annual interest rate of 7 percent?

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert