If the report will be published on November 1, 2020, which of the following months shouts the report cover?

A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales.

If the report will be published on November 1, 2020, which of the following months shouts the report cover?
A . October 1, 2019 to October 31, 2020
B . October 31, 2020 to November 1, 2021
C . November 1, 2019 to October 31, 2020
D . October 31, 2019 to October 31, 2020

View Answer

Answer: A

Explanation:

The report should cover the months from October 1, 2019 to October 31, 2020. A rolling 12-month average is a type of moving average that calculates the average of the last 12 months of data for each month. It is useful for smoothing out seasonal fluctuations and identifying long-term trends in the data. To calculate the rolling 12-month average for sales for November 1, 2020, the analyst needs to use the sales data from the previous 12 months, starting from November 1, 2019 and ending on October 31, 2020. The other options are either too short or too long to cover the required period.