Neco 2017 Data Processing Question 44

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

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

The following table shows monthly sales (in thousands of ₦) for three regions. Month | Region A | Region B | Region C Jan | 120 | 80 | 60 Feb | 130 | 85 | 62 Mar | 125 | 90 | 65 Apr | 140 | 95 | 68 May | 150 | 100 | 70 Jun | 155 | 105 | 73 Jul | 160 | 110 | 75 Aug | 165 | 115 | 78 Sep | 170 | 120 | 80 Oct | 175 | 125 | 82 Nov | 180 | 130 | 85 Dec | 190 | 135 | 90 Using spreadsheet formulas, determine: 1. The weighted average growth rate for the year, where each region's growth rate is weighted by its total annual sales. Express the result as a percentage to one decimal place. 2. Which region contributed the greatest absolute increase in sales from January to December?

Answer Options

A. Weighted average growth rate = 55.2%; Region B contributed the greatest increase.
B. Weighted average growth rate = 62.3%; Region C contributed the greatest increase.
Correct Answer C. Weighted average growth rate = 59.9%; Region A contributed the greatest increase.
D. Weighted average growth rate = 59.9%; Region B contributed the greatest increase.
Correct Answer
C
Correct Option:
Weighted average growth rate = 59.9%; Region A contributed the greatest increase.

About This Question

This is Neco 2017 Data Processing Question 44. 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