Standard Deviation

Hope somebody can help me.

I was provided with an excel spreadsheet for the purpose of determining the pass mark for exams. In the spreadsheet the author has used Standard Deviation to set the pass level. I am told the pass mark by be 2 standard deviations from the mean.

However in the attached example you can see the result is meaningless.
Can anybody help with a formula or better idea?

There was good reasoning behind a lower than 50% pass mark but I think the formula needs some work.

Help the ignorant please.



TS Contributor
You can arbitrarily set the pass mark anywhere you want. Did the instructor give you some ideas on how to set it, or what criteria to set?