use the independent means t test calculation document and the mathss csv file to calculate the difference between females and males on the mathematics assessment scale scores 1
Overview
Use the Independent Means t Test Calculation document and the MathSS.csv file to calculate the difference between females and males on the mathematics assessment scale scores.
In Excel, the independent means t test is named something slightly different with one version called the Two Samples Assuming Equal Variances test and another version is called the Two Samples Assuming Unequal Variances test. If one does not know whether one has equal or unequal variances, it is safer to use the version assuming unequal variances. In a statistics class, we always test to find this fact out and select the correct version.
Here is a way to get to the program which will work for you.
If one goes to YouTube and types in independent means t test in Excel, multiple videos should appear for one’s viewing.
Independent means t test four-minute YouTube video.
https://www.youtube.com/watch?v=norKDF0MH0M
Effect Size Video
https://www.youtube.com/watch?v=OBQIKIcrAGI
Effect Size Calculator (Cohen’s D) for T-Test
https://www.socscistatistics.com/effectsize/default3.aspx
I believe the only thing you will not get out of Excel is the confidence level (CI) noted in the independent means t test documents and effect size documents. While the CI is something important to include in a real study, we will not add CI to your APA style write-up now.