Trend Model: Demand 313 0.2364 (Month) Period 1 Forecast Error Sq Error Exponential Smoothing: a 0.4 1 Period Forecast 313.24 10.76 115.86 Error Sq Error #N/A #N/A #N/A 3-period Moving Average Perind 1 2 313.47 -2.47 6.11 2 324.00 -13.00 169.00 313.71 10.71 114.68 318.80 -15.80 249.64 HOLLA 313.95 0.05 0.00 312.48 1.52 2.31 312.67 314.18 8.82 77.76 5 313.09 9.91 98.25 309.33 6 314.42 -1.42 2.01 6 317.05 -4.05 16.43 313.33 7 314.65 -12.65 160.14 L 315.43 -11.43 180.41 316.67 1467 314.89 0.11 0.01 310.06 4.94 24.41 315 312.67 2.33

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter3: Functions
Section3.3: Rates Of Change And Behavior Of Graphs
Problem 1SE: Can the average rate of change of a function be constant?
icon
Related questions
Question

J 2

please help 

 
Period
Forecast
Error
Sq Error
Month
1
3
3
4
Error
Sq Error
15
6
Error
Sq Error
7
B
9
10
Trend Model: Demand= 313 0.2364 (Month)
Period
1
Forecast
Error
Sq Error
313.24
10.76
115.86
Exponential Smoothing: a 0.4
1
3-period Moving Average
Period
1
Forecast
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
5-period Moving Average
Period
1
Forecast
Demand
324
311
303
314
#N/A
#N/A
#N/A
323
313
302
315
312
326
313.47
-2.47
6.11
2
324.00
-13.00
169,00
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
2
2
313.71
-10.71.
114.68
3
318.80
-15.80
249.64
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
3
3
ASBER11
4
313.95
0.05
0.00
4
312.48
1.52
2.31
4
312.67
1.33
1.78
#N/A
#N/A
#N/A
4
53
314.18
8.82
77.76
5
313.09
9.91
98.25
5
309.33
13.67
186.78
#N/A
#N/A
#N/A
314 42
1.42
2.01
Demand
6
317.05
-4.05
16.43
6
313.33
-0.33
0.11
7
314.65
-12.65
160.14
6
315.00
-2.00
4.00
7
315.43
-1343
180.41
7
316.67
-14.67
215.11
314.89
0.11
0.01
312.80
-10.80
116.64
8
310.06
4.94
24.41
315.13
-3.33
312.67
2.33
5.44
312.04
8
311.00
4.00
16.00
-0.04
0.00
310.00
2.00
4.00
9
313.40
-1.40
1.96
10
399.00
10
Sum
935.AS
10
20.67
680.00
Sum
1.80
301.00
Transcribed Image Text:Period Forecast Error Sq Error Month 1 3 3 4 Error Sq Error 15 6 Error Sq Error 7 B 9 10 Trend Model: Demand= 313 0.2364 (Month) Period 1 Forecast Error Sq Error 313.24 10.76 115.86 Exponential Smoothing: a 0.4 1 3-period Moving Average Period 1 Forecast #N/A #N/A #N/A #N/A #N/A #N/A 5-period Moving Average Period 1 Forecast Demand 324 311 303 314 #N/A #N/A #N/A 323 313 302 315 312 326 313.47 -2.47 6.11 2 324.00 -13.00 169,00 #N/A #N/A #N/A #N/A #N/A #N/A 2 2 313.71 -10.71. 114.68 3 318.80 -15.80 249.64 #N/A #N/A #N/A #N/A #N/A #N/A 3 3 ASBER11 4 313.95 0.05 0.00 4 312.48 1.52 2.31 4 312.67 1.33 1.78 #N/A #N/A #N/A 4 53 314.18 8.82 77.76 5 313.09 9.91 98.25 5 309.33 13.67 186.78 #N/A #N/A #N/A 314 42 1.42 2.01 Demand 6 317.05 -4.05 16.43 6 313.33 -0.33 0.11 7 314.65 -12.65 160.14 6 315.00 -2.00 4.00 7 315.43 -1343 180.41 7 316.67 -14.67 215.11 314.89 0.11 0.01 312.80 -10.80 116.64 8 310.06 4.94 24.41 315.13 -3.33 312.67 2.33 5.44 312.04 8 311.00 4.00 16.00 -0.04 0.00 310.00 2.00 4.00 9 313.40 -1.40 1.96 10 399.00 10 Sum 935.AS 10 20.67 680.00 Sum 1.80 301.00
Monthly demand for boba tea at Wiley's Wily Bubble Tea is shown in the provided output. Based on the data and results, what is the MSE of the best ting model
59.95
O 103.98
O97.14
O 61.52
O None of the above
Transcribed Image Text:Monthly demand for boba tea at Wiley's Wily Bubble Tea is shown in the provided output. Based on the data and results, what is the MSE of the best ting model 59.95 O 103.98 O97.14 O 61.52 O None of the above
Expert Solution
steps

Step by step

Solved in 6 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage