Neco 2021 Data Processing Question 8

Practice objective / multiple choice question 8 from the 2021 Neco Data Processing examination.

Neco 2021 Data Processing Objective / Multiple Choice Hard Difficulty
Question 8 NECO • 2021 • DATA_PROCESSING • objective

The following monthly sales (in units) are recorded for three products over six months:\n\n| Month | Product X | Product Y | Product Z |\n|-------|-----------|-----------|-----------|\n| Jan | 120 | 100 | 90 |\n| Feb | 150 | 110 | 95 |\n| Mar | 130 | 115 | 85 |\n| Apr | 160 | 105 | 100 |\n| May | 140 | 120 | 110 |\n| Jun | 155 | 130 | 105 |\n\n(a) Write a single array formula that returns, for each product, the total sales for the months in which that product's sales exceed the overall average monthly sales across all products.\n(b) Using the totals obtained, identify which product has the highest such total and by how much it exceeds the next highest total.\n(c) Recommend an appropriate chart type to display these three totals and justify your choice.

Answer Options

A. Overall average ≈ 119.00 units. Totals: X = 820, Y = 260, Z = 10. Product X has the highest total, exceeding Product Y by 560 units. A line chart is appropriate because it shows trends over time.
B. Overall average ≈ 120.00 units. Totals: X = 800, Y = 300, Z = 20. Product Y has the highest total, exceeding Product X by 100 units. A stacked bar chart is appropriate because it highlights each product's contribution to the total.
C. Overall average ≈ 115.50 units. Totals: X = 870, Y = 240, Z = 5. Product X has the highest total, exceeding Product Z by 865 units. A pie chart is appropriate because it displays the proportion of each product's total.
Correct Answer D. Overall average ≈ 117.78 units. Totals: X = 855, Y = 250, Z = 0. Product X has the highest total, exceeding Product Y by 605 units. A clustered column chart is appropriate because it compares the three totals clearly.
Correct Answer
D
Correct Option:
Overall average ≈ 117.78 units. Totals: X = 855, Y = 250, Z = 0. Product X has the highest total, exceeding Product Y by 605 units. A clustered column chart is appropriate because it compares the three totals clearly.

About This Question

This is Neco 2021 Data Processing Question 8. It is one of the objective questions from the 2021 Neco Data Processing examination.

Difficulty level: Hard .

View More Neco 2021 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support