CONFIDENCE.T Function Explained
The CONFIDENCE.T Function in Microsoft Excel calculates the confidence interval for a population mean, using a Student's t-distribution. It takes three arguments: alpha, standard_dev, and size. Alpha is the significance level used to compute the confidence level, standard_dev is the population standard deviation, and size is the sample size. The function returns the confidence interval for a population mean.
CONFIDENCE.T Function Syntax
CONFIDENCE.T(alpha,standard_dev,size)
- alpha: The significance level used to compute the confidence level. It must be a number between 0 and 1.
- standard_dev: The population standard deviation for the data range and is assumed to be known.
- size: The sample size.