DA0-001 · Question #75
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…
The correct answer is C. November 1, 2019 to October 31, 2020. For a rolling 12-month average published on November 1, 2020, the report should cover the 12 full months of data immediately preceding the publication date, which is November 1, 2019, through October 31, 2020.
Question
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?
Options
- AOctober 1, 2019 to October 31, 2020
- BOctober 31, 2020 to November 1, 2021
- CNovember 1, 2019 to October 31, 2020
- DOctober 31, 2019 to October 31, 2020
How the community answered
(35 responses)- A3% (1)
- B17% (6)
- C74% (26)
- D6% (2)
Why each option
For a rolling 12-month average published on November 1, 2020, the report should cover the 12 full months of data immediately preceding the publication date, which is November 1, 2019, through October 31, 2020.
This period covers 13 months, starting from October 1, 2019, and ending October 31, 2020, which is one month too long for a 12-month rolling average.
This period extends into the future (November 2020 to November 2021), which is incorrect for calculating a historical rolling average for sales.
A rolling 12-month average includes data from the 12 complete calendar months immediately preceding the report's publication date. Since the report is published on November 1, 2020, the most recent full month available is October 2020, making the 12-month period span from November 1, 2019, to October 31, 2020, inclusive.
This period also covers 13 months by including the entirety of October 2019 and then the 12 months up to October 2020, making it too long for a 12-month rolling average.
Concept tested: Rolling period calculation for reports
Topics
Community Discussion
No community discussion yet for this question.