Hi
I have an excel sheet where I am trying to create Bell Curve, but I see there is a dip in curve at top.
Can you please check why there is dip in bell curve and how I can fix it.
please help.
Regards
Hi
I have an excel sheet where I am trying to create Bell Curve, but I see there is a dip in curve at top.
Can you please check why there is dip in bell curve and how I can fix it.
please help.
Regards
Last edited by NonStopLeo; 12-06-2020 at 11:30 AM.
It's flat because you have chosen 4 consecutive values that are equal to each other. If you know the mean and standard deviation for which you want to generate a normal distribution, it's easy. Rather then me explaining it, take a look, here (for example):
https://trumpexcel.com/bell-curve/
Last edited by Glenn Kennedy; 11-28-2020 at 04:44 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please put number 5-10 for change Standard Deviation
then H5
Formula:Please Login or Register to view this content.
Please try
Formula:Please Login or Register to view this content.
The curve is from NORM.DIST function, No need to add data in the curve type sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks