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.

Related Functions

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.


Try out Sourcetable
Drop CSV