I am working with the lines:
ArrX = Application.WorksheetFunction.Index(X, 0, 2)
ArrTemp = Application.WorksheetFunction.Index(TempSample, 0, 2)
DistanceMeasure = (1 - Application.WorksheetFunction.Correl(ArrX, ArrTemp)) * 100
I would like to be able to run a simple correlation using...