Hello,
on the attached, I'm looking to create a bell curve graph with the attached data.
I have two column - one is the quote number and the other is the quote count.
I want to be able to see where the average number of quotes are in my population with a bell curve chart.
Any ideas on how to compute?
You'd use NORM.DIST function.
NORM.DIST(x,Mean,STDEV.P,FALSE)
MEAN = AVERAGE(B:B)
STDEV.P = STDEV.P(B:B)
Though, I'm not sure if this data is suitable for Bell curve plot.
Have a read of link for more detailed explanation.
https://trumpexcel.com/bell-curve/
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks