How to do a bell curve in Excel?

rugby1999
rugby1999 used Ask the Experts™
on
How to do a bell curve in Excel?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006
Commented:
Hello rugby1999,

you could try this from John Walkenback

Try this:

A1: -3
A2: =A1+0.25
(Copy A2 down to A25)
B1: =NORMDIST(A1,0,1,FALSE)
(Copy B1 down to B25)

Create an XY chart from A1:B25. This displays a normal distribution with a mean of 0 and a standard deviation of 1 (+/- 3 SDs). You can adjust these formulas for other mean and SD values.

HAGD:O)Bruintje
Hi rugby1999,
No comment has been added lately (122 days) and it's time to clean up this Topic Area.
If this question isn't revived and no action is taken I will leave a recommendation in the Cleanup topic area that this question is:

RECOMMENDATION: Award points to bruintje

rugby1999 and experts, please leave any comments here within the next seven days.
This will be finalized by a moderator and he will use those comments to make his final decision.

-- PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER ! --

Paulo
Cleanup Volunteer
Per recommendation

RotaredoM
CS Mod @ EE
Hello,
I am looking for a software that I can use for my Bell Curve chart. Is there any ready made software, other than excel sheet?

Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial