CONFIDENCE.T function - The function returns the confidence interval of the population by using the Student's t-distribution in Excel
The following article introduces you to the CONFIDENCE.T function - one of the functions in the statistical group is very popular in Excel.
Description: The function returns the confidence interval of the population by using the Student's t-distribution. Support functions from Excel 2010 onwards.
Syntax: CONFIDENCE.NORM (alpha, standard_dev, size)
Inside:
- alpha: The critical level to calculate the confidence level, with confidence level = 100 * (1- alpha) , is the required parameter .
- standard_dev: The overall standard deviation for the data range, and considered to have been determined, is the required parameter.
- size: Sample size , is a required parameter.
Attention:
- If any of the parameters' values are not numeric -> the function returns the #VALUE! Error value .
- If alpha ≤ 0 or alpha ≥ 1 -> the function returns the #NUM! Error value
- If standard_dev ≤ 0 -> the function returns the #NUM! Error value
- If size is not an integer -> it is truncated to an integer.
- If size = 1 -> the function returns the # DIV / 0 error value !
For example:
Calculate the average overall confidence interval based on the Student's t-distribution with the data in the table below:
- In the cell to calculate, enter the formula: = CONFIDENCE.T (D6, D7, D8)
- Press Enter -> the overall confidence interval for the population is:
- Where alpha ≤ 0 or alpha ≥ 1 -> the function returns the #NUM! Error value
- Where size = 1 -> the function returns the error value #NUM!
Above are instructions and some specific examples when using the CONFIDENCE.T function in Excel.
Good luck!
You should read it
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excel
- TDIST function - The function returns the probability of the Student distribution in Excel
- T.DIST - The function returns the Student t-distribution on the left in Excel
- T.DIST.2T - The function returns the two-tailed Student distribution in Excel
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
- WEIBULL function - The function returns the Weibull distribution in Excel
- To be confident immediately apply the following 5 tips
- TINV function - The function returns the inverse of the Student's t-distribution in Excel
May be interested
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excelbeta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excellognorm.inv: the function returns the inverse of the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. use functions to analyze logarithmic change data. support function from excel 2 version
- T.INV function - The function returns the inverse value of the Student t distribution in Excelt.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excelt.dist.rt: the function returns the student's t-distribution on the right. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.rt (x, deg_freedom)
- F.DIST - The function returns the probability distribution F in Excelf.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excelhypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)
- F.INV function - The function returns the inverse of the probability distribution F in Excelf.inv function: the function returns the inverse of the probability distribution f. support function from the excel 2010 version. syntax: f.inv (probability, deg_freedom1, deg_freedom2)
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excelf.inv.rt function: the function returns the inverse of the right probability distribution f. support functions from the excel 2010 version. syntax: f.inv.rt (probability, deg_freedom1, deg_freedom2)
- CHISQ.DIST - Function returns the distribution when squared in Excelchisq.dist: the function returns the distribution when squared, and this value is often used to understand variations as a percentage of the samples. support function from excel 2010 version. syntax: chisq.dist (x, deg_freedom, cumulative)