Correlation of two arrays in C#

by

You can have the values in separate lists at the same index and use a simple Zip.

var fitResult = new FitResult();
var values1 = new List<int>();
var values2 = new List<int>();

var correls = values1.Zip(values2, (v1, v2) =>
                                       fitResult.CorrelationCoefficient(v1, v2));

A second way is to write your own custom implementation (mine isn’t optimized for speed):

public double ComputeCoeff(double[] values1, double[] values2)
{
    if(values1.Length != values2.Length)
        throw new ArgumentException("values must be the same length");

    var avg1 = values1.Average();
    var avg2 = values2.Average();

    var sum1 = values1.Zip(values2, (x1, y1) => (x1 - avg1) * (y1 - avg2)).Sum();

    var sumSqr1 = values1.Sum(x => Math.Pow((x - avg1), 2.0));
    var sumSqr2 = values2.Sum(y => Math.Pow((y - avg2), 2.0));

    var result = sum1 / Math.Sqrt(sumSqr1 * sumSqr2);

    return result;
}

Usage:

var values1 = new List<double> { 3, 2, 4, 5 ,6 };
var values2 = new List<double> { 9, 7, 12 ,15, 17 };

var result = ComputeCoeff(values1.ToArray(), values2.ToArray());
// 0.997054485501581

Debug.Assert(result.ToString("F6") == "0.997054");

Another way is to use the Excel function directly:

var values1 = new List<double> { 3, 2, 4, 5 ,6 };
var values2 = new List<double> { 9, 7, 12 ,15, 17 };

// Make sure to add a reference to Microsoft.Office.Interop.Excel.dll
// and use the namespace

var application = new Application();

var worksheetFunction = application.WorksheetFunction;

var result = worksheetFunction.Correl(values1.ToArray(), values2.ToArray());

Console.Write(result); // 0.997054485501581

More Related Contents:

  1. Determine if a number can be made with prepicked numbers and times
  2. How to convert UTF-8 byte[] to string
  3. Reading CSV file and storing values into an array
  4. Remove element of a regular array
  5. How do I clone a range of array elements to a new array?
  6. How to delete an element from an array in C#
  7. printing all contents of array in C#
  8. Easiest way to compare arrays in C#
  9. How do I concatenate two arrays in C#?
  10. How do arrays in C# partially implement IList?
  11. .NET / C# – Convert char[] to string
  12. How do I convert struct System.Byte byte[] to a System.IO.Stream object in C#?
  13. Why we have both jagged array and multidimensional array?
  14. Declare a const array
  15. Check if a value is in an array (C#)
  16. Why do C# multidimensional arrays not implement IEnumerable?
  17. Overhead of a .NET array?
  18. How to “flatten” or “index” 3D-array in 1D array?
  19. How can I print the contents of an array horizontally?
  20. What is the use of the ArraySegment class?
  21. Conversion from List to array T[]
  22. .Net Data structures: ArrayList, List, HashTable, Dictionary, SortedList, SortedDictionary — Speed, memory, and when to use each? [closed]
  23. Sorting an array of folder names like Windows Explorer (Numerically and Alphabetically) – VB.NET
  24. How to get a dimension (slice) from a multidimensional array
  25. Difference between the System.Array.CopyTo() and System.Array.Clone()
  26. Operator ‘==’ cannot be applied to operands of type ‘char’ and ‘string’
  27. Why do arrays in .net only implement IEnumerable and not IEnumerable?
  28. Using XmlSerializer with an array in the root element
  29. Is it possible to extend arrays in C#?
  30. How to copy a row of values from a 2D array into a 1D array?

Leave a Comment