Advanced Excel Statistical Analysis

Project 3 Analysis in Excel Instructions
Table of Contents
1. Independent Samples t-test
2. Repeated Measures t-test
3. Single Sample t-test
4. Pearson r Correlation
5. One-Way Analysis of Variance (ANOVA)

1. Independent Samples t-test
Objective: To determine if there is a statistically significant difference between two independent groups in behavioral science research.
Example: Comparing the average anxiety levels of participants who received a new therapy (Group A) versus those who received a placebo (Group B).
Steps:
1. Prepare Your Data:
• Organize your data with two separate columns for Group A and Group B.
2. Calculate Descriptive Statistics:
• Calculate the means and standard deviations for each group.
• Mean(Group A): =AVERAGE(GroupA)
• Mean(Group B): =AVERAGE(GroupB)
• Std Dev(Group A): =STDEV.P(GroupA)
• Std Dev(Group B): =STDEV.P(GroupB)
3. Perform the t-test:
• In an empty cell, enter =T.TEST(GroupA, GroupB, 2, 2) to calculate the t-test result.
4. Interpret Results:
• If p-value < 0.05, there is a statistically significant difference between the groups.

2. Repeated Measures t-test