Using the Excel data below, and the unit resources, run a t-test and ANOVA using the following data sets:

1. Analyze and graph (bar graph) the following data using a t-test (50 points):

Effect of anti-depressant medication (IV) on depressive symptoms (DV). Numbers are depression scores for 10 patients in each group.

Experimental Group (Drug)

1. 25 2. 30 3. 22 4. 27 5. 28 6. 32 7. 20 8. 22 9. 30 10.25

Control Group (Placebo)

1. 58 2. 75 3. 66 4. 78 5. 80 6. 76 7. 75 8. 77 9. 80

10.78

2. Analyze and graph (bar graph) the following data using Analysis of Variance (ANOVA) (50 points):

Experimental Group 1 Drug: Low Dose

1. 25 2. 30 3. 22 4. 27 5. 28 6. 32 7. 20 8. 22 9. 30 10. 25

Experimental Group 2 Drug: High Dose

1. 10 2. 12 3.9 4.8 5. 10 6. 12 7. 10 8.11 9. 12

10. 9

Control Group (Placebo)

1. 58 2. 75 3. 66 4. 78 5. 80 6. 76 7. 75 8. 77 9. 80 10. 78

Requirements:

Provide your answers to the t-test and ANOVA in a Word document. Please transfer and upload the Excel data spreadsheet and statistical analysis tables you generated to a Word document, so your instructor can visualize your calculation process.