Find all School-related info fast with the new School-Specific MBA Forum

It is currently 28 Aug 2014, 01:48

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.

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

Excel Hates Me

  Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
SVP
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

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

GMAT Tests User
 [#permalink] New post 05 Mar 2007, 12: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
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

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

GMAT Tests User
 [#permalink] New post 05 Mar 2007, 12: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
VP
User avatar
Joined: 24 Sep 2006
Posts: 1360
Followers: 10

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

GMAT Tests User
 [#permalink] New post 05 Mar 2007, 14: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?
  [#permalink] 05 Mar 2007, 14:12
    Similar topics Author Replies Last post
Similar
Topics:
1 Experts publish their posts in the topic I hate you gmat vaggar4 4 24 Aug 2014, 01:29
Experts publish their posts in the topic I hate the GMAT Oleg123 8 16 Jun 2010, 14:13
Excel question Bosley 10 28 Mar 2008, 07:51
Hate these News Letter! sm176811 9 23 Feb 2007, 13:48
I hate GMAT too ashuspark 5 17 Sep 2006, 05:48
Display posts from previous: Sort by

Excel Hates Me

  Question banks Downloads My Bookmarks Reviews Important topics  

Go to page   Previous    1   2   [ 23 posts ] 

Moderator: threestripes



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

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®.