Average Sales
Periods Coffee Moving Average Exponential Smoothing TREND
1 398
2 399
4 391
5 384
6 388
7 398
8 406
9 376
10 393
11 397
12 397
13 398
14 399
15 391
16 384
17 370
18 388
19 398
20 406
21 379
22 393
23 397
24 397
Data shown to the above is number of coffee cups sold per day at a convenience store.
Compute the 3 month "moving averages", "Exponential smoothing" and "Trend analysis".
Place your computations in the appropirate columns with the headings next to the original data.
Q1: What is the forecasted value for time period 23 using:
Trend:
Exponential Smoothing
Moving Average:
Q2: Insert a TREND line below using the Charts and show the equation on the chart