Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel TRANSPOSE Function
  • How to use Excel ROW Function
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel MMULT Function
  • How to use Excel INDIRECT Function

Data Analysis Examples

  • How to perform a t-Test in Excel
  • How to count table rows in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How To Compare Two Lists in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation date in next 30 days
  • Excel Data validation require unique number
  • Excel Data validation whole percentage only
  • Excel Data validation only dates between

How to perform a t-Test in Excel

by

To test null hypothesis for unequal variance

This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal.

Steps in running a t-test in Excel

Below you can find the study hours of 6 female students and 5 male students.

H0: μ1 – μ2 = 0
H1: μ1 – μ2 ≠ 0

t-test example How to perform a t-Test in Excel

To perform a t-Test, execute the following steps.

Worked Example:   Understanding Anova in Excel

1. First, perform an F-Test to determine if the variances of the two populations are equal. This is not the case.

2. On the Data tab, in the Analysis group, click Data Analysis.

click data analysis How to perform a t-Test in Excel

Note: can’t find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

3. Select t-Test: Two-Sample Assuming Unequal Variances and click OK.

select-t-test-two-sample-assuming-unequal-variances How to perform a t-Test in Excel

Worked Example:   How To Load Analysis ToolPak in Excel

4. Click in the Variable 1 Range box and select the range A2:A7.

5. Click in the Variable 2 Range box and select the range B2:B6.

6. Click in the Hypothesized Mean Difference box and type 0 (H0: μ1 – μ2 = 0).

7. Click in the Output Range box and select cell E1.

t-test parameter How to perform a t-Test in Excel

8. Click OK.

Result:

t-test result How to perform a t-Test in Excel

Conclusion: We do a two-tail test (inequality).

lf t Stat < -t Critical two-tail or t Stat > t Critical two-tail, we reject the null hypothesis. This is not the case, -2.365 < 1.473 < 2.365.

Worked Example:   Excel Frequency Function Example

Therefore, we do not reject the null hypothesis. The observed difference between the sample means (33 – 24.8) is not convincing enough to say that the average number of study hours between female and male students differ significantly.

Post navigation

Previous Post:

Excel Ribbon: Navigation, Customizing, Collapsing and All You Need To Know

Next Post:

Understanding Cell Ranges, Auto fills, Copy/Paste, Insert Row, Column in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • DBCS function: Description, Usage, Syntax, Examples and Explanation
  • Remove leading and trailing spaces from text in one or more cells in Excel
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • MID, MIDB functions: Description, Usage, Syntax, Examples and Explanation
  • How to create email address from name in Excel
  • Get last day of month in Excel
  • Two ways to sum time over 30 minutes in Excel
  • Display Days until expiration date in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of month in Excel
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • Calculate loan interest in given year in Excel
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles