Back to Forms in Excel VBA archive index

Back to archive home

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.

Thanks,

Bill

Check out our Excel Resources | ||||

Try the NORMDIST function, which returns the normal cumulative distribution for the specified mean and standard deviation

example:

paste the grades in the C column and use the following formula in the D column.

+NORMDIST(C1,+AVERAGE(C:C),+STDEV(C:C),TRUE)

The A, B+, B, C+,..... grades can be generated using the following equation in the E column.

=IF(D2="","",IF(D2>=0.85,"A",IF(D2>=0.75,"B+",IF(D2>=0.55,"B",IF(D2>=0.5,"C+",IF(D2>=0.3,"C",IF(D2>=0.15,"D","F")))))))

obviously the grade limits in the last equation can be adjusted to your own needs.

Baki

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.

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.