Excel Instructions: Matched Pairs
To open Excel with the data in the worksheet, click here and it will automatically download the file to your computer. Find the downloaded file (usually in the Downloads folder) and double-click it to open it in Excel.
The following Excel commands will be needed for the next questions:
Creating a column of differences:
- In column C, type the following formula in each of the cells in rows 2-12: =A1-B1, adjusting the row numbers accordingly.
- Name the newly created column Differences.
Carrying out the paired t-test:
- In the Data tab click on the Data Analysis button. In the pop-up window, choose t-Test: Paired Two Sample for Means.
- In the next window, enter the data for column A next to Variable 1 Range and the data for column B next to Variable 2 Range.
- Click the OK button and a new sheet tab will open displaying the generated t-Test table.