WorksheetFunction.Confidence_T Method
Returns the confidence interval for a population mean, using a Student's t distribution.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Confidence_T ( _
Arg1 As Double, _
Arg2 As Double, _
Arg3 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim returnValue As Double
returnValue = instance.Confidence_T(Arg1, _
Arg2, Arg3)
double Confidence_T(
double Arg1,
double Arg2,
double Arg3
)
Parameters
Arg1
Type: System.DoubleAlpha - 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
Type: System.DoubleStandard_dev - The population standard deviation for the data range and is assumed to be known.
Arg3
Type: System.DoubleSize - The sample size.
Return Value
Type: System.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.