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.html![]()
----A----- --B-- --C--- -----------D----------- 1 14.2% C1: =100% - MAX(B3:B24) 2 Student Raw Adj 3 Student 3 60.0% 74.2% C3 and down: =B3 + C$1 4 Student 22 66.2% 80.4% 5 Student 6 71.0% 85.1% 6 Student 18 75.2% 89.4% 7 Student 20 75.6% 89.8% 8 Student 4 75.6% 89.8% 9 Student 21 76.3% 90.4% 10 Student 12 78.2% 92.3% 11 Student 14 78.4% 92.6% 12 Student 10 78.7% 92.8% 13 Student 19 78.8% 93.0% 14 Student 16 78.9% 93.1% 15 Student 7 79.6% 93.7% 16 Student 11 79.7% 93.9% 17 Student 13 79.9% 94.1% 18 Student 15 79.9% 94.1% 19 Student 8 80.0% 94.2% 20 Student 17 80.2% 94.3% 21 Student 5 80.4% 94.5% 22 Student 9 80.7% 94.8% 23 Student 2 82.2% 96.3% 24 Student 1 85.8% 100.0%
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