CONFIDENCE.T
Formulas / CONFIDENCE.TReturn 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.
