# SIGMA Calculator formula

Six Sigma – iSixSigma Forums Old Forums General SIGMA Calculator formula

Viewing 13 posts - 1 through 13 (of 13 total)
• Author
Posts
• #38142

howe
Participant

I have been looking for the formula that derives the Sigma value from parts per million defective. I have found plenty of tables and of course there is the Sigma Calculator on this site. But what I am looking for is the formula that produces those values.

0
#113783

LSS BB Banking
Participant

Please provide an email address and will forward you an excel template with the definitions and formulas.

0
#113786

howe
Participant
#133318

Alfonso Gonzalez
Participant

Can you provide me, the excel sheet that you offer to one of the persons that ask for a six sigma calculator format and formulas.

thanks.

0
#133320

Savage
Participant
#133322

Anoop
Participant

Are you Matt Dailey from Ohio ?
mail me at [email protected] if you are

0
#133324

Savage
Participant

Sorry – I’m in Phoenix.

0
#133332

J Castagna
Participant

Hi
Is this the xls formula you are looking for?  Or do you really want the DPMO formula?
Hope this helps – Cheers Justin

Sigma Process Calculator using Excel

DATA
(Unless specified)

DPMO
Per yellow (Cell C10)

Std Dev
1

Mean
0

DESCRIPTION
RESULT

FORMULA

DPMO
126,000

SIGMA SCORE (per table)
2.6455

=NORMSINV(1-\$B\$2/10^6)+1.5

where B2 = DPMO

1.1455

=NORMSINV(1-\$B\$2/10^6)

where B2 = DPMO

Long Term Yield
0.8740

=NORMDIST(\$C\$16,\$F\$5,\$F\$4,1)

Where C16 = sigma score

Where F5 = Mean

Where F4 = Std Dev

0
#145406

Arevalo, Maria Kathyrine
Participant

I have been looking for the formula that derives the Sigma value from parts per million defective. I have found plenty of tables and of course there is the Sigma Calculator on this site. But what I am looking for is the formula that produces those values

0
#145411

keyhan
Participant

I have a program in excel that it calculate sigma by determinnig CTQ

best regards
keyhan abbasian

0
#145413

BB
Participant

BS In = BS Out

0
#145420

Eric Maass
Participant

Maria Kathyrine,
The formula / algorithm used in the Sigma Calculator was given in a reply to a similar question some time ago: