T-Test: Two Sample Assuming Equal Variance Tutorial



University of Phoenix Materialt-Test: Two Sample Assuming Equal Variance TutorialStep 1: Open the psy315r8_Student_Data.xlsx file using Microsoft? Excel?.Step 2: Select the Data menu from the ribbon. Review the right side of the menu for the Data Analysis command. If you are unable to locate the Data Analysis command, follow the instructions that begin in Step 2a.If you located the Data Analysis command, advance to Step 3 of this document.2051050254000554164512192000Step 2a: Open the File menu in the ribbon and then select Options. -45133367926200Step 2b: Select Add-Ins from the menu on the left and then select Go. 546931717841002557642401712000Step 2c: Select the Analysis ToolPak checkbox and then press OK. 3810038955900Step 3: Select the Data Analysis command under the Analysis group of the Data Menu. 5511800125095002044700127000Step 4: Scroll down and select t-Test: Two Sample Assuming Equal Variances and then press OK.107950131762400264160134607600Step 5: Set the Variable 1 Range by selecting the Collapse Dialogue button next to the Variable 1 Range field.Next, select the first column of data including its label.Select the Collapse Dialog button again to return to the t-Test: Two-Sample Assuming Equal Variances menu.293052561849000450850064135000Step 6: Set the Variable 2 Range by selecting the Collapse Dialogue button next to the Variable 2 Range field.Next, select the second column of data including its label.Select the Collapse Dialog button again to return to the t-Test: Two-Sample Assuming Equal Variances menu.291401584328000Step 7: Review the Hypothesized Mean Difference field. If it is not set to 0, insert a 0 in this field..7937581280000Step 8: Check the Labels checkbox because we included labels in our data sets.-33020126619000Step 9: Set your confidence interval to the correct Alpha. A 95% confidence interval will have a 0.05 Alpha. A 90% confidence interval will have a 0.10 Alpha. 127000131699000Step 10: Designate the location where you would like the output to be displayed. Choose a cell range for the output by following similar navigation as covered in Steps 5 and 6. Select New Worksheet Ply if you would like to place your output on a new worksheet in the current file, or select New Workbook if you would like to place your output in a separate Microsoft Excel file.2765425192722500-46355233807000-52705210756500Step 11: Select OK to generate and place your output data at the location you selected. Adjust your column size as needed to view all of the data.328295048069500 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download