Confidence. Norm
Explanation:
Confidence.Norm is an Excel function that uses a normal distribution to calculate the confidence value that can be used to calculate the confidence interval for a population mean,for a supplied probability and sample size. It is assumed that the standard deviation of the population is known.
So Confidence.Norm is the right formula to use here as the standard deviation has been given.