Calculated Characteristic Formulas

[Former Member]

Guru's,

I have an Inspection Plan with some MICs that need to be calculated.

I Need to extract the standard deviation from MIC 0010 and use in a calculated MIC 0020.

Calculation for MIC 0020 that uses the standard deviation from MIC 0010 is: ({Target Weight}-0.1)-AVE(MIC 0010)/STDEV(MIC 0010)

Target weight on example is 2

Can anyone please help or at least send me in the right direction?

Thanks so much!

Bruce

[Former Member]

It worked!

Thanks so much!

[Former Member]

Hi,

By AVE(0010), i thought you meant Arithmetic mean. Here's the formula - try and let me know if this doesn't work(i didn't test it)

((2-0.1))-C00010/(SQRT(C80010))

Good luck,

Anil