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.

    About Author:

    Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


    While I love having friends who agree, I only learn from those who don't.

    Let's Get Connected: Email | LinkedIn

    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