Mar 05 2019 02:10 AM
Hi! How do I calculate the covariance when the beginning of the data set has #value?
See attached file below cell B208
Mar 05 2019 12:51 PM
Hi,
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
=COVARIANCE.P(AF208:AF410,IFERROR(B208:B410,""))
calculates something. I'm not familiar with stats to estimate is that correct result or not.
Please see in AJ2017 of the attached file.