Statistics for exam pass rate

[sallan]

Hi All


I am trying to work out how to produce a model that allows me to find optimum sample rate to show a reliable pass rate. This one shows a fixed sample of 25% regardless of pass wanted:


90% pass rate from 25% Exemplar

75% pass rate from 25% Gold

50% pass rate from 25% Silver

40% pass rate from 25% Bronze


Or should it look like this where my sample rate varies:


Size of org Up to 250 251 - 500 501 - 1,000

90% pass rate from 40% 90% pass rate from 35% 90% pass rate from 30%

 

[inbp]

Hi Sallan,


can you share you data file? it may be dummy file.

 

[sallan]

How do I do that?

 

[vasim]

Hi Sallan, if you click on forums home above, you can find a sticky post "Posting a sample workbook"....


please use it....

 

[sallan]

Here it is


One file is as per my comments above and the other is an example I found on the web but not too sure if it gives me what I want.


https://www.dropbox.com/s/qlsejdwp2u4m12r/Cert%20pass%20ratios%20v3.zip


Sam