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
Normal-Distribution_Problem_5.jpg

<tbody>
</tbody>

<tbody>
</tbody>
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,214,641
Messages
6,120,685
Members
448,977
Latest member
dbonilla0331

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top