keep in mind javascript is needed for full functionality of the web portal.
Welcome back to our usual blog of Excel functions from A to Z. Today we look at the CONFIDENCE.T function.
The CONFIDENCE.T function
You have your CONFIDENCE up to a T? This function first appeared in Excel 2010 but unlike CONFIDENCE.NORM there was nothing similar in earlier versions of Excel. This is because this function returns the confidence interval for a population mean, using a Student's T distribution.
The CONFIDENCE.T The function uses the following syntax to operate:
CONFIDENCE.T(alfa, standard_dev, Size)
- alfa: This is required. This represents the significance level used to calculate the confidence level. The confidence level is equal 100 * (1 – alfa)%, or put another way, a alfa of 0.05 indicates a confidence level of 95 percent
- standard_dev: this is also necessary. This is the standard deviation of the population for the data range and is assumed to be known
- Size: additionally required. This is the sample size.
It should be noted at the same time that:
- if any argument is not numeric, CONFIDENCE.T return the #VALUE! error value
- And alfa is ≤ 0 or ≥ 1, CONFIDENCE.T return the #ON ONE! error value
- And standard_dev ≤ 0, CONFIDENCE.T return the #ON ONE! error value
- And Size it is not a whole number, is truncated
- And Size <1, CONFIDENCE.T return the # DIV / 0! error value
Please, see my example below:
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every other business day.
