Solutions Statistics

Solution) Your company’s sales have been growing steadily over the last 17 quarters, as shown in the following

Question: Your company’s sales have been growing steadily over the last 17 quarters, as shown in the following table:

Quarter	Quantity Sales	Quarter	Quantity Sales
1	103.2	9	137.1
2	105.7	10	140.9
3	111.3	11	142.7
4	113.8	12	149.3
5	116.9	13	154.4
6	121.8	14	158.1
7	125.0	15	164.8
8	132.4	16	172.0
		17	181.3

You wish to predict the next four quarters’ sales.

a. Using regression techniques, find the linear time trend that best fits the sales data. How well does this equation fit the past data?

b. Now estimate the constant-growth equation Q = br ^t. Find the coefficients for b and r. Does this equation perform better than the linear form in part a? Explain.

c. Predict sales for the next four quarters using both equations.

Price: $2.99

See Answer: The solution consists of 3 pages
Solution Format: Word Document