Trace:

nan

This shows you the differences between two versions of the page.

nan [Sun Oct 31 19:06:53 2010] Gray |
nan [Sun Nov 8 12:21:24 2015] |
||
---|---|---|---|

Line 1: | Line 1: | ||

- | ====== Missing Values (NaN) in Tables and Calculations ====== | ||

- | In computing, NaN, which stands for Not a Number, is a value or symbol that is usually produced as a result of an operation on invalid input operands. For example, most floating-point units are unable to explicitly calculate the square root of negative numbers, and will instead indicate that the operation was invalid and return a NaN result. | ||

- | An invalid operation is not the same as an arithmetic overflow (which returns a positive or negative infinity). Arithmetic operations involving NaN always produce NaN, allowing the value to propagate through a calculation so that errors can be detected at the end without extensive testing during intermediate stages. | ||

- | |||

- | A NaN does not compare equal to any number or NaN. You can therefore test whether a variable has a NaN value by comparing it to itself: if '' | ||

- | |||

- | ==== How does a NaN appear? ==== | ||

- | |||

- | There are three kinds of operations which return NaN: | ||

- | - Operations with a NaN as at least one operand, e.g. '' | ||

- | - Indeterminate forms | ||

- | * Divisions '' | ||

- | * Multiplications '' | ||

- | * Power '' | ||

- | * Additions '' | ||

- | - Real operations with complex results | ||

- | * Square root of a negative number | ||

- | * Logarithm of a negative number | ||

- | * Tangent of an odd multiple of 90 degrees (or //π///2 radians) | ||

- | * Inverse sine or cosine of a number which is less than -1 or greater than +1. | ||

- | |||

- | === Examples === | ||

- | ^ Expression | ||

- | | '' | ||

- | | '' | ||

- | | '' | ||

- | | '' | ||

- | | '' | ||

- | |||

- | ===== NaN in MagicPlot Tables ===== | ||

- | In MagicPlot NaN is also used to represent empty cells in [[table|Tables]]. | ||

- | |||

- | Statistical functions ignore NaN values in Tables. | ||

- | |||

- | ===== NaN in Expressions ===== | ||

- | You can use predefined constants '' | ||

- | |||

- | === Example === | ||

- | * If you set a [[set_column_formula|Column Formula]] '' |

nan.txt · Last modified: Sun Nov 8 12:21:24 2015 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International