"Technology" MOST POPULAR

How to Calculate a T-Test for the Correlated Means Using Excel

104 9
• 1). Launch Microsoft Excel. Click "File," and select "Options" at the bottom of the window. Click "Add-ins" on the left slide of the window.

• 2). Click "Go" at the bottom of the screen. Check the box next to "Analysis Toolpak," then click "OK."

• 3). Enter the data for two samples in two columns in the Microsoft Excel spreadsheet. Type the name of each sample in the cell above each column to tell them apart.

• 4). Click the "Data" tab at the top of the screen, then select "Add-ins." Click "Analysis Toolpak" to launch the Microsoft Excel add-in.

• 5). Scroll to the bottom of the window in the Analysis Toolpak window, then click "T-test Paired Two Sample for Means."

• 6). Click the input field next to "Variable 1 Range" and drag the mouse over the values in the first column. The input field will display the cell range in a format such as "A2, A15," to denote a selection of all values between cells A2 and A15.

• 7). Click "Variable 2 Range," and drag the mouse over the second column to enter the sample data in the input field.

• 8). Click the input field next to "Alpha." Type in a typical value for alpha, such as "0.1," "0.05" or "0.005," depending on your level of confidence that the samples are not related. T-values that fill in the alpha region show statistical evidence of a relationship between the means.

• 9). Click "OK" to perform the T-test. Your results will appear in a new Excel worksheet. If "P" is smaller than alpha, your T-value suggests a statistical relationship between the two samples.