Edit

WorksheetFunction.Confidence_T method (Excel)

  • Article

Returns the confidence interval for a population mean, using a Student's t distribution.

Syntax

expression.Confidence_T (Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data type Description
Arg1 Required Double Alpha - The significance level used to compute the confidence level. The confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.
Arg2 Required Double Standard_dev - The population standard deviation for the data range; is assumed to be known.
Arg3 Required Double Size - The sample size.

Return value

Double

Remarks

If any argument is nonnumeric, Confidence_T returns the #VALUE! 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 size is not an integer, it is truncated.

If size equals 1, Confidence_T returns the #DIV/0! error value.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.