Check GMAT Club Decision Tracker for the Latest School Decision Releases https://gmatclub.com/AppTrack
GMAT Club

 It is currently 23 Mar 2017, 15:37

### 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

 new topic post reply Question banks Downloads My Bookmarks Reviews Important topics
Author Message
SVP
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 17

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

### 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.
SVP
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 17

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

### 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!
VP
Joined: 24 Sep 2006
Posts: 1359
Followers: 10

Kudos [?]: 198 [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?
05 Mar 2007, 15:12

Go to page   Previous    1   2   [ 23 posts ]

Similar topics Replies Last post
Similar
Topics:
Best MS excel Training before starting Your MBA? 1 08 Dec 2016, 09:45
1 Mac vs Windows for b school? Notably Excel... 2 11 Jun 2013, 22:21
Excel 2010 - Any good books or courses? 3 27 Jun 2012, 06:55
Excel question 10 28 Mar 2008, 08:51
1 Make Me Care 28 22 May 2007, 18:27
Display posts from previous: Sort by

# Excel Hates Me

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

 Powered by phpBB © phpBB Group and phpBB SEO 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®.