WorksheetFunction.Confidence_T method (Excel)
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.