I need an explanation for this Statistics question to help me study.
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.
Effect Size Video
Effect Size Calculator (Cohen’s D) for T-Test
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.