iSixSigma

want to get help about P5,P95 statistic problem

Six Sigma – iSixSigma Forums Old Forums General want to get help about P5,P95 statistic problem

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #43132

    Ruddy
    Participant

    Hi, the below data are our customer service department respond customer requirement. 1,2,3,1,2,0,9,0,10,2,3,4,3,2,1,2,2,0,3,2( 0 means customer service give call back at the same day).these data is no-normal,
     
    Question: how can I calculate p5–p95, by excel or by Mintab? does anybody can tell me how to do that in detail step? Your help will be appreciative.

    0
    #136508

    BTDT
    Participant

    Michael:

    Do the
    calculation ONLY in Excel, the details are below

    Data
    Formula
    Result

    1
    =PERCENTILE(A1:A20,0.95)
    9.05

    2
    =PERCENTILE(A1:A20,0.05)
    0

    3
    =b1-b2
    9.05

    1

    2

    0

    9

    0

    10

    2

    3

    4

    3

    2

    1

    2

    2

    0

    3

    2

    Cheers,
    BTDT

    0
Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘General’ is closed to new topics and replies.