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

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: