How to calculate Covariance.P with #value?

Highlighted
Occasional Contributor

Hi! How do I calculate the covariance when the beginning of the data set has #value? 

See attached file below cell B208 

1 Reply
Highlighted

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.