Learn how to calculate a rolling 12-month average for sales reports and answer a CompTIA DA0-001 exam question on determining the correct time period for the report.
Table of Contents
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?
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
Answer
C. November 1, 2019 to October 31, 2020
Explanation
A rolling 12-month average calculates the average value over the past 12 months from a given date. Since the report will be published on November 1, 2020, the 12-month period should end on the last day of the previous month, October 31, 2020. The starting date for the period should be exactly 12 months prior, which is November 1, 2019.
Options A and D are incorrect because they do not cover a full 12-month period. Option B is incorrect because it covers a future 12-month period rather than the past 12 months from the report’s publication date.
CompTIA DA0-001 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the CompTIA DA0-001 exam and earn CompTIA DA0-001 certification.