A total of 20 amounts are entered on a spreadsheet that has 5 rows and 4 columns; each of the 20 positions...

This topic has expert replies
Moderator
Posts: 2246
Joined: Sun Oct 29, 2017 2:08 pm
Followed by:2 members

Timer

00:00

Your Answer

A

B

C

D

E

Global Stats

Official Guide

A total of 20 amounts are entered on a spreadsheet that has 5 rows and 4 columns; each of the 20 positions in the spreadsheet contains one amount. The average (arithmetic mean) of the amounts in row (i) is R(i) (1≤(i)≤5). The average of the amounts in column (j) is C(j) (1≤(j)≤4). What is the average of all 20 amounts on the spreadsheet?

1) R1 + R2 + R3 + R4 + R5 = 550
2) C1 + C2 + C3 + C4 = 440

OA D

GMAT/MBA Expert

User avatar
GMAT Instructor
Posts: 7243
Joined: Sat Apr 25, 2015 10:56 am
Location: Los Angeles, CA
Thanked: 43 times
Followed by:29 members

Timer

00:00

Your Answer

A

B

C

D

E

Global Stats

AAPL wrote:
Thu Mar 19, 2020 2:09 am
Official Guide

A total of 20 amounts are entered on a spreadsheet that has 5 rows and 4 columns; each of the 20 positions in the spreadsheet contains one amount. The average (arithmetic mean) of the amounts in row (i) is R(i) (1≤(i)≤5). The average of the amounts in column (j) is C(j) (1≤(j)≤4). What is the average of all 20 amounts on the spreadsheet?

1) R1 + R2 + R3 + R4 + R5 = 550
2) C1 + C2 + C3 + C4 = 440

OA D
Solution:

Question Stem Analysis:


We need to determine the average of all 20 numbers on the spreadsheet that contains 5 rows and 4 columns.

Statement One Alone:

Notice that R1 is the average of the 4 numbers in the first row, R2 is the average of the 4 numbers in the second row and so on. The sum of the 4 numbers in the first row is 4*R1, the sum of the 4 numbers in the second row is 4*R2, and so on. Therefore, the sum of all 20 numbers is:

4*R1 + 4*R2 + 4*R3 + 4*R4 + 4*R5 = 4(R1 + R2 + R3 + R4 + R5) = 4(550) = 2200

Thus, the average of the 20 numbers is 2200/20 = 110. Statement one alone is sufficient.

Statement Two Alone:

Notice that C1 is the average of the 5 numbers in the first column, C2 is the average of the 5 numbers in the second column and so on. The sum of the 5 numbers in the first column is 5*C1, the sum of the 5 numbers in the second column is 5*C2, and so on. Therefore, the sum of all 20 numbers is:

5*C1 + 5*C2 + 5*C3 + 5*C4 = 5(C1 + C2 + C3 + C4) = 5(440) = 2200

Thus, the average of the 20 numbers is 2200/20 = 110. Statement two alone is sufficient.

Answer: D

Scott Woodbury-Stewart
Founder and CEO
[email protected]

Image

See why Target Test Prep is rated 5 out of 5 stars on BEAT the GMAT. Read our reviews

ImageImage