Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Returns the confidence interval for a population mean, using a Student's t distribution.
Syntax
expression.Confidence_T (Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | 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 | Required | Double | Standard_dev - The population standard deviation for the data range; is assumed to be known. |
| Arg3 | Required | Double | Size - The sample size. |
Return value
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 the #DIV/0! error value.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.