O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CONFIDENCE.T()

Syntax. CONFIDENCE.T(alpha,standard_dev,size)

Definition. This function returns the confidence interval for the expected value of a random variable by using a Student’s t-test.

Arguments

  • alpha (required). The probability of error used to calculate the confidence interval. The confidence interval equals 100*(1 – alpha)%, which means that an alpha of 0.05 indicates a 95-percent confidence level.

  • standard_dev (required). The standard deviation of the population. The argument standard_dev is assumed to be known.

  • size (required). The size of the sample.

Note

If one of the arguments isn’t a numeric value, the CONFIDENCE.T() function returns the #VALUE! error.

If alpha is less than or equal to 0 or greater than or equal to 1, the CONFIDENCE.T() ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required