Question
In: Statistics and Probability
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow.
Click on the datafile logo to reference the data.
quarter year 1 year 2 year 3
1 1690 1800 1850
2 940 900 1100
3 2625 2900 2930
4 2500 2360 2615
e. Deseasonalize the time series (to 3 decimals).
| Year | Quarter | Deseasonalized Value |
| 1 | 1 | |
| 2 | ||
| 3 | ||
| 4 | ||
| 2 | 1 | |
| 2 | ||
| 3 | ||
| 4 | ||
| 3 | 1 | |
| 2 | ||
| 3 | ||
| 4 |
f. Compute the linear trend equation for the
deseasonalized data (to 1 decimal if necessary).
Deseasonalized Value =____ +____ Period
Compute the forecast sales using the linear trend equation (to 1 decimal).
| Forecast for quarter 1 | |
| Forecast for quarter 2 | |
| Forecast for quarter 3 | |
| Forecast for quarter 4 |
g. Adjust the linear trend forecasts using the adjusted seasonal indexes computed in part (c) (to the nearest whole number).
| Forecast for quarter 1 | |
| Forecast for quarter 2 | |
| Forecast for quarter 3 | |
| Forecast for quarter 4 |
Solutions
Expert Solution
(e)
The following table shows the calculations:
(f)
Using Excel, obtain the estimated regression equation:
Deseasonalized Value = 1851 + 25.1t
Input data:
The Excel Output
Quarter1: Forecast 1851 +25.1(13) = 2178.105
Quarter2: Forecast 1851 +25.1(14) =2203.272
Quarter3: Forecast 1851 + 25.1(15)=2228.440
Quarter4: Forecast 1851 +25.1(16) =2253.608
(g)
The following table shows the calculations:
orchestra answered 1 year agoRelated Solutions
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college
textbook over the past three years follow:
Year
Quarter
Sales
1
1
1690
2
940
3
2625
4
2500
2
1
1800
2
900
3
2900
4
2360
3
1
1850
2
1100
3
4
2930
2615
a. Construct a time series plot. What type of pattern exists in
the data?
b. Show the four‐quarter and centered moving average values for
this time series.
c. Compute the seasonal and...
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college
textbook over the past three years follow. Quarter Year 1 Year 2
Year 3 1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500 2360
2615
a. Construct a time series plot. What type of pattern exists in
the data?
b. Show the four-quarter and centered moving average values for
this time series.
c. Compute the seasonal and adjusted seasonal indexes for the
four quarters....
The quarterly sales data (number of book sold) for Christian book over the past three years...
The quarterly sales data (number of book sold) for Christian
book over the past three years in California follow:
Year 1
Year
2
Year 3
1690
1800
1850
940
900
1100
2625
2900
2930
2500
2360
2615
1. Construct a time series plot. What type of pattern exists in
the data? This was not shown in the WebEx example I provided. But
you can simply create this graph in Excel (Go to INSERT and look
for charts under INSERT...
The quarterly sales (number of books sold) over the past 3 years are as shown below....
The quarterly sales (number of books sold) over the past 3 years
are as shown below.
Year
Quarter
Period
Sales
1
1
1
1700
1
2
2
1000
1
3
3
2700
1
4
4
2500
2
1
5
1800
2
2
6
900
2
3
7
2900
2
4
8
2400
3
1
9
1800
3
2
10
1100
3
3
11
2900
3
4
12
2600
Construct a time series plot for this data.
Paste the time series...
QUESTION 13 Questions 13-15 The information of the numbers of copies of a college textbook sold...
QUESTION 13
Questions 13-15
The information of the numbers of copies of a college textbook
sold quarterly over the past four years was used. Since
the time series has trend and seasonal pattern, to forecast the
quarterly sales of the textbook, the following regression equation
was found: Y't = 2100 -
640Qtr1-1250Qtr2 + 312Qtr3 + 27t ,
where Qtr1t, Qtr2t, and Qtr3t are
dummy variables corresponding to Quarters 1, 2 and 3, and t = time
period.
Q13. The sales forecast...
Your finance textbook sold 48,000 copies in its first year. The publishing company expects the sales...
Your finance textbook sold 48,000 copies in its first year. The
publishing company expects the sales to grow at a rate of 23
percent each year for the next three years and by 10 percent in the
fourth year. Calculate the total number of copies that the
publisher expects to sell in years 3 and 4.
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a...
Suppose that the following are the quarterly sales data for the
past 7 years.
1.Construct a time series plot and develop linear trend equation
using the original data (with seasonal components).
2.Calculate 4-quarter moving average values for this time series
(column E).
3.Calculate centered moving average values and seasonal indexes
(column F and G).
4.Calculate seasonal indexes (column J) for the four
quarters.
5.Copy seasonal indexes (column J) to column O, and calculate
deseasonalized number sold (column P).
6.Construct a...
The number of loaves of bread sold per day by an organic bakery over the past...
The number of loaves of bread sold per day by an organic bakery
over the past five years can be treated as a random variable that
is normally distributed. This distribution has a mean of 77.5 and a
standard deviation of 14.4 loaves. Suppose a random sample of 36
days has been selected. Determine the probability that the average
number of loaves sold in the sample of days exceeds 80 loaves.
First find the standard error of the mean.
Now...
Bloomington Publishers is considering publishing five different textbooks. The maximum number of copies of each textbook...
Bloomington Publishers is considering publishing five different
textbooks. The maximum number of copies of each textbook that can
be sold, the variable cost of producing each textbook, the sales
price of each textbook, and the fixed cost of a production run for
each textbook are given in the file Prob3. For example, producing
and selling 2000 copies of book 1 yields a revenue of $80(2000) =
$160,000 but costs $80,000 + $44(2000) = $168,000. This company can
produce at most...
he following data are for calculator sales in units at an electronics store over the past...
he following data are for calculator sales in units at an
electronics store over the past nine weeks:
Week
Sales
Week
Sales
1
4444
6
5757
2
4545
7
6565
3
4646
8
5555
4
5151
9
6464
5
5757
Use trend projection with regression to forecast sales for
weeks
10minus−13.
What are the error measures (CFE, MSE,
sigmaσ,
MAD, and MAPE) for this forecasting procedure? How about
r squaredr2?
Obtain the trend projection with regression forecast for
weeks...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- An investor is considering purchasing a Treasury bond with a 20 year maturity, an 8% coupon...
- Write a program that copies the contents of one file to a destination file. This program...
- how to conduct a marketing mix for 3d crest white strips
- Is big data analytics used for service innovation at Amazon? If so, please write a brief...
- A shrink-fit process has been used to enhance the pressure carrying capacity of a cylinder. During...
- Ten-year zero coupon bonds issued by the U.S. Treasury have a face value of $1,000 and...
- The Blossom Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a...
ADVERTISEMENT