Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
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.
<tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
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.
<tbody>
</tbody>
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 |
<colgroup><col><col></colgroup><tbody>
</tbody>