Bell Curve Help!! - Excel 2010 -

Johnny Thunder

Well-known Member
Joined
Apr 9, 2010
Messages
693
Office Version
  1. 2016
Platform
  1. 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>

Column JDays
J50
J60
J70
J80
J90
J1010
J1110
J1210
J1317
J140
J1517
J1617
J1710
J186
J190
J200
J210
J224
J237
J240
J250
J260
J270
J280
J290
J301
J310
J320
J3313
J3413
J351
J361
J371
J381
J3927
J409
J417
J429
J4313
J4413
J4513
J460
J479
J4813
J4922
J5022
J5122
J5222
J5314
J5414
J5522
J5622
J5722
J5822
J5914
J6014
J610
J6214
J631
J644
J654
J660
J670
J680
J690
J7011
J7111
J7211
J7313
J744
J754
J7614
J778
J780
J794
J804
J814

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Make a frequecncy table from your data.

<br />
Book1
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
Sheet1
Cell Formulas
RangeFormula
M5=COUNTIF(J:J,L5)


Then create an XY Scatter Chart of the frequency table data.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

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