Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Perform and Interpret Regression Analysis in Excel
  • How to Sort by Color in Excel
  • Excel Pie Chart
  • How to Create Area Chart in Excel
  • Filter Data Based on Date in Excel

References

  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get address of last cell in range in Excel
  • How to use Excel MMULT Function
  • How to use Excel ROWS Function
  • How to use Excel MATCH Function

Data Validations

  • Excel Data validation no punctuation
  • Excel Data validation with conditional list
  • Excel Data validation must begin with
  • Excel Data validation exists in list
  • Excel Data validation whole percentage only

How to do 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

I have Group 1 (female)  and Group 2 (male) test scores of a classroom. I need to run T.TEST to find is there a significant difference between the study hours of 6 female students and 5 male students.

Worked Example:   Excel Frequency Function Example

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

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

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

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.

Worked Example:   Understanding Anova in Excel

select-t-test-two-sample-assuming-unequal-variances How to perform a t-Test 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).

Worked Example:   How To Load Analysis ToolPak in Excel

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.

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:

SUMX2PY2 function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Everything about Charts 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

Logical Functions

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • Return blank if in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • IF with wildcards in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • Get project midpoint in Excel
  • How to calculate Quarter of Date in Excel
  • Basic Overtime Calculation Formula in Excel
  • Display Date is workday in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Basic numeric sort formula in Excel
  • Freeze and Unfreeze Panes in Excel
  • 231 Keyboard Shortcut Keys In Excel
  • How to generate random number between two numbers in Excel
  • How to calculate project complete percentage in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning