Standard Deviation

#1
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.

Nify
 

JohnM

TS Contributor
#2
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?