Statistical - CONFIDENCE.T Function

Description

The CONFIDENCE.T function returns the confidence interval for a population mean, using a student's t distribution.

Syntax

CONFIDENCE.T (alpha,standard_dev,size)

Arguments

Argument Description Required/ Optional
Alpha

The significance level used to compute the confidence level.

The confidence level equals

100*(1 - alpha)%

In other words, an alpha of 0.05 indicates a 95 percent confidence level.

 Required
Standard_dev The population standard deviation for the data range and is assumed to be known. Required
Size The sample size. Required

Notes

  • If size is not an integer, it is truncated.

  • If size equals 1, CONFIDENCE.T returns #DIV/0! error value.

  • If size < 1, CONFIDENCE.T returns #NUM! error value.

  • If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.T returns the #NUM! error value.

  • If standard_dev ≤ 0, CONFIDENCE.T returns the #NUM! error value.

  • If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Confidence.T Function
advanced_excel_statistical_functions.htm
Advertisements