Bell Curve for Profit Margin

**brentlindeman** · 02-12-2014, 06:40 PM

I need help making a bell curve graph and will show us the profit (%) we made over a month. I have all the numbers listed and I'm pretty sure I found the standard deviation. I just don't know how to make the graph.

On the graph I need the bell curve to follow the overall profit %'s values
and the customer 1 profit's data to be on top of it to compare one customers profit with the entire company's profit.
(if that's even possible)

Thanks

profit percent bell curve.xlsx

**Kaper** · 02-13-2014, 05:49 AM

Hi,
You can draw normal distribution density curve based on built in function:

=NORM.DIST(K2,$E$2,$I$2,FALSE)

see attachment.
Please note that I used scatter plot for the line and used more X values to have it smooth enough.

But I dont't really understand how you want to present on it data from one customer. These are just single profits, while the curve shows density of probability.
If you would like to show the distribution (cumulative frequency - it would be easier for me to understand) but may be the first step already will be helpfull.

May be just points? write some Y (may be 0? or may be 0.5 would look nice) in D2:D12 and add next series to the graph (plotted with pionts, no connecting lines) with C2:C12 as X and D2:D12 as Y

PS. in yellow row I written normal excel functions to calculate average, variance (as a matter of fact - you do not need it) and stddev (directly from data).