#26The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarterly Year 1 Year 2 Year 3 1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500 2360 2615a. What type of pattern exists in the data? Horizontal with seasonality, Upward trend, Seasonal with upward trend, Downward trend, Seasonal with downward trend, Horizontal? b. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1 - 1511.67QTR2 + 326.67QTR3 + 23.13t; what is the forecast for period 13? Round to the nearest hundredth. c. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1 - 1511.67QTR2 + 326.67QTR3 + 23.13t; what is the forecast for period 14? Round to the nearest hundredth.
#26
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow.
Quarterly Year 1 Year 2 Year 3
1 1690 1800 1850
2 940 900 1100
3 2625 2900 2930
4 2500 2360 2615
a. What type of pattern exists in the data? Horizontal with seasonality, Upward trend, Seasonal with upward trend, Downward trend, Seasonal with downward trend, Horizontal?
b.
c. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1 - 1511.67QTR2 + 326.67QTR3 + 23.13t; what is the forecast for period 14? Round to the nearest hundredth.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
