iSixSigma

Excel formula for process sigma

Six Sigma – iSixSigma Forums Old Forums General Excel formula for process sigma

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #44401

    Ruddy
    Participant

    Hi,
    Does anyone know a quick and dirty formula for process sigma that approximates the Sigma Calculator on this site?  The functions available in Excel (e.g. ZTEST) require data array, but I have no data because we’re looking forward at a new product line not yet manufactured.  So, I want to simply lay out my forecast production levels by period, input a projected defect rate for each same period, and calculate (estimate) the process sigma in each period.
    Michael

    0
    #142140

    Savage
    Participant
    #142141

    Michael J. Spearamn
    Participant

    I have a Process Sigma Calculator, it gives you the Zst & Zlt with DPMO, and array of other features. If you want it just email @ [email protected]
    Thank you

    0
    #142144

    Ruddy
    Participant

    Beautiful!  Worked perfectly.  Couldn’t find when I searched the site originally, so thank you!

    0
    #142146

    Ruddy
    Participant

    Thank you, I’ll send e-mail request (from Tom, not Michael)…
     

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

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