Calculating Independent Two Sample T Test : Excel Template

I developed an excel template that calculates independent two sample t test. It also writes summary report which is based on p-value. This spreadsheet can handle up to 10,000 cases.

Download link : Independent t-test

Meaning :
The independent t test allows researchers to evaluate the mean difference between two populations using the data from two separate samples.

Purpose :
The general purpose of the independent t test is to determine whether the sample mean difference obtained is a real difference between the two populations or simply the result of sampling error.

Examples :
  1. Do males and females differ in terms of their exam scores?
    1. Is diet A better than diet B for asthma patients?
    Assumptions :
    1. The two groups must be independent.
    2. The scores in each population must be normally distributed.
    3. The two populations must have equal variances.

    Interpretation :

    Check the p-value. It is the lowest level of significance at which we can reject our null hypothesis. It helps researchers determine if their hypotheses are correct.

    Suppose the p-value is 0.39, i.e. greater than 0.05 (or 5 percent), it can be concluded that we don't reject the null hypothesis at 5% significance level. That implies there is no mean difference between the two groups.

    Suppose the p-value is 0.029, i.e. less than 0.05 (or 5 percent), it can be concluded that we reject the null hypothesis at 5% significance level. That implies there is a mean difference between the two groups.
    Coursera Data Science
    Get Free Email Updates :
    *Please confirm your email address by clicking on the link sent to your Email*

    Related Posts:

    0 Response to "Calculating Independent Two Sample T Test : Excel Template"

    Post a Comment

    Next → ← Prev