Neco 2017 Data Processing Question 14

Practice objective / multiple choice question 14 from the 2017 Neco Data Processing examination.

Neco 2017 Data Processing Objective / Multiple Choice Hard Difficulty
Question 14 NECO • 2017 • DATA_PROCESSING • objective

Consider the following sales data (in units) for three products over four quarters: Product A: Q1 1200, Q2 1500, Q3 1300, Q4 1700 Product B: Q1 800, Q2 950, Q3 1100, Q4 1050 Product C: Q1 1400, Q2 1600, Q3 1550, Q4 1700 (a) Compute the total annual sales for each product. (b) Find the overall average quarterly sales for the company (i.e., average of the total sales of each quarter). (c) Using a conditional sum, determine the total sales of Product B in those quarters where Product C's sales exceeded 1500 units. (d) For Product A, identify the quarter that experienced the greatest increase in sales compared with the preceding quarter.

Answer Options

A. A:5700, B:3900, C:6250; Avg quarterly = 3950; Conditional B total = 2950; Greatest increase for A in Q4
B. A:5700, B:3900, C:6250; Avg quarterly = 3962.5; Conditional B total = 3000; Greatest increase for A in Q2
Correct Answer C. A:5700, B:3900, C:6250; Avg quarterly = 3962.5; Conditional B total = 3000; Greatest increase for A in Q4
D. A:5600, B:4000, C:6300; Avg quarterly = 4000; Conditional B total = 3100; Greatest increase for A in Q2
Correct Answer
C
Correct Option:
A:5700, B:3900, C:6250; Avg quarterly = 3962.5; Conditional B total = 3000; Greatest increase for A in Q4

About This Question

This is Neco 2017 Data Processing Question 14. It is one of the objective questions from the 2017 Neco Data Processing examination.

Difficulty level: Hard .

View More Neco 2017 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