It is currently 19 Nov 2017, 23: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

# Excel Hates Me

Author Message
SVP
Joined: 01 Nov 2006
Posts: 1855

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

Schools: The Duke MBA, Class of 2009

### Show Tags

05 Mar 2007, 13:35
lepium wrote:
Much easier than countif, there's a macro built - into Excel for this stuff. Have you installed the Data Analysis tools? They do come with MS Excel but I recall you had to choose to have them installed at some point.

Anyway, check the attached document. After you've added the data analysis tools, choose Data analysis in the Tools menu and then input the same data I have in this example, and... voilÃ¡!

Cheers. L.

L -

Thanks for the screen shot -- that's (almost)exactly what I did! And yes, I did have to install the data analysis tools.

The one difference is that for the cell range for the bins, I had to choose C4:C12, because if I chose C5, my frequency table looked like this:

604 Frequency
614 6
624 3
634 3
644 9
654 1
664 1
674 0
More 1

Where you can see that 604 is in line with the frequency heading, rather than down a row.

When you do it your way, how many total data points do you get in your frequency table? As you can see, I am only getting 24 above. Poor pittsburgh, my excel just won't count it.

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

SVP
Joined: 01 Nov 2006
Posts: 1855

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

Schools: The Duke MBA, Class of 2009

### Show Tags

05 Mar 2007, 13:38
P.S.

Thanks all, for all of your help with this silly problem. Praet should be impressed as we really are "contributing to each other's learning".....about excel, basketball, honeymoon hotspots, etc etc.

At least this problem includes GMAT scores!

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

VP
Joined: 24 Sep 2006
Posts: 1359

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

### Show Tags

05 Mar 2007, 15:12
aaudetat wrote:
lepium wrote:
Much easier than countif, there's a macro built - into Excel for this stuff. Have you installed the Data Analysis tools? They do come with MS Excel but I recall you had to choose to have them installed at some point.

Anyway, check the attached document. After you've added the data analysis tools, choose Data analysis in the Tools menu and then input the same data I have in this example, and... voilÃ¡!

Cheers. L.

L -

Thanks for the screen shot -- that's (almost)exactly what I did! And yes, I did have to install the data analysis tools.

The one difference is that for the cell range for the bins, I had to choose C4:C12, because if I chose C5, my frequency table looked like this:

604 Frequency
614 6
624 3
634 3
644 9
654 1
664 1
674 0
More 1

Where you can see that 604 is in line with the frequency heading, rather than down a row.

When you do it your way, how many total data points do you get in your frequency table? As you can see, I am only getting 24 above. Poor pittsburgh, my excel just won't count it.

I got:
604 3
614 4
624 3
634 3
644 9
654 1
664 1
674 0
More 1

=25

Did you select B3:B27 for the data?

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

05 Mar 2007, 15:12

Go to page   Previous    1   2   [ 23 posts ]

Display posts from previous: Sort by