WorksheetFunction.Confidence_T(Double, Double, Double) Method
Definition
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
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.