CONFIDENCE.T (Alpha, StandardDeviation, Size) CONFIDENCE.T (Alpha; StandardDeviation; Size)
Alpha
Number Number
The significance level, which determines the desired confidence level.
StandardDeviation
Number Number
The standard deviation of the sample.
Size
Number Number
The size of the sample.
Returns
Number Number
The margin of error of the mean of a population.
Returns the margin of error of the mean of a population, given the standard deviation and the size of a sample. The confidence interval extends this far on either side of the mean of the sample. Setting the Alpha parameter to 0.05 gives a 95% confidence interval. This function uses Student's t-distribution. Use it rather than CONFIDENCE.NORM if the standard deviation is calculated from the sample itself.
Examples
CONFIDENCE.T (0.05, 1, 50)
CONFIDENCE.T (0,05; 1; 50)
Returns roughly 0.28.
CONFIDENCE.T (0.05, 1.5, 100)
CONFIDENCE.T (0,05; 1,5; 100)
Returns roughly 0.30.