CONFIDENCE.T function

The CONFIDENCE.T function in Excel calculates the confidence interval for a population mean, but it uses the t-distribution instead of the normal distribution. This is typically used when the sample size is small (usually less than 30) or when the population standard deviation is unknown. The t-distribution is more appropriate for smaller samples because it accounts for more variability.

Syntax:

CONFIDENCE.T(alpha, standard_dev, size)

Arguments:

• alpha: The significance level used to calculate the confidence level. For example, for a 95% confidence level, alpha would be 0.05 (since 1 – 0.95 = 0.05).
• standard_dev: The sample standard deviation (an estimate of the population standard deviation based on the sample).
• size: The sample size (the number of data points or observations).

How it works:

• The function uses the t-distribution to calculate the margin of error for the confidence interval.
• The result is the margin of error, and you can use it to construct the confidence interval by adding and subtracting it from the sample mean.

Example:

If you have:

• A sample standard deviation of 8,
• A sample size of 25, and
• A confidence level of 95% (so alpha = 0.05),

You would use:

=CONFIDENCE.T(0.05, 8, 25)

This will return the margin of error for the confidence interval. If, for example, the result is 3.2, and your sample mean is 50, the confidence interval would be from 46.8 to 53.2, indicating that you can be 95% confident that the true population mean lies within this range.

When to use CONFIDENCE.T:

• When the sample size is small (usually less than 30) and/or
• When the population standard deviation is unknown, and you’re estimating it from the sample.