Hello
Please show me how to create a histogram that is fitted with a normal distribution curve ("bell curve") in Excel.
Hello
Please show me how to create a histogram that is fitted with a normal distribution curve ("bell curve") in Excel.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
With such a generic question, I'm not sure exactly what you need help with. In the spirit of "divide and conquer", I would suggest that you break up the process into several steps:
1) Count frequencies using COUNTIF() or FREQUENCY() function, if needed. (list of available Excel functions which link to help files: https://support.office.com/en-US/art...rs=en-US&ad=US )
2) Compute mean (AVERAGE()) and standard deviation (STDEV()).
3) Use step 2 to compute normal distribution (use NORMDIST() or NORM.DIST() function) at same "bins" as used in 1
4) Generate column + line combination chart using the result of 1 and 3: https://support.office.com/en-us/art...0-EC33F588243F
What steps do you need help with?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks