Question
In: Math
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
10minus−13.
(Enter your responses rounded to two decimal places.)
|
Period |
Forecast, Bold Upper F Subscript tFt |
|
10 |
nothing |
|
11 |
nothing |
|
12 |
nothing |
|
13 |
nothing |
Obtain the error measures.
CFE: MSE: sigmaσ: MAD: MAPE:
Find the coefficient of determination (R squared)
R squared =
Solutions
Expert Solution
Trend projection with regression to forecast sales for weeks =
| t | yt | tyt | t^2 |
| 1 | 4444 | 4444 | 1 |
| 2 | 4545 | 9090 | 4 |
| 3 | 4646 | 13938 | 9 |
| 4 | 5151 | 20604 | 16 |
| 5 | 5757 | 28785 | 25 |
| 6 | 5757 | 34542 | 36 |
| 7 | 6565 | 45955 | 49 |
| 8 | 5555 | 44440 | 64 |
| 9 | 6464 | 58176 | 81 |
| total=45 | 48884 | 259974 | 285 |
b1=259.233333
=5431.5555
=5
b0=5431.5555 - 259.233333*5
b0=4135.38884
Trend Equation=
T10=6727.72184
By substituting the values, we get,
T11=6986.95514
T12= 7246.18844
T13=7505.42174
By using minitab software ,
Trend Analysis for sales
Data sales
Length 9
NMissing 0
Fitted Trend Equation=
Yt = 4135 + 259.2×t
Accuracy Measures=
MAPE 4
MAD 235
MSD 111405
milcah answered 1 year agoRelated Solutions
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10...
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week12345678910Demand20212938262937242428The forecast for weeks 2 through 10 using exponential smoothing with α = 0.50 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week12345678910Demand20212938262937242428Forecast20.0
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10...
Sales of tablet computers at Ted Glickman's electronics store
in Washington, D.C., over the past 10 weeks are shown in the
table below:
Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 28 36 26 29 35 20 25 30
a)
The forecast for weeks 2 through 10 using exponential smoothing
with alpha = 0.55 and a week 1 initial forecast of 21.0 are
(round your responses to two decimal places): Week 1 2 3...
Sales of tablet computers at Ted Glickman's electronics store in Washington,D,C., over the past 10 weeeks...
Sales of tablet computers at Ted Glickman's electronics store in Washington,D,C., over the past 10 weeeks are shown in the table below:
Week Damand
1 20
2 21
3 28
4 37
5 25
6 29
7 36
8 22
9 25
10 28
a)Forecast demand for each week, including week 10, using exponential smoothing with a=0.5 (initial forecast=20)
b)Compute the MAD
c)Compute the tracking signal
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the pas...
Sales of tablet computers at Ted Glickman's electronics store
in Washington, D.C., over the past 10 weeks are shown in the
table below:
Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 28 36 26 29 35 20 25 30 a)
The forecast for weeks 2 through 10 using exponential smoothing
with alpha = 0.55 and a week 1 initial forecast of 21.0 are
(round your responses to two decimal places): Week 1 2 3 4 5...
A researcher wishes to estimate sales per store of the Nikon D5 camera over the past...
A researcher wishes to estimate sales per store of the Nikon D5
camera over the past year at a large chain of photography stores
throughout the United States. A random and representative sample of
stores that sell this camera is to be selected to provide the
required estimates. To provide estimates of the population mean
sales per store of this model of camera, what minimum number of
stores will be necessary to sample under the following
conditions?
The estimate desired...
The following information is available for the past month for a retail store: Sales $87,000 Markups...
The following information is available for the past month for a
retail store:
Sales
$87,000
Markups
$9,000
Markdowns
$9,000
Purchases (at cost)
$38,800
Purchases (at retail)
$107,000
Beginning inventory (at cost)
$30,000
Beginning inventory (at retail)
$48,186
What is the ending inventory at cost using the conventional retail
method?
$38,870
$164,186
$78,000
$28,570
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 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....
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
- Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb
- In a two – story building, an exterior column is to be designed for a service...
ADVERTISEMENT