I will need to write an app to run statistical analysis on a DataGrid. Pp and Ppk is easy to do with standard deviation calculation in C#. But Some number such as estimated deviation (rBar/d2) used for Cp and Cpk - that is too complex (for me ) to code. Are there existing libraries, commercial or open source, that I can implement?
Does .NET 4 support any 6-Sigma calculation?
3.6k views Asked by KMC At
3
There are 3 answers
1
On
You might wanna check out Sho, it's a tool for doing stuff with data and it provides a lot of math libraries.
http://channel9.msdn.com/Blogs/Charles/John-Platt-Introduction-to-Sho
1
On
I have used MathNet.Numerics for these type calculations.
https://www.nuget.org/packages/MathNet.Numerics/
https://numerics.mathdotnet.com/
Example for cp and cpk:
public class ProcessPerformance
{
public static ProcessPerformanceResult Calculate(double[] data,double lsl,double usl,double sigma =3.0,double cpSigma=6.0)
{
if(data.Count() ppkLsl ? ppkLsl : ppkUsl;
var cP = (usl - lsl) / (descriptiveStatistics.StandardDeviation * cpSigma);
var median = MathNet.Numerics.Statistics.Statistics.Median(data);
return new ProcessPerformanceResult(){Cp=cP,Cpk=cPk,Median= median, DescriptiveStatistics=descriptiveStatistics};
}
public class ProcessPerformanceResult
{
//https://en.wikipedia.org/wiki/Process_capability_index
public double Cpk { get; set; }
public double Cp {get;set;}
public double Median {get;set;}
public MathNet.Numerics.Statistics.DescriptiveStatistics DescriptiveStatistics {get;set;}
}
}
Extreme Optimization might be something you are looking for.
Edit
How about SPC Chart?