Menu
EXCEL CONFIDENCE.NORM FUNCTION
Excel CONFIDENCE.NORM Function Introduction
Excel Self-Assuredness The Norm method use a Normally Distributed to get a confidence value that may be used to calculate the confidence interval for a population mean given a probability and sample size. The population’s standard deviation is supposed to be known.
Description of Excel CONFIDENCE.NORM Function
Syntax:
=CONFIDENCE.NORM( alpha, standard_dev, size )
Parameter:
- The following are some of the arguments:
alpha:
- The degree of significance (=1-confidence).
(For example, a significance level of 0.05 corresponds to a 95 percent confidence level.)
standard_dev:
- The population’s standard deviation (SD).
size:
- The sample size for the population.
Step By Step Guide of CONFIDENCE.NORM Function
Example :
Its Excel Confidence is shown in the spreadsheet below. The Norm 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.013719748
Therefore the confidence interval is 1.8 ± 0.013719748, which is equal to:
1.786280252 to 1.813719748
Key Points
- #NUM! – Occurs if any of the following conditions are met: the supplied alpha is 0 or 1; the supplied standard dev is 0; and the supplied size argument is 1.
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
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
