Re: How Can I Create a Bell curve in Excell 2007
There are two challenges before even getting started with fitting a bell curve to the data.
* The data does not seem to follow a bell curve to begin with. There is perhaps some slight rise in the middle, but there are larger variations from one bin to the next.
* The bins are different widths. The narrowest bins are about 1/3 the width of the widest bins. This would naturally put more items into the wide bins (although that does not necessarily be the case in the actual data). Figuring out how to properly fit a bell curve in that case will be CONSIDERABLY more difficult than if the bins are the same width.
P.S. I am assuming that the "OD Size" is the way you are sorting the items (the 'bins') and the "Footage" is how much you got of that category.