S
sixsigmais
Just use the excel formula
=(1-NORMDIST(sigma-1.5,0,1,1))*1000000
Replace the sigma with the number of sigma you like to find.
So, 6 sigma
=(1-NORMDIST(6-1.5,0,1,1))*1000000 = 3.4ppm
5 sigma
=(1-NORMDIST(5-1.5,0,1,1))*1000000 = 233ppm
and so on
=(1-NORMDIST(sigma-1.5,0,1,1))*1000000
Replace the sigma with the number of sigma you like to find.
So, 6 sigma
=(1-NORMDIST(6-1.5,0,1,1))*1000000 = 3.4ppm
5 sigma
=(1-NORMDIST(5-1.5,0,1,1))*1000000 = 233ppm
and so on