It is currently 20 Sep 2017, 00:42

Close

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
Your Progress

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

Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.

Close

Request Expert Reply

Confirm Cancel

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

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

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
TAGS:

Hide Tags

1 KUDOS received
Intern
Intern
avatar
Joined: 17 Oct 2011
Posts: 22

Kudos [?]: 69 [1], given: 10

Location: Taiwan
GMAT 1: 590 Q39 V34
GMAT 2: 680 Q47 V35
A total of 20 amounts are entered on a spreadsheet that has [#permalink]

Show Tags

New post 02 Mar 2012, 03:54
1
This post received
KUDOS
12
This post was
BOOKMARKED
00:00
A
B
C
D
E

Difficulty:

  35% (medium)

Question Stats:

74% (01:22) correct 26% (01:26) wrong based on 339 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

Kudos [?]: 69 [1], given: 10

Expert Post
7 KUDOS received
Math Expert
User avatar
V
Joined: 02 Sep 2009
Posts: 41619

Kudos [?]: 124074 [7], given: 12071

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

Show Tags

New post 02 Mar 2012, 04:11
7
This post received
KUDOS
Expert's post
3
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.

Answer: D.

Hope it's clear.
_________________

New to the Math Forum?
Please read this: Ultimate GMAT Quantitative Megathread | All You Need for Quant | PLEASE READ AND FOLLOW: 12 Rules for Posting!!!

Resources:
GMAT Math Book | Triangles | Polygons | Coordinate Geometry | Factorials | Circles | Number Theory | Remainders; 8. Overlapping Sets | PDF of Math Book; 10. Remainders | GMAT Prep Software Analysis | SEVEN SAMURAI OF 2012 (BEST DISCUSSIONS) | Tricky questions from previous years.

Collection of Questions:
PS: 1. Tough and Tricky questions; 2. Hard questions; 3. Hard questions part 2; 4. Standard deviation; 5. Tough Problem Solving Questions With Solutions; 6. Probability and Combinations Questions With Solutions; 7 Tough and tricky exponents and roots questions; 8 12 Easy Pieces (or not?); 9 Bakers' Dozen; 10 Algebra set. ,11 Mixed Questions, 12 Fresh Meat

DS: 1. DS tough questions; 2. DS tough questions part 2; 3. DS tough questions part 3; 4. DS Standard deviation; 5. Inequalities; 6. 700+ GMAT Data Sufficiency Questions With Explanations; 7 Tough and tricky exponents and roots questions; 8 The Discreet Charm of the DS; 9 Devil's Dozen!!!; 10 Number Properties set., 11 New DS set.


What are GMAT Club Tests?
Extra-hard Quant Tests with Brilliant Analytics

Kudos [?]: 124074 [7], given: 12071

GMAT Club Legend
GMAT Club Legend
User avatar
Joined: 09 Sep 2013
Posts: 17562

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

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

Show Tags

New post 28 Aug 2014, 11: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.
_________________

GMAT Books | GMAT Club Tests | Best Prices on GMAT Courses | GMAT Mobile App | Math Resources | Verbal Resources

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

GMAT Club Legend
GMAT Club Legend
User avatar
Joined: 09 Sep 2013
Posts: 17562

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

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

Show Tags

New post 06 Dec 2015, 11: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.
_________________

GMAT Books | GMAT Club Tests | Best Prices on GMAT Courses | GMAT Mobile App | Math Resources | Verbal Resources

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

Intern
Intern
avatar
Joined: 06 Oct 2015
Posts: 1

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

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

Show Tags

New post 06 Dec 2015, 12: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!

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

GMAT Club Legend
GMAT Club Legend
User avatar
Joined: 09 Sep 2013
Posts: 17562

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

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

Show Tags

New post 07 Feb 2017, 13:32
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.
_________________

GMAT Books | GMAT Club Tests | Best Prices on GMAT Courses | GMAT Mobile App | Math Resources | Verbal Resources

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

Intern
Intern
avatar
B
Joined: 11 Feb 2017
Posts: 9

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

Location: India
GMAT 1: 710 Q49 V38
GPA: 3.71
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]

Show Tags

New post 19 Feb 2017, 22:01
Bunuel wrote:
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.

Answer: D.

Hope it's clear.


Can we follow the logic that the average of the averages will give us the average of all the numbers within?

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

Intern
Intern
avatar
Joined: 01 Apr 2017
Posts: 1

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

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

Show Tags

New post 10 Apr 2017, 08:12
sfangy wrote:
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!


Hi, can anyone explain this? thanks

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

Manager
Manager
User avatar
S
Joined: 10 Apr 2015
Posts: 204

Kudos [?]: 28 [0], given: 35

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

Show Tags

New post 10 Apr 2017, 09:28
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
divide by 5. suff.
(2) C1 + C2 + C3 + C4 = 440
divide by 4.
suff.

D
_________________

In case you find my posts helpful, give me Kudos. Thank you.

Kudos [?]: 28 [0], given: 35

Manager
Manager
avatar
B
Joined: 16 Jan 2017
Posts: 64

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

GMAT 1: 620 Q46 V29
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]

Show Tags

New post 10 Apr 2017, 14:45
Yeah it definetely does not feel like a sub-600 question. But apart from being a bit abstract it doesn't require any calculations, just a certain level of reasoning. Both I and II are valid since both give you the sum of either the rows or columns, which allows us to calculate the the average.

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

Re: A total of 20 amounts are entered on a spreadsheet that has   [#permalink] 10 Apr 2017, 14:45
    Similar topics Author Replies Last post
Similar
Topics:
EXPERTS_POSTS_IN_THIS_TOPIC What was the total amount John earned on his two investments? Bunuel 4 09 Jul 2016, 01:59
What was the total amount of money Eben and Emily Kritesh 1 31 May 2017, 00:32
2 EXPERTS_POSTS_IN_THIS_TOPIC The total amount that John paid at a certain restaurant garsoltero 1 26 Sep 2015, 13:20
9 EXPERTS_POSTS_IN_THIS_TOPIC What was the total amount of revenue that a theater received Walkabout 4 23 Oct 2016, 16:20
15 A certain bank has ten branches. What is the total amount of enigma123 6 10 Nov 2016, 10:51
Display posts from previous: Sort by

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

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  


GMAT Club MBA Forum Home| About| Terms and Conditions| GMAT Club Rules| Contact| Sitemap

Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne

Kindly note that the GMAT® test is a registered trademark of the Graduate Management Admission Council®, and this site has neither been reviewed nor endorsed by GMAC®.