Bell Curve Help!! - Excel 2010 -

Thanks:  0
Likes:  0

# Thread: Bell Curve Help!! - Excel 2010 -

1. ## Bell Curve Help!! - Excel 2010 -

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.

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

2. ## Re: Bell Curve Help!! - Excel 2010 -

Make a frequecncy table from your data.

LM
4DaysCount
5024
616
720
830
948
1050
1161
1272
1381
1493
15104
16113
17120
18137
19146
20150
21160
22173
23180
24190
25200
26210
27228
28230
29240
30250
31260
32271

Worksheet Formulas
CellFormula
M5=COUNTIF(J:J,L5)

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

3. ## Re: Bell Curve Help!! - Excel 2010 -

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?

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•