Edit

Share via


WorksheetFunction.Confidence_T(Double, Double, Double) Method

Definition

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

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.

Applies to