How do i set up a normal distribution in excel?

D

dimi

I need to find out how you can set up a normal distribution curve on
microsoft excel. When I search normal distribution i get a function for it
but i want to see the curve, which i can't figue out how to do
 
M

Matt Lunn

dimi said:
I need to find out how you can set up a normal distribution curve on
microsoft excel. When I search normal distribution i get a function for it
but i want to see the curve, which i can't figue out how to do


In column A set up your X values, For example from -4 to +4. Increments of
0.1 should be OK.

In column B use the NORMDIST function like this

If you X values start at A1 then cell B1 should be

=NORMDIST(A1,0,1,FALSE)

Copy the formula down for all X values.

Produce chart on Column B and use Column A for X values

HTH

Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top