strations Question 5 Add-ins Month Sales Year 2020 1 144217 2020 2 146568 2020 3 158270 2020 4 196994 2020 5 188608 2020 6 186293 2020 7 197296 2020 8 170046 2020 9 191788 2020 10 190580 2020 11 181823 2020 12 150684 2021 1 159144 2021 2 190375 2021 3 181728 2021 4 197700 2021 5 160304 2021 6 156805 2021 7 151236 2021 8 145698 2021 9 185506 2021 10 190776 2021 11 198963 2021 12 199572 1 pts Given the forecast Data Given, Calculate the MAD (mean absolute deviation) for 2021 using a three month moving average. Question 6 1 pts Given the Forecast Data and your forecast using a three month moving average, what is the tracking signal for 2021? (remember that the tracking signal is sum of errors/MAD) Question 7 Media 1 pts Given the sales data for the spinners, graph this in Excel. (Use a line) Which possible aspect of the data is most prominent? O Trend Randomness O Seasonality Cyclicality Quiz saved at 1:42pm Submit Quiz