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
  • December 10, 2002 at 4:38 pm #30990

    Logan Luo
    ★ 20 Years ★
    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
    December 10, 2002 at 5:22 pm #81403

    Erik L
    ★ 10 Years ★
    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
    December 10, 2002 at 11:07 pm #81406

    Logan Luo
    ★ 20 Years ★
    Participant

    Thanks Erik.
    My email: [email protected]
    Logan

    0
    December 11, 2002 at 6:41 am #81411

    Sharma
    ★ 10 Years ★
    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
    December 11, 2002 at 7:26 am #81412

    A.B
    ★ 20 Years ★
    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
    May 24, 2003 at 10:24 am #86305

    Wagh
    ★ 10 Years ★
    Participant

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

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

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