How to Calculate Kappa with Excel

Written by vera leigh

Share

Tweet

Share

Email

Kappa is a measurement of the how much two variables agree with one another. Vassar College gives the example of two judges who "concur in their respective sortings of N items into k mutually exclusive categories." You can calculate kappa by inputting numbers into a Microsoft Excel spreadsheet. The written formula for kappa is as follows:

Other People Are Reading

Instructions

Enter all of your Observed Agreements in the cells of column A. Enter all of your Expected Agreements in the cells of column B. For this exercise, the observed agreement will equal 10, and the expected agreement will equal 5.

4

Click your cursor in C1. In this cell, you will perform the first part of the equation. Type the following formula:

=(A1-B1)

Your cell will be replaced with 5.

5

Click on cell D1. You will now compute the bottom part of the equation. Type the following formula:

=(1-B1)

The cell will display -4.

6

Type the last part of the equation, the division part. Type the following formula into cell E1: