Problem Set 3.9: Independent t Test using Excel

Criterion: Calculate an independent samples t test in Excel.

Instructions: Complete the following steps:

a.Open Excel.

b.On an empty tab, enter the data. Use column A for group 1 and column B for Group 2. In Cell A1, enter 1. In cell B1, enter 2.

independent samples t test in SPSS.

Data: Dr. Z divides her clients with depression into 2 groups. She asks Group 1 not to watch or read any news for two weeks while in therapy and asks Group 2 to continue with therapy as normal. The groups scored the following on measure of depression:

Depression Scores:

Group 1: 34, 25, 4, 64, 14, 49, 54

Group 2: 24, 78, 59, 68, 84, 79, 57

c.Enter the data for each group below the label.

d.Click Data Analysis, select t-Test: Two-Sample Assuming Equal Variances. Click OK.

e.In Variable 1 Range enter $A$2:$A$8. (Or, click the graph icon at the right of the box and highlight your data for Group 1. Then, click the graph icon.)

f.In Variable 2 Range enter $B$2:$B$8.

g.Then click OK. Your results will appear on a new tab to the left.

h.Return to your data. Click Data Analysis, select t-Test: Two-Sample Assuming Unequal Variances. Then click OK.

i.In Variable 1 Range enter $A$2:$A$8. (Or, click the graph icon at the right of the box and highlight your data for Group 1. Then, click the graph icon.)

j.In Variable 2 Range enter $B$2:$B$8.

k.Then click OK. Your results will appear on a new tab to the left.

This problem requires you to accurately enter the data into Excel following the steps provided then running the t-Test: Two-Sample Assuming Equal Variances in addition to the t-Test: Two-Sample Assuming Unequal Variances. Once you have the output, copy and paste each into the word document.