ExamGecko
Question list
Search
Search

List of questions

Search

Question 71 - DA0-001 discussion

Report
Export

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
Answers
A.
October 1, 2019 to October 31, 2020
B.
October 31, 2020 to November 1, 2021
Answers
B.
October 31, 2020 to November 1, 2021
C.
November 1, 2019 to October 31, 2020
Answers
C.
November 1, 2019 to October 31, 2020
D.
October 31, 2019 to October 31, 2020
Answers
D.
October 31, 2019 to October 31, 2020
Suggested 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.

asked 02/10/2024
Christopher Adams
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first