Does anyone have the SQL code to perform a Six Sigma Calculation?
Six Sigma like the Motorola Black Belt type? I didn’t know that there is a formula/calculation - I thought it was more of a QA process/methodology.
Its simply a way to convert defects per opportunity to a value between 0 thru 6.
1 sigma is 3.4 defects per 1,000,000 opportunities
What we need is mathematical genius. I need an algorithm that will return the folowing:
x | y(x)
694,000 | 1
308,000 | 2
67,000 | 3
6,200 | 4
230 | 5
3.4 | 6
OK, I’ve got it!
switch({Root Container.value},
694000,308000,67000,6200,230,3.4
1,2,3,4,5,6,
-1)
Maybe nested if statements?
if({Root Container.value}>694000,
1,
if({Root Container.value}>308000,
2,
if({Root Container.value}>67000,
3,
if({Root Container.value}>6200,
4,
if({Root Container.value}>230,
5,
6,
)
)
)
)
)
I looked it up online, and I have no idea if there if this is acurate, but it looks like it might be =). To calculate 6-sigma, you have to break it down into a few parts:
6-sigma = sigma * 6 + the calculated mean.
sigma = sqrt(1/N*SUM(x-AVG(x))^2)
You can do this in a few steps
- Calculate the average of your values
- Loop through your values, finding (value-average)^2 and adding them together
- Divide by the number of values
- Take the square root of that
so a python script would look something like:
[code]values = my set of values
#calculate average
mean = 0
count = 0
for value in values:
mean = mean + value
count = count + 1
mean = mean/count
#calculate sum
sum = 0
for value in values:
sum = sum + (value-mean)*(value-mean)
#calculate sigma
sigma = sqrt(sum/count)
#calculate 6-sigma
sixsigma = sigma/6 + mean
[/code]