Bell Curve Help!! - Excel 2010 -

[Johnny Thunder]

Hello all,

I need help with a bell curve. I will post the data below. I will explain what I am doing.

My company deals with shipping. lately we have been taking to much time shipping our packages to customers so I wanted to run a bell curve to show to management.

1. fastest shipments go out same day
2. Longest Shipments take over 53 days (per the data below)

As you can see Column J is just a cell and column Reference but Column "Days" contains the days in order it took for orders to go out so now I am having trouble making a bell curve with this data. Any help is much appreciated!

Thanks again.

[TABLE="width: 100"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 270"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Column J[/TD]
[TD]Days [/TD]
[/TR]
[TR]
[TD]J5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J6[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J7[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J8[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J9[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J10[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]J11[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]J12[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]J13[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]J14[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J15[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]J16[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD]J17[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]J18[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]J19[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J20[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J21[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J22[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J23[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]J24[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J25[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J26[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J27[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J28[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J29[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J30[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J31[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J32[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J33[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J34[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J35[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J36[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J37[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J38[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J39[/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD]J40[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]J41[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]J42[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]J43[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J44[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J45[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J46[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J47[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]J48[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J49[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J50[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J51[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J52[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J53[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]J54[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]J55[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J56[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J57[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J58[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]J59[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]J60[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]J61[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J62[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]J63[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J64[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J65[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J66[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J67[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J68[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J69[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J70[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]J71[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]J72[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]J73[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]J74[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J75[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J76[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]J77[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]J78[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]J79[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J80[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]J81[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlphaFrog]

Make a frequecncy table from your data.

<br />

Book1
	L	M
4	Days	Count
5	0	24
6	1	6
7	2	0
8	3	0
9	4	8
10	5	0
11	6	1
12	7	2
13	8	1
14	9	3
15	10	4
16	11	3
17	12	0
18	13	7
19	14	6
20	15	0
21	16	0
22	17	3
23	18	0
24	19	0
25	20	0
26	21	0
27	22	8
28	23	0
29	24	0
30	25	0
31	26	0
32	27	1
Sheet1

Cell Formulas
Range	Formula
M5	=COUNTIF(J:J,L5)

Then create an XY Scatter Chart of the frequency table data.

 

[Johnny Thunder]

Maybe I was a little unclear. I put in column J in the above post just to give a row reference. the J:J column is completely blank. Column K contains the Header "Days" in cell K4. And the list of Days starting from K5:k81 is in the order it needs to stay based on a shipping date. So what will I use for Frequency?