YI have a standard deviation aka bell curve of some data. The bar lines that I defined for the x-axis are 0-100 and the formula I used to get the Y-axis is =($B$2/($C$2*SQRTPI(2)))*EXP(-(((E2-$A$2)^2)/(2*($C$2)^2))). This has worked great to get me a bell curve distribution of my data.
But, the y-axis is showing arbitrary numbers as a result of that formula and my boss would like those numbers to be a value between 1-100 as well.
I don't quite grasp this all yet, but if I could get help doing this from someone on this forum I'd appreciate it.
Boss needs P(x)=1 for X-axis. How to do?
But, the y-axis is showing arbitrary numbers as a result of that formula and my boss would like those numbers to be a value between 1-100 as well.
I don't quite grasp this all yet, but if I could get help doing this from someone on this forum I'd appreciate it.
Boss needs P(x)=1 for X-axis. How to do?
Last edited: