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 2 years 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
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
- What is the potential of a cell made up of Zn|Zn2+ and Cu|Cu2+ half-cells at 25o...
ADVERTISEMENT