Question

Suppose the values of a distribution varies from -3 to +3, with mean of 0 and standard deviation of 1. Plot a standard normal distribution curve using Excel commands.

Answer 1

Use th formula

NORMDIST(x,mean,standard_dev,cumulative)

The NORMDIST function syntax has the following arguments:

X Required. The value for which you want the distribution.

Mean Required. The arithmetic mean of the distribution.

Standard_dev Required. The standard deviation of the distribution.

Cumulative Required. A logical value that determines the form of the function. If cumulative is TRUE, NORMDIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.

Put the values as per conditions here,

x =3, mean =0 standant deviation =1, Cumulative: True