Hi! How do I calculate the covariance when the beginning of the data set has #value?
See attached file below cell B208
Values in AF207:AF410 are texts, don't know why. If convert to numbers, within COVARIANCE use arrays of the same size (they are different now) and eliminate errors, when
calculates something. I'm not familiar with stats to estimate is that correct result or not.
Please see in AJ2017 of the attached file.