CONFIDENCE.T function
Summary
Returns the confidence interval for a population mean, using a Student's t distribution
Syntax
CONFIDENCE.T(alpha,standard_dev,size)
The CONFIDENCE.T function syntax has the following arguments:
• Alpha Required. 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.
• Standard_dev Required. The population standard deviation for the data range and is assumed to be known.
• Size Required. The sample size.
• Alpha Required. 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.
• Standard_dev Required. The population standard deviation for the data range and is assumed to be known.
• Size Required. The sample size.
Example
=CONFIDENCE.T(0.05,1,50)