Click here for the data to use with this assignment. Your assignment is to determine two different types of internal consistency reliability for a test or homework assignment. 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).
I have created an Excel spreadsheet for you to enter your data. The spreadsheet contains the formulas for Pearson’s r, Spearman-Brown Prophecy, KR20, and KR21. 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 ). Please record data from at least 20 students for at least 10 questions. After you have finished entering your data, check the reliability estimates at the top of the spreadsheet. Those estimates are not correct until all of the data has been entered. Enter 1 if the student answered the question correctly, and 0 if the student missed the question.
In the sample below, Student 1 correctly answered the seven questions. Student 2 missed all of the questions. Student 3 answered all but one question correctly.
|Question 1||Question 2||Question 3||Question 4||Question 5||Question 6||Question 7|
Please report the reliability estimates you found for each method (1 point each — total of 2 points). Describe what type of consistency each of the two types of reliability measure (1 point each – total of 2 points). Include an attachment of your completed Excel spreadsheet with your assignment (1 point). Warning: Only print the first page of the spreadsheet…the spreadsheet is rather long and will print hundreds of blank pages if you let it.
Scoring for this assignment will be based on the following:
• 1 point for the Spearman-Brown reliability estimate value
• 1 point for the description of what Spearman-Brown measures
• 1 point for the correct K-R value (indicate whether you did a KR 20 or KR 21
• 1 point for the description of what the KR you selected measures
• 1 point for the first page of your printout (WARNING: Do not simply print the spreadsheet—it will print hundreds of pages)