Westonci.ca connects you with experts who provide insightful answers to your questions. Join us today and start learning! Get the answers you need quickly and accurately from a dedicated community of experts on our Q&A platform. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

Calculate the five-year moving average for year 5 using the following data:

| Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
|---------------|----|----|----|----|----|----|----|----|----|
| Sales (₹) | 36 | 43 | 43 | 34 | 44 | 54 | 34 | 24 | 14 |

A. 40
B. 43.6
C. 34
D. 41.8


Sagot :

To solve for the five-year moving average against year 5 using the provided sales data, we'll follow these steps:

1. Identify the relevant years for the moving average calculation:
- Since we are calculating the moving average for year 5, we need to consider the sales data for years 3 to 7 (inclusive). This is because a five-year moving average involves the data from two years before the target year, the target year itself, and two years after the target year.

2. Extract the sales data for the relevant years:
- Year 3: ₹43
- Year 4: ₹34
- Year 5: ₹44
- Year 6: ₹54
- Year 7: ₹34

3. Sum the sales data for these five years:
[tex]\[ \text{Sum of sales} = 43 + 34 + 44 + 54 + 34 = 209 \][/tex]

4. Divide the sum of the sales by the number of years (5 years):
[tex]\[ \text{Five-year moving average} = \frac{209}{5} = 41.8 \][/tex]

Hence, the five-year moving average against year 5 is 41.8.

The correct answer is (d) 41.8.