Menu
EXCEL CONFIDENCE.T FUNCTION
Excel CONFIDENCE.T Function Introduction
The Excel Optimism function computes a trust value based on an Independent sample T that may be used to generate the sampling error for a population parameter, for a given probability, and for a sample proportion. It is expected that now the population variance is known.
Description of Excel CONFIDENCE.T Function
Syntax:
=CONFIDENCE.T( alpha, standard_dev, size )
Parameter:
- The following are the arguments:
alpha:
- The level of significance (=1-confidence level).
(For example, a significance level of 0.05 corresponds to a confidence level of 95%.)
standard_dev:
- The population’s standard deviation.
size:
- The size of the population sample.
Step By Step Guide ofCONFIDENCE.T Function
Example :
The Excel Confidence is shown in the spreadsheet below. The T Function is used to compute the confidence interval for the mean of a sample of 100 men’s heights with a significance of 0.05 (i.e. a confidence level of 95%). The standard deviation is 0.07 metres and the sample mean is 1.8 metres.
function returns a confidence value of 0.013889519.
Therefore the confidence interval is 1.8 ± 0.013889519, which is equal to:
1.78110481 to 1.813889519
Key Points
- #NUM!
– Occurs if any of the following conditions are met: the given alpha is 0 or 1; the supplied standard dev is 0; and the specified size argument is 1.
- #DIV/0!
– Occurs if the given size parameter is greater than one. - #VALUE!
– This error occurs if any of the given parameters are not numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
