Include an attachment of your completed Excel spreadsheet with your assignment (1 point). Describe what type of consistency each of the two types of reliability measure (1 point each – total of 2 points). Please report the reliability estimates you found for each method (1 point each - total of 2 points). Student 3 answered all but one question correctly. In the sample below, Student 1 correctly answered the seven questions. Enter 1 if the student answered the question correctly, and 0 if the student missed the question. Those estimates are not correct until all of the data has been entered. After you have finished entering your data, check the reliability estimates at the top of the spreadsheet. Please record data from at least 20 students for at least 10 questions. In the large blue area on the spreadsheet you will need to record the results for each question (whether students’ answered it correctly or incorrectly ). The spreadsheet contains the formulas for Pearson’s r, Spearman-Brown Prophecy, KR20, and KR21.

I have created an Excel spreadsheet for you to enter your data. The two types of internal consistency reliability to be calculated will be Spearman-Brown and KR20 or KR21 (the latter depend on whether all of the test or homework items are considered to be of equal difficulty). Your assignment is to determine two different types of internal consistency reliability for a test or homework assignment. Click here for the data to use with this assignment.

Dichotomous variable valid reliable