Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
grading bell curvePosted by Bill on November 17, 2000 7:59 PM
I'm sure that this is a newbie question, but I can't do it! How do I take my students grades and convert them into 1. how many in each grade category (A,B+,B, etc.) and then turn that into a bell curve. I was able to do it, but with a ridiculous number of columns.
|Check out our Excel Resources
Re: grading bell curvePosted by Baki on November 20, 2000 1:49 PM
Try the NORMDIST function, which returns the normal cumulative distribution for the specified mean and standard deviation
paste the grades in the C column and use the following formula in the D column.
The A, B+, B, C+,..... grades can be generated using the following equation in the E column.
obviously the grade limits in the last equation can be adjusted to your own needs.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.