Excel Functions Tutorials
- Statistical Function in Excel
- AVERAGE Excel Function
- Average Formula in Excel
- AverageIF in Excel
- AVERAGEIFS Function in Excel
- CORREL Excel Function
- Correlation Matrix in Excel
- Correlation vs Covariance
- COUNT Excel Function
- Count Formula in Excel
- COUNTA Excel Function
- COUNTIF Excel Function
- COUNTIF Formula in Excel
- COUNTIFS Function in Excel
- COUNTIF with Multiple Criteria
- COUNTIF Examples
- FORECAST Excel Function
- Forecast Formula in Excel
- FREQUENCY Excel Function
- Frequency Formula in Excel
- GROWTH Excel Function
- Growth Formula in Excel
- LARGE Excel Function
- LINEST Excel Function
- Linear Regression in Excel
- Lognormal Distribution in Excel
- MAX Excel Function
- Max Excel Formula
- Mean vs Median
- MEDIAN Excel Function
- MEDIAN Formula in Excel
- MIN in Excel
- MODE Excel Function
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- PERCENTILE Excel Function
- Percentile Formula in Excel
- Percentile Rank Formula
- Poisson Distribution in Excel
- P-Value in Excel
- QUARTILE Excel Function
- RANK Function in Excel
- SLOPE Function in Excel
- SMALL Function in Excel
- Standard Deviation in Excel
- Standard Deviation Formula in Excel
- TREND Function in Excel
- T-TEST in Excel
- Chi Square Test in Excel
- Variance vs Standard Deviation
- Weibull Distribution in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
TTest Function in Excel (Table of Contents)
T-TEST in Excel
TTEST function is categorized as a Statistical function in Excel. In mathematical term, the TTEST function in excel will calculate the probability that is associated with a Student’s T-Test. This function is usually used to test the probability of two samples have underlying populations with the same mean.
T-TEST Formula in Excel
Below is the T-Test Formula in Excel
Details of Parameters:
T-TEST in excel has the following required parameters i.e. array1, array2, tails and type.
- array1: it is the first data set.
- array2: it is the second data set.
- Tails: Tails specifies the number of distribution tails. If tails = 1, T-TEST uses the one-tailed distribution. If tails = 2, TTEST uses the two-tailed distribution.
- Type: Type is the kind of t-test to perform.
- Two-sample equal variance (homoscedastic)
- Two-sample unequal variance (heteroscedastic)
How to Use the TTEST Function in Excel?
T-Test in excel is very simple and easy to use. Let understand the working of TTEST function in excel by some examples. TTEST function can be used as a worksheet function and as VBA function.
TTEST function as a worksheet function.
T-Test in Excel Example #1
Suppose have given the following expenses data spent in India and in the US. The probability associated with the Student’s paired t-test with a 1-tailed distribution for the two arrays of data below can be calculated using the Excel function.
The T-Test formula in excel used is as follows: =TTEST(A4:A24,B4:B24,1,1)
The output will be 0.177639611.
T-TEST in Excel Example #2
A marketing research firm tests the effectiveness of a new flavoring for a leading beverage using a sample of 21 people, half of whom taste the beverage with the old flavoring and the other half who taste the beverage with the new flavoring.
Two-sample equal variance (homoscedastic) is calculated by the following T-Test formula in Excel =TTEST(A31:A51,B31:B51,1,2)
The output will be 0.454691996.
T-TEST in Excel Example #3
To investigate the effect of a new fever drug on driving skills, a researcher studies 21 individuals with fever. All participants then entered a simulator and were given a driving test which assigned a score to each driver as summarized in the below table.
Two-sample unequal variance (heteroscedastic) can be calculated by Excel TTest function by replacing the type to 3 =TTEST(A57:A77,B57:B77,1,3)
The output will be 0.364848284.
T-TEST in Excel can be used as a VBA function.
Suppose we have the data sets located in the excel sheet range from A4 to A24 and B4 to B24, then we can calculate the TTEST of the given datasets by using the below VBA functions.
Sub TTESTcal() // start the TTEST function scope
Dim TTEST as interger
TTEST = Application.WorksheetFunction.TTest(Range(“A4:A24”),Range(“B4:B24”),1,1)
MsgBox TTEST // print the TTEST value in message box.
End sub // End the TTEST function
Things to Remember about the TTEST Function in Excel
- TTest function through the #N/A Error if the two supplied arrays have different lengths.
- The tails and type parameters are truncated to integers.
- T-Test in excel returns #Value! Error if either the provided tails parameter or the provided type parameter is non-numeric.
- T-Test in excel returns #NUM! Error if-
- The supplied tails parameter has any value other than 1 or 2.
- The supplied type parameter is not equal to 1, 2 or 3.
T-TEST in Excel Video
This has been a guide to TTEST Function in Excel. Here we discuss the T-TEST Formula in excel and how to use TTEST function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –
- Z Test Formula
- Explanation of the Quartile Formula in Statistics
- VBA Worksheet Function
- Mode Formula Excel
- VBA “MsgBox”
- How to use “Not Equal ” to operator in Excel Formula?
- Excel Print
- Arrays in VBA Excel
- QUARTILE in Excel
- MODE in Excel
- FREQUENCY in Excel
- CORREL in Excel