WorksheetFunction.Confidence_T (Excel)

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

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.

Confidence_T (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblArg2 As Double: dblArg2 = 
Dim dblArg3 As Double: dblArg3 = 
Dim dblConfidence_T As Double
dblConfidence_T = WorksheetFunction.Confidence_T(Arg1:=dblArg1, Arg2:=dblArg2, Arg3:=dblArg3)

Arguments

Arg1 (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 (Double) - Standard_dev - The population standard deviation for the data range; is assumed to be known.

Arg3 (Double) - Size - The sample size.