I thought already that looked way too simple...Hi,
thanks for the reply,
actually i need curved trend line. like attached.
Lasantha.
Hi Lasantha,
In order to have a bell curve like the attached file, your data should be more precise. To get the output you want you need to get the average score and the Standard Deviation for your data.
To get the Average Score or Mean of your data you need to get total score divide by Count of score you may use =Sum(E4:E8)/Count(E4:E8) or simply =Average(E4:E8)
To get the Standard Deviation use the formula =STDEV.S()
Once done, you can write this formula beside the first score :
=NORM.DIST(E4,$H$1,$H$2,FALSE)
Then Insert Scatter graph and choose Scatter with Smooth Lines
I have attached the file that you have sent, but it will not result to a bell curve.
I have created a sample for you. My advise is you have the score data sort it first to lowest to highest.
Here is how your bell curve would look like if I use the data you sent
View attachment 48988
This should be the bell curve would look like
View attachment 48986
Have a read of link. This is how you'd create Histogram with normal curve overlay.
For most charting needs, I find peltiertech.com to be one of best resources.
https://peltiertech.com/histogram-normal-curve-overlay/
Dearly noted!Bell curve isn't really a jargon, but more a layman's term.
Normal Curve/Distribution is a statistical term and Gaussian a mathematical term.
View attachment 48993
see attached file
View attachment 48993
see attached file
The Mean is 1.99 (~2)
the SD is 0.88 (~1)
so a Normal Curve is 99.7% between -3SD to +3SD
so that is 2 - 3x1 to 2+3x1
= -1 to 5
hence the 5 points on the chart
THANK YOUIn the attached I have:
View attachment 49017
It's a nicer fit?
Where:
SD formula swiped from Hui.
- the orange plot is a 5-point scatter plot smoothed (it may be good enough)
- the grey plot is a 40-point scatter unsmoothed
Mine is normal distribution… isn't it? I hope it is.I assumed op needed normal distribution.