# CONFIDENCE.T

Formulas / CONFIDENCE.T
Return a confidence interval for a population mean.
`CONFIDENCE.T( alpha, standard_dev, size )`
• alpha - required argument that determines the confidence level
• standard_dev - required argument that is the population standard deviation for the data set
• size - required argument that is the sample size

## Examples

• `=CONFIDENCE.T(0.05,1,50)`

The CONFIDENCE.T function can be used to calculate the confidence interval with a given significance level, standard deviation, and sample size. This example calculates the confidence interval with a 5% significance level, a standard deviation of 1, and a sample size of 50, resulting in a value of 0.284196855.

## Summary

The CONFIDENCE.T function calculates a confidence interval for a population mean using a Student's t distribution. It requires three arguments for calculation: alpha, standard_dev and size.

• The CONFIDENCE.T function produces a confidence interval for a population mean using a Student's t distribution.
• It requires three arguments: alpha, standard_dev, and size.
• Alpha is a value that indicates the probability that the confidence interval includes the true population mean.
• Standard_dev is the sample standard deviation.
• Size is the sample size.

## Frequently Asked Questions

What is the CONFIDENCE.T function?
The CONFIDENCE.T function is used to measure the confidence in a mean. It returns the confidence interval for a mean.
What are the arguments of the CONFIDENCE.T function?
The CONFIDENCE.T function takes three arguments:
• alpha
• standard_dev
• samplesize
How does the CONFIDENCE.T function compute the confidence interval?
The arguments control how CONFIDENCE.T computes the confidence interval. Alpha is the significance level, standard_dev is the population standard deviation, and samplesize is the sample size.
What errors can be thrown by the CONFIDENCE.T function?
The CONFIDENCE.T function returns a #VALUE! error if any argument is not numerical. It throws a #NUM! error if standard_dev is negative.

## Make Better Decisions With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.

Drop CSV