Lab 11 Normal Distributions

A normal distribution is a continuous probability distribution for a random variable that describes the frequency of the outcomes of the variable. The mean and the standard deviation parameters determine the normal distribution.

In this lab, you will use the AVERAGE and STDEV.S functions to calculate the data’s mean and standard deviation, respectively.

The NORM.DIST(x,mean,standard_dev,cumulative) function returns the normal distribution for the specified mean and standard deviation. In this case, we will use the false argument for cumulative since we will get the corresponding probability for the respective x values.

The NORM.INV(probability,mean,standard_dev) function returns the z-score in a normal cumulative distribution for the specified mean and standard deviation.

The STANDARDIZE(x, mean, standard_dev) function returns a normalized value from a mean and standard deviation distribution.