Graph a normal distribution chart?

G

Guest

I am having trouble graphing the percentage to the bell curve shape. Can
anyone help? Thanks.
 
D

David Biddulph

Barbara said:
I am having trouble graphing the percentage to the bell curve shape. Can
anyone help? Thanks.

If you're looking for the density function for the normal distribution, try
=(EXP(-POWER(A2,2)/2))/SQRT(2*PI())
and scale appropriately.

If you're looking for the cumulative, try
=NORMSDIST(A2)
 
R

robert111

is the normal distribution curve based on the whole class's homework on
time scores? And are the pupils the same, ie all come from the same
sort of homes with the same level of parental support?
 
G

Guest

David,
I am not sure about the formula. I try almost every sample formula but
still can't curve the bell shape. What I want to do is have the mean as a
percentage and the numbers are as followed: Do I use those formula you gave
me as well? Thanks.

74% = 34/46 times
30% = 14/46 times
44% = 20/26 times
26% = 12/46 times

how do i graph this?
 
G

Guest

yes. here is an example i want to chart

out of 46 times 34 of the times is good that is 74%
out of 46 times 30 of the times is okay that is 30%
out of 46 times 20 of the time is not okay that is 44% (within this bracket,
I want to chart another percentage) of the 44% that is 12/17 or 70% of the
time does something else
out of 46 times 12 of the time is bad that is 26% (within this bracket, I
want to make another percentage) of the 26% that is 12/19 or 63% of the time
does something else
 

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