Checking Numeric Data for Errors Using Excel

Published: 27 March 2022
on channel: Lonrix

In this video we look at how to use Excel for thoroughly check numeric data values for errors or inconsistencies. We present an approach to (a) check whether the data matches one of a list of values that represent a "null" or "missing data" case; next, (b) we check for invalid numeric data; finally (c) we clamp the value to an acceptable range of minimum and maximum values.
This video is useful if you are using the JunoViewer ICC template. It is also useful for the new Juno-Cassandra (or "JCass") pre-processing workflow.

On this page of the site you can watch the video online Checking Numeric Data for Errors Using Excel with a duration of hours minute second in good quality, which was uploaded by the user Lonrix 27 March 2022, share the link with friends and acquaintances, this video has already been watched 56 times on youtube and it was liked by 1 viewers. Enjoy your viewing!

13,912

323