Excel Function : CONFIDENCE.T

Download now!

Excel Function : CONFIDENCE.T

Category

Statistical

Description

Returns the confidence interval for a population mean, using a Student's t distribution

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CONFIDENCET-function-e8eca395-6c3a-4ba9-9003-79ccc61d3c53

Syntax and Description of the CONFIDENCE.T Excel Function

The CONFIDENCE.T function in Excel calculates the confidence interval for a population mean, using a Student’s t distribution. The function takes three arguments: 1. The alpha value, which is the significance level. This is the probability that the true population mean falls outside of the confidence interval. 2. The standard deviation of the population. 3. The number of observations in the sample.

About CONFIDENCE.T Excel Function

The CONFIDENCE.T function returns the confidence interval for a population mean, using a Student's t distribution. The confidence interval is a range of values that is likely to include a population parameter, such as a mean or proportion.