Big Query

Moving Averages

Week Sales 3 MA Error |Error| Error2 |%Error|th>
139
244
340
4454144168.98%
53843-552513.16%
643412244.65%
73942-3397.69%
840Total145434.39%
MADMSEMAPE
3.513.58.60%

Forcast Error = Actual - Forcast

$$\left|\%Error\right| = \frac{\left|Error\right|}{Actutal} 100\%$$

MAD: Mean Absolute Deviation

MSE: Mean Square Error

Mean Absolute Percent Error