WorksheetFunction.Confidence_T Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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 and is assumed to be known.

Arg3

Required

Double

Size - The sample size.

Return Value

Double

  • 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 #DIV/0! error value.

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

Show: