CONFIDENCE.T

CONFIDENCE.T(alpha, standard_dev, size)

Returns the confidence interval for a population mean using a t distribution.

alpha	The significance level.
standard_dev	The standard deviation for the population.
size	The size of the sample.

REMARKS

* The confidence level is 100*(1-alpha)%
* An alpha of 0.05 indicates 95% confidence level.
* If "size" = 1, then #DIV! is returned.
* If "size is not an integer, it is truncated.
* If "standard_dev" <=0, then #NUM! is returned.
* If "alpha" <=0, then #NUM! is returned.
* If "alpha >=1, then #NUM! is returned.
* You can use the CONFIDENCE.NORM function to return the confidence interval for a population mean.
* This function was added in Excel 2010
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=CONFIDENCE.T(0.05, 1, 50) = 0.284

1 - Confidence interval for the mean of a population based on a sample size of 50, with a 5% significance level and a standard deviation of 1. This is based on a Student's t-distribution.