[travisweiland@gmail.com]

I know that empty cells are treated as missing in CODAP and not graphed or included in calculations but are there other ways of designating values as missing in CODAP? For example, if I have different ways that data might be considered missing are there ways of coding it differently so it is clear in the table why the data is missing but is also not graphed or included in calculations?

 

Thanks,

Travis

[Dan Damelin]

By default CODAP will try to determine the if an attribute is categorical or numeric. If any cell has a non-numeric value then the attribute is assumed to be categorical for graphs. However, you can click on the attribute, “Edit Attribute Properties…” and set it to be numeric. In that case the graph will only include numeric cells.

Regarding formulas that require numerical inputs, most will ignore non-numeric cells when calculating values. For, example, the mean of a set of values with mixed numerical and non-numerical cells will just include the numerical cells. See example below:

https://codap.concord.org/releases/latest/static/dg/en/cert/index.html#shared=https%3A%2F%2Fcfm-shared.concord.org%2FU7VigLZ5YR8RI24SD5Kz%2Ffile.json

[travisweiland@gmail.com]

Thank you that is super helpful!

[Author]

Posts