Norm.Dist and Norm.Inv Functions in Excel Excel

Which of the following Excel functions is used to calculate the probability of a value occurring in a normal distribution?

• NORM.INV

• NORM.DIST

• AVERAGE

• STDEV.P

What is the correct syntax for the NORM.DIST function in Excel?

• `NORM.DIST(x, mean, standard_dev, cumulative)`

• `NORM.DIST(mean, x, standard_dev, cumulative)`

• `NORM.DIST(x, standard_dev, mean, cumulative)`

• `NORM.DIST(standard_dev, mean, x, cumulative)`

Which Excel function is used to find the value at a given percentile in a normal distribution?

• NORM.DIST

• NORM.INV

• AVERAGE

• STDEV.P

What is the correct syntax for the NORM.INV function in Excel?

• `NORM.INV(probability, mean, standard_dev)`

• `NORM.INV(mean, probability, standard_dev)`

• `NORM.INV(standard_dev, mean, probability)`

• `NORM.INV(probability, standard_dev, mean)`

How do you calculate the mean of a dataset in Excel?

• `=STDEV.P(range)`

• `=AVERAGE(range)`

• `=NORM.DIST(range)`

• `=NORM.INV(range)`

Which function would you use to calculate the population standard deviation in Excel?

• `=STDEV.S(range)`

• `=STDEV.P(range)`

• `=VAR.P(range)`

• `=VAR.S(range)`

If you want to find the probability that a value is less than a given number in a normal distribution, which argument should be set to TRUE in the NORM.DIST function?

• x

• mean

• standard_dev

• cumulative

In a normal distribution, what does the mean represent?

• The most frequently occurring value

• The middle value when data is ordered

• The average of all data points

• The spread of the data

What does the standard deviation measure in a dataset?

• The average value

• The spread or dispersion of the data

• The highest value

• The lowest value

Which of the following statements is true about a normal distribution?

• It is skewed to the right

• It is skewed to the left

• It is symmetrical around the mean

• It has multiple peaks