Mar 30 2021 09:23 PM
I've been following this guide, trying to make a bell curve based upon student's results in a level test to determine their class placement:
https://www.spreadsheetweb.com/bell-curve-in-excel/
I'd like to know if I'm doing this right (please see attached, I've created a graph based upon one dataset, the P1 class).
Once I'm confident that the graphs accurately represent the data, I'd them like to add the following two elements:
MEAN and STDEV lines to the graph, to clearly illustrate what portion of data lies where. For example:
Then (if possible) I'd like the ability to add/remove an overlay of the threshholds to visualize what portion of students are going to be placed in which class. (This is more a desireable feature more than an essential one).