Excel Instructions: Using Technology with Data to Run a Hypothesis Test
To carry out the test, launch Excel with the data in the worksheet and follow the instructions below.
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.
- From the Data tab click on the Data Analysis button. In the pop-up window, choose t-Test: Two-Sample Assuming Unequal Variances.
- 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.