Solved on Jan 18, 2024
Calculate the 7-point moving average (MA) value for on the Saturday of week 2.
STEP 1
Assumptions
1. The 7-point moving average (MA) is calculated by taking the average of 7 consecutive data points.
2. The value for on a given day is the average of the number of calls for the 3 days before, the day itself, and the 3 days after.
3. The value for that we need to calculate corresponds to the Saturday of week 2.
STEP 2
Identify the days that will be used to calculate the 7-point MA for the Saturday of week 2.
The days are: Sunday of week 1, Monday of week 1, Tuesday of week 1, Wednesday of week 1, Thursday of week 1, Friday of week 1, and Saturday of week 1.
STEP 3
Extract the number of calls to the IT Department for each of the identified days.
Sunday of week 1: 50 calls
Monday of week 1: 1000 calls
Tuesday of week 1: 700 calls
Wednesday of week 1: 400 calls
Thursday of week 1: 400 calls
Friday of week 1: 300 calls
Saturday of week 1: 100 calls
STEP 4
Calculate the sum of the number of calls for the 7 days identified.
STEP 5
Compute the sum of the calls.
STEP 6
Divide the sum of calls by 7 to find the 7-point MA for the Saturday of week 2.
STEP 7
Plug in the sum of calls into the formula to calculate .
STEP 8
Calculate the value of .
The value for that corresponds to the Saturday of week 2 is 421.43.
Was this helpful?