I am takjing a Statistics course and am learning about bell curves. In the Offic

Question

I am takjing a Statistics course and am learning about bell curves. In the Office program for windows I have seen an online tutorial on you tube for making normal distribution bell curves, and Standard normal distribution bell curves. The function to make the Standard normal distribution bell curves in that program is NORM.S.DIST. It requries that you enter your z variable and then false. In this version (Mac#2008) it only allows you to enter your z variable, and then gives an error if you enter false. The result is a wrong calculation. Can anyone help me out here?? Thanks in advance!!!!!

Explanation / Answer

Instead, you could use the older NORMDIST worksheet function:

NORMDIST(x, mean, standard_dev, cumulative)

For the density function (bell-shaped curve), set "cumulative" to FALSE.

For standard normal, use mean = 0 (zero) and standard_dev = 1 (one).

For some fancier examples, download

http://www.mikemiddleton.com/Excel-Shaded-Normal-Density-Curves.xls

(You may need to use Format options to rescale the horizontal axis on the charts!!.)

Hope this helps :-))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.