cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Including the missing values as a category/level in distributions

Hello,

I have been working with distributions recently and while JMP makes it very easy to slice my data in different ways I have ran into the problem of sometimes having empty cells under some of the binning conditions. That being said I am doing counting of certain cells by their frequency and found it very useful to be able to normalize the counted cells by the total cells per each category which is sometimes a different number. Right now a distribution shows the number of missing cells per each category but you cannot save it in a further data table.

I believe it would be very useful to have the missing values listed as a category or level in distributions so that it can be easily used in subsequent analyses.

here is an example

Ekarshalev_0-1680216814077.png

 

 

1 Comment
jwiltsie
Level III

My reason is different: I want to be able to select the missing data in different columns, but adding a missing category bin would be very helpful for this also. This could be a red triangle option like it is in Graph Builder's "Include Missing Categories" (see screenshot below). Please, add this same option to the Distribution platform so the missing level can show up in the histogram for data with nominal modeling type. I see the "N missing" listed in the "Frequencies" table but it is not selectable to highlight the rows.

jwiltsie_2-1752248517601.png