Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

CONFIDENCE.T

Calculates the width of half the confidence interval for a student’s t-distribution.

Sample Usage

CONFIDENCE.T(0.05,1,20)
CONFIDENCE.T(A2,A3,A4)

Syntax

CONFIDENCE.T(alpha, standard_deviation, size)

  • alpha - The significance level used to compute the confidence level.
  • standard_deviation - The standard deviation of the population.
  • size - The size of the population.

 

Examples

CONFIDENCE.T(0.05, 1, 20) returns 0.468, the confidence interval for the mean of a population based on a sample size of 20, with a 5% significance level and a standard deviation of 1.

Notes

  • The confidence level equals 100*(1-alpha)%. An alpha of 0.05 indicates a 95 percent confidence level.