WorksheetFunction.Confidence_T Method (Excel)
Returns the confidence interval for a population mean, using a Student's t distribution.
Version Information
Version Added: Excel 2010
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 and 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 #DIV/0! error value.
If size equals 1, CONFIDENCE_T returns #DIV/0! error value.