Answer:
The answer to the question is;
CONFIDENCE.NORM
Step-by-step explanation:
In excel, the confidence.norm calculates the confidence value which then gives the confidence interval for a given population mean, probability of occurrence and sample number or size using Normal distribution statistics.
The mean is at the center of the confidence interval is given by the range
mean, μ ±CONFIDENCE.NORM. and it tells the degree of confidence that a value of the mean of a sample of data is about the mean of the population.