Hi there,
Please do not duplicate posts on the forum. I have deleted the second topic, so let's continue the discussion here.
This is more of a maths question rather than a Highcharts one. I have no idea how the bell curve is calculated in Excel, but in Highcharts, we use the equation from Wikipedia.
https://en.wikipedia.org/wiki/Normal_distribution
And once you calculate it yourself, you will see why the bell curve values exceed 1. If you have a standard deviation below 1, you get such values on the yAxis. But when it comes to a bell curve, the shape is the most important factor, not the yAxis values.
If you take the f(x) equation and divide the
1 by
σ√2π - just like it says in the Wikipedia equation, you get the y values. And if you use a standard deviation
σ like i.e
0.1 the equation will always return more than one, since
1 divided by value below 1 = y value >1.
I hope that it's clear to you now,
Best regards!