A total of 20 amounts are entered on a spreadsheet that has : GMAT Data Sufficiency (DS)
Check GMAT Club App Tracker for the Latest School Decision Releases http://gmatclub.com/AppTrack

 It is currently 02 Dec 2016, 16:33

### GMAT Club Daily Prep

#### Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History

# Events & Promotions

###### Events & Promotions in June
Open Detailed Calendar

# A total of 20 amounts are entered on a spreadsheet that has

Author Message
TAGS:

### Hide Tags

Intern
Joined: 17 Oct 2011
Posts: 27
Location: Taiwan
GMAT 1: 590 Q39 V34
GMAT 2: 680 Q47 V35
Followers: 0

Kudos [?]: 48 [0], given: 10

A total of 20 amounts are entered on a spreadsheet that has [#permalink]

### Show Tags

02 Mar 2012, 02:54
4
This post was
BOOKMARKED
00:00

Difficulty:

25% (medium)

Question Stats:

75% (02:07) correct 25% (01:21) wrong based on 168 sessions

### HideShow timer Statistics

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
[Reveal] Spoiler: OA
Math Expert
Joined: 02 Sep 2009
Posts: 35837
Followers: 6827

Kudos [?]: 89647 [6] , given: 10380

Re: What is the average of all 20 amounts on the spreadsheet? [#permalink]

### Show Tags

02 Mar 2012, 03:11
6
KUDOS
Expert's post
1
This post was
BOOKMARKED
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?

X--X--X--X --> R1
X--X--X--X --> R2
X--X--X--X --> R3
X--X--X--X --> R4
X--X--X--X --> R5
__________
C1-C2-C3-C4

(1) R1 + R2 + R3 + R4 + R5 = 550 --> since R1 is the average of row 1, then the sum of the numbers in row 1 is R1*4, the sum of the numbers in row 2 is R2*4, and so on. Hence the sum of all 20 numbers is 4*(R1 + R2 + R3 + R4 + R5)=4*550 --> the average of all 20 numbers is (average)=(sum)/(# of terms)=(4*550)/20=110. Sufficient.

(2) C1 + C2 + C3 + C4 = 440. The same logic here: the sum of the numbers in column 1 is C1*5, the sum of the numbers in column 2 is C2*5, and so on. Hence the sum of all 20 numbers is 5*(C1 + C2 + C3 + C4 )=5*440 --> the average of all 20 numbers is (average)=(sum)/(# of terms)=(5*440)/20=110. Sufficient.

Hope it's clear.
_________________
Math Expert
Joined: 02 Sep 2009
Posts: 35837
Followers: 6827

Kudos [?]: 89647 [0], given: 10380

Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]

### Show Tags

27 May 2013, 04:31
Bumping for review and further discussion.
_________________
GMAT Club Legend
Joined: 09 Sep 2013
Posts: 12836
Followers: 559

Kudos [?]: 157 [0], given: 0

Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]

### Show Tags

28 Aug 2014, 10:03
Hello from the GMAT Club BumpBot!

Thanks to another GMAT Club member, I have just discovered this valuable topic, yet it had no discussion for over a year. I am now bumping it up - doing my job. I think you may find it valuable (esp those replies with Kudos).

Want to see all other topics I dig out? Follow me (click follow button on profile). You will receive a summary of all topics I bump in your profile area as well as via email.
_________________
Intern
Joined: 19 Aug 2014
Posts: 15
Followers: 0

Kudos [?]: 2 [0], given: 122

A total of 20 amounts are entered on a spreadsheet that has [#permalink]

### Show Tags

05 Sep 2014, 22:25
Is this really sub-600? It feels a bit more abstract.
GMAT Club Legend
Joined: 09 Sep 2013
Posts: 12836
Followers: 559

Kudos [?]: 157 [0], given: 0

Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]

### Show Tags

06 Dec 2015, 10:40
Hello from the GMAT Club BumpBot!

Thanks to another GMAT Club member, I have just discovered this valuable topic, yet it had no discussion for over a year. I am now bumping it up - doing my job. I think you may find it valuable (esp those replies with Kudos).

Want to see all other topics I dig out? Follow me (click follow button on profile). You will receive a summary of all topics I bump in your profile area as well as via email.
_________________
Intern
Joined: 06 Oct 2015
Posts: 1
Followers: 0

Kudos [?]: 0 [0], given: 14

Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]

### Show Tags

06 Dec 2015, 11:06
Can you explain how this particular part contributes to solving this problem: 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).?

I don't understand how it relates to the problem as a whole, so I had trouble interpreting both statements. I couldn't reconcile the numbers because I didn't understand what exactly 550 and 440 represented. For example, I read Statement I as giving the sum total of all 5 rows (with 110 as the average sum of each row), which I realized can't be the case once I got to Statement II.

Thanks!
Re: A total of 20 amounts are entered on a spreadsheet that has   [#permalink] 06 Dec 2015, 11:06
Similar topics Replies Last post
Similar
Topics:
The total amount that a certain bank loaned in 1998 was \$47 million. 3 16 Aug 2016, 02:17
What was the total amount John earned on his two investments? 4 08 Jul 2016, 06:57
2 The total amount that John paid at a certain restaurant 1 26 Sep 2015, 11:56
5 What was the total amount of revenue that a theater received 4 14 Dec 2012, 08:16
11 A certain bank has ten branches. What is the total amount of 6 18 Nov 2011, 13:00
Display posts from previous: Sort by