Error Messages/42538

Example warning message

The data passed to the first parameter of the statistical function Mean contains one or more references. The result will be 'NaN'.

Description

This happens when a statistical function such as Mean or Correlation encounters a reference within the array of samples. Consider for example what the Mean of 5, 7 and «ref» would be, where the 3rd item is a reference. This situation doesn't make sense, and hence results in this warning. Ignoring the warning results in NaN.

If you want to ignore the references, you can do that explicitly, e.g.,

Mean( If IsReference(x) Then Null Else x )

See also

Comments


You are not allowed to post comments.