Excel or Google Doc for calculating reliability coefficients (KR-20)
Need an Excel Spreadsheet or Google Doc created that will calculate a few reliability coefficents for measuring question validity for closed-ended items (multiple choice exams)
The sheet will need to accept a dataset of responses from individual particpants and then calculate the validity of each one of those questions based on the particpant being correct/incorrect. If it can auto-detect the correct answer from the dataset without being typed in then all the better
I have almost built the whole thing already, but am running into problems writing the final formulas to calculate the coefficients. I am willing to send these as templates to make the job faster. I will be able to send a complete dataset to work with as well. All math involved is basic statistics - if you can type in formulas you can do this.