LinkBack URL
About LinkBacks
Hello
Please show me how to create a histogram that is fitted with a normal distribution curve ("bell curve") in Excel. Probability density function please!
Hello
Please show me how to create a histogram that is fitted with a normal distribution curve ("bell curve") in Excel. Probability density function please!
As requested - please see attached.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thank you for your response, sweep. Maybe I'm doing something wrong on your example, but I cannot get the probability to add up to 1 (100%). Do you have any suggestions?
See attached. I'm on Excel 2010.
You can modify formula in F2 (and copy down):
Formula:
Please Login or Register to view this content.
of course for such data as yours it still will be well below 1 because you draw only middle part of the frequency curve and probabilyty of large tails is missing, but see sample data in attached file - almost 1.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks