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.