If the mean of a population is 2.456 and its variance (not standard deviation) i

Question

If the mean of a population is 2.456 and its variance (not standard deviation) is 2.042, answer the following:

Plot this normal distribution curve in MS Excel between -3? and +3?. The plot should
also highlight the peak value and the points of inflection. Calculate a sufficient number of points to get a smooth curve, and use one of the scatter charts to plot the function. Your plot should look similar to the one in this figure, but it will be based on different parameter settings.

If one could show me how to get this charted in Excel step by step, I would be eternally grateful

Explanation / Answer

Normal curve in EXCEL :

=NORMDIST(A2,AVERAGE($A$2:$A$32),STDEV($A$2:$A$32),FALSE) Replace the $32 references to match the last row of data you entered.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects