Calculating average and standard deviation on batch

Calculating average and standard deviation on batch

Hello,
For a customer we need to be able to execute the following function for every batch :
CPK = (UpperToleranceLimit - Average(Values))/(3*Standard Deviation(Values))
We need to do this for several values withing a batchbased archive. Is this possible and how can we do this?
For this we would need functions that can caluculate the average and standard deviation of some values.

This is a migrated post! Originally posted on 08.07.2011 by user sldewit. Please be aware that information can be outdated.