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

UrbanJungleFashion

New Member
Joined
Oct 14, 2014
Messages
17
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!!!:eek:

STORE #$ per RSFDistribution Mean SD
00017.290.00987631.23 28.10553
000210.830.010908
000317.360.012567
000418.210.01275
000518.960.012904
000622.280.013493
000722.380.013507
000825.230.013875
000928.630.014134
001064.410.007072
0011107.950.000342

<tbody>
</tbody>

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,487
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,817
Messages
5,446,673
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top