WorksheetFunction.Confidence_T(Double, Double, Double) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 double Confidence_T(double Arg1, double Arg2, double Arg3);

public double Confidence_T (double Arg1, double Arg2, double Arg3);

Public Function Confidence_T (Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double

Parameters

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

Arg3: Double

Size - The sample size.

Returns

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.

Applies to