Hypothesis Testing and T-Test Calculator (Excel)
An easy-to-use Excel tool for researchers and students to run common significance tests without statistical software. It covers: one-sample t-test independent samples t-test (Welch’s and Student’s, with an F-test for equal variances) paired samples t-test t-tests from summary statistics (means, standard deviations and sample sizes only) one- and two-sample proportion z-tests For each test it states the hypotheses, gives descriptive statistics, and calculates the test statistic, degrees of freedom, p-value, critical value, confidence interval, effect size (Cohen’s d with an interpretation) and a “Reject” or “Fail to reject” decision. It also checks assumptions (skewness, outliers, sample size) and writes a plain-language conclusion you can paste into a report or thesis. How to use: Choose the test: use the guide on the Instructions sheet to pick the right sheet. Enter your data: paste or type it into the blue columns, one value per cell. Set the options: choose the significance level (usually 0.05) and the alternative hypothesis (two-tailed unless you predicted a direction in advance). Read the results: if the p-value is below α, the result is statistically significant. Use the confidence interval and effect size to judge practical importance. Check assumptions: review the skewness, outlier and sample-size checks. Report: copy the plain-language conclusion into your report, and delete the example data before using your own.