Hi- Does anyone know how to make a bell curve with Excel?
I have read up about it online but can find a solution.
See attached data.
Any help would be much appreciated.
Thanks.
Hi- Does anyone know how to make a bell curve with Excel?
I have read up about it online but can find a solution.
See attached data.
Any help would be much appreciated.
Thanks.
You can use the FREQUENCY function to bin grades.
There are some methods discussed at http://en.wikipedia.org/wiki/Bell_curve_grading. Applying the method of adding to all students' absolute scores the difference between the top student's score and the max score gives this result for your data:
See also http://www.astronomy.ohio-state.edu/...zes/curve.htmlPlease Login or Register to view this content.
Last edited by shg; 04-08-2008 at 01:15 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks