The attached spreadsheet shows counts of daily customers (27 days) at a Jiffy Lube. Data We'd...

Transcribed Image Text:

The attached spreadsheet shows counts of daily customers (27 days) at a Jiffy Lube. Data We'd like to use it to forecast traffic in the near future. Generate an exponentially-smoothed series (W=.6). What are the 4th number in the exponentially smoothed series and the forecast for peirod 28? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 34 61 45 29 37 38 53 44 45 41 38 55 57 45 45 24 49 45 35 31 54 45 41 36 D m LU 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 55 57 45 45 24 49 45 35 31 54 45 41 36 45 31 18 D The attached spreadsheet shows counts of daily customers (27 days) at a Jiffy Lube. Data We'd like to use it to forecast traffic in the near future. Generate an exponentially-smoothed series (W=.6). What are the 4th number in the exponentially smoothed series and the forecast for peirod 28? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 34 61 45 29 37 38 53 44 45 41 38 55 57 45 45 24 49 45 35 31 54 45 41 36 D m LU 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 55 57 45 45 24 49 45 35 31 54 45 41 36 45 31 18 D

Answer rating: 100% (QA)

The 4th number in t... View the full answer