iSixSigma

Z value calculation

Six Sigma – iSixSigma Forums Old Forums General Z value calculation

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #30990

    Logan Luo
    Participant

    I am working on software of process monitoring, which intergrates six sigma measurements. Does anyone have the formula of calculating Z value from DPU? I don’t want to ask user to look for Z value from a table.
     
    Thanks
    Logan
     

    0
    #81403

    Erik L
    Participant

    Logan,
    Send me an e-mail link and I can provide an excel template that provides the calculations that you are requesting from two different approaches.
    Regards,
    Erik

    0
    #81406

    Logan Luo
    Participant

    Thanks Erik.
    My email: [email protected]
    Logan

    0
    #81411

    Sharma
    Participant

    Hi Erik ,
    Seems some really useful stuff as even i share the same issue.
    I am working with an I T organization.. When we are  conducting  Six  Sigma training sessions for our employees .. they find looking Z values into the tables  quite time-consuming & inconvenient .So request you to please share that excel template with me also . My email link is [email protected]
    Regards and thanks in advance ,
     

    0
    #81412

    A.B
    Participant

    1 – To find a Z value from a probability p use in EXCEL the following :=NORMSINV(p) and you’ll get the Z value without looking at the table.2 – To find a probability p from a Z value use in Excel the following :=NORMSDIST(z)

    0
    #86305

    Wagh
    Participant

    Hi Erik,
    Cud u pls share the Excel template . my email is [email protected]

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

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