The T-Test in Excel

A T-Test can be used to compare two means or populations.

Excel can perform an independent samples T-Test when you are comparing two independent means such as final exam scores for males versus females.

Excel can also perform a paired data (correlated data) T-Test when your data is paired, such as “pretest” and “posttest” scores for a group of people who took a given training to improve skills.

HOW TO Video Dr Ami Gates Data Analysis from Google Forms Video3of6 TTest

HOW TO Video Dr Ami Gates Data Analysis from Google Forms Video4of6 paired TTest

HOW TO Video Dr Ami Gates Using Excel Data Analysis One way ANOVA TTest and Pivot Tables