Last visit was: 31 Aug 2024, 17:58 It is currently 31 Aug 2024, 17:58
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
SORT BY:
Date
Tags:
Difficulty: 555-605 Level,   Statistics and Sets Problems,                                 
Show Tags
Hide Tags
User avatar
Intern
Intern
Joined: 17 Oct 2011
Posts: 9
Own Kudos [?]: 306 [173]
Given Kudos: 10
Location: Taiwan
GMAT 1: 590 Q39 V34
GMAT 2: 680 Q47 V35
Send PM
Most Helpful Reply
Math Expert
Joined: 02 Sep 2009
Posts: 95291
Own Kudos [?]: 654400 [63]
Given Kudos: 87117
Send PM
Target Test Prep Representative
Joined: 14 Oct 2015
Status:Founder & CEO
Affiliations: Target Test Prep
Posts: 19389
Own Kudos [?]: 23077 [8]
Given Kudos: 286
Location: United States (CA)
Send PM
General Discussion
Manager
Manager
Joined: 10 Apr 2015
Posts: 122
Own Kudos [?]: 92 [4]
Given Kudos: 35
GPA: 3.31
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
3
Kudos
1
Bookmarks
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
Manager
Manager
Joined: 16 Jan 2017
Posts: 55
Own Kudos [?]: 18 [0]
Given Kudos: 2
GMAT 1: 620 Q46 V29
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
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.
Intern
Intern
Joined: 09 May 2020
Posts: 2
Own Kudos [?]: 0 [0]
Given Kudos: 46
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
I am confused about what R(i) (1≤(i)≤5) here means- and how do we come to understand R1 as the sum of the nos in the first row.
Tutor
Joined: 17 Jul 2019
Posts: 1300
Own Kudos [?]: 1770 [3]
Given Kudos: 66
Location: Canada
GMAT 1: 780 Q51 V45
GMAT 2: 780 Q50 V47
GMAT 3: 770 Q50 V45
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
3
Kudos
Expert Reply
Video solution from Quant Reasoning:
Subscribe for more: https://www.youtube.com/QuantReasoning? ... irmation=1
Tutor
Joined: 27 Sep 2019
Posts: 6
Own Kudos [?]: 5 [3]
Given Kudos: 5
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
3
Kudos
Expert Reply
Simply, condition one tells you the average of each row. Knowing how many values there are within allows you to multiple that by each average and get the sum of all of the values, which tells you the average. Likewise, the average for each column gives you the sum of each one, which tells you the sum of all of the terms. Again, divide this value by 20 to get the average. The key to thinking about averages much of the time is to think merely of the sum- if you know the sum and how many numbers there are then you know the average.
Director
Director
Joined: 04 Jun 2020
Posts: 534
Own Kudos [?]: 84 [1]
Given Kudos: 623
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
1
Kudos
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.


I watched avigutman 's video on this and just wanted to gently confirm the wording.
"The average (arithmetic mean) of the amounts in row (i) is R(i) (1≤(i)≤5)." When I read this, I interrupted this to be the average of let's say Row 1 will be between 1 and 5. The average of Row 2 will be between 1 and 5. The average of Row 3 will be between 1 and 5. Why isn't this the case?
Tutor
Joined: 17 Jul 2019
Posts: 1300
Own Kudos [?]: 1770 [1]
Given Kudos: 66
Location: Canada
GMAT 1: 780 Q51 V45
GMAT 2: 780 Q50 V47
GMAT 3: 770 Q50 V45
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
1
Kudos
Expert Reply
woohoo921 wrote:
I watched avigutman 's video on this and just wanted to gently confirm the wording.
"The average (arithmetic mean) of the amounts in row (i) is R(i) (1≤(i)≤5)." When I read this, I interrupted this to be the average of let's say Row 1 will be between 1 and 5. The average of Row 2 will be between 1 and 5. The average of Row 3 will be between 1 and 5. Why isn't this the case?

woohoo921
i doesn’t represent the amount in R(i). i represents the row number. The amounts are unknown.

Posted from my mobile device
Director
Director
Joined: 04 Jun 2020
Posts: 534
Own Kudos [?]: 84 [0]
Given Kudos: 623
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
avigutman wrote:
woohoo921 wrote:
I watched avigutman 's video on this and just wanted to gently confirm the wording.
"The average (arithmetic mean) of the amounts in row (i) is R(i) (1≤(i)≤5)." When I read this, I interrupted this to be the average of let's say Row 1 will be between 1 and 5. The average of Row 2 will be between 1 and 5. The average of Row 3 will be between 1 and 5. Why isn't this the case?

woohoo921
i doesn’t represent the amount in R(i). i represents the row number. The amounts are unknown.

Posted from my mobile device


@avitgutman
Thank you! Have you come across any other official problems that use similar notation for more practice? Thanks again Avi, and Happy Holidays!
Tutor
Joined: 17 Jul 2019
Posts: 1300
Own Kudos [?]: 1770 [1]
Given Kudos: 66
Location: Canada
GMAT 1: 780 Q51 V45
GMAT 2: 780 Q50 V47
GMAT 3: 770 Q50 V45
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
1
Kudos
Expert Reply
woohoo921 wrote:
@avigutman
Thank you! Have you come across any other official problems that use similar notation for more practice? Thanks again Avi, and Happy Holidays!

I don't recall any off the top of my head, but an Excel spreadsheet uses the same notation for any formula that refers to other cells in your sheet.
Happy holidays, woohoo921!
User avatar
Non-Human User
Joined: 09 Sep 2013
Posts: 34662
Own Kudos [?]: 872 [0]
Given Kudos: 0
Send PM
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
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 Club Bot
Re: A total of 20 amounts are entered on a spreadsheet that has [#permalink]
Moderator:
Math Expert
95291 posts