How Do I create a (Pretty) Bell Curve in Excel 2010

[UrbanJungleFashion]

Hey guys. I have been having the worse time figuring this out. I am trying to create an attractive bell curve in Excel. My boss has put a lot of pressure on me but I just can't seem to do this.

I am trying to create a bell curve based on total sqft of a store.

Here is an example the data. In reality I have over 1000 stories. I used the formula STDEV.P because I do have our entire population. However, my bell curves don't look like bells.... they look like drunk mole hills. Can someone please help?

Here is an example of the data and my math:

Am I just understanding SD incorrectly? Does it always have to be between -3 and 3? I am just sick and I have to figure this out in 7 hours!!!

[TABLE="width: 320"]
<tbody>[TR]
[TD="class: xl94, width: 64"][TABLE="width: 320"]
<tbody>[TR]
[TD]STORE #[/TD]
[TD]$ per RSF[/TD]
[TD]Distribution[/TD]
[TD] Mean[/TD]
[TD] SD[/TD]
[/TR]
[TR]
[TD]0001[/TD]
[TD]7.29[/TD]
[TD="align: right"]0.009876[/TD]
[TD="align: right"]31.23[/TD]
[TD="align: right"] 28.10553[/TD]
[/TR]
[TR]
[TD]0002[/TD]
[TD]10.83[/TD]
[TD="align: right"]0.010908[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0003[/TD]
[TD]17.36[/TD]
[TD="align: right"]0.012567[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0004[/TD]
[TD]18.21[/TD]
[TD="align: right"]0.01275[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0005[/TD]
[TD]18.96[/TD]
[TD="align: right"]0.012904[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0006[/TD]
[TD]22.28[/TD]
[TD="align: right"]0.013493[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0007[/TD]
[TD]22.38[/TD]
[TD="align: right"]0.013507[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0008[/TD]
[TD]25.23[/TD]
[TD="align: right"]0.013875[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0009[/TD]
[TD]28.63[/TD]
[TD="align: right"]0.014134[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0010[/TD]
[TD]64.41[/TD]
[TD="align: right"]0.007072[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0011[/TD]
[TD]107.95[/TD]
[TD="align: right"]0.000342[/TD]
[TD]

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl94, width: 64"][/TD]
[TD="class: xl94, width: 64"][/TD]
[TD="class: xl94, width: 64"][/TD]
[TD="class: xl94, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

This link should help you build your bell curve.

https://www.youtube.com/watch?v=refaA0jvqE8

In a normal distribution about 99.7% of the values will be between -3 & 3 SD from the mean, but no all values do not have to be between -3 & 3.