Results 1 to 3 of 3

Bell Curve Help!! - Excel 2010 -

This is a discussion on Bell Curve Help!! - Excel 2010 - within the Excel Questions forums, part of the Question Forums category; Hello all, I need help with a bell curve. I will post the data below. I will explain what I ...

  1. #1
    Board Regular Johnny Thunder's Avatar
    Join Date
    Apr 2010
    Location
    California
    Posts
    239

    Default 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. #2
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    11,706

    Default 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.
    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    Please surround your pasted VBA code with CODE tags e.g.;
    [CODE] your VBA code here [/CODE]
    The pound # icon in the forum editor will apply the CODE tags around your selected text.

  3. #3
    Board Regular Johnny Thunder's Avatar
    Join Date
    Apr 2010
    Location
    California
    Posts
    239

    Default 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?

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com