topic Re: How to use N missing values in a distribution frequencies table in Discussions

How to use N missing values in a distribution frequencies table

Ekarshalev — Sat, 10 Jun 2023 23:59:42 GMT

Hello All,

I have a large table where I have empty cells in some places. I am doing a count using the distribution -> frequencies table. However, the probability is based only on the cells with a value inside. The frequencies table still prints out how many values are missing ("N missing"). I was hoping to be able to put that value in the combined table I make from the frequencies table.

Any help is appreciated.

Here is an example of what I am talking about

Re: How to use N missing values in a distribution frequencies table

dale_lehman — Thu, 30 Mar 2023 19:16:11 GMT

Why not just recode that column so that missing becomes "missing" and then that will appear in the graph as a category?

Re: How to use N missing values in a distribution frequencies table

txnelson — Thu, 30 Mar 2023 19:21:50 GMT

You can easily do this using Transformation variables.

In the dialog box for the Distribution, simply right click and create a virtual transformational variable; If you specify the formula as in the example, you can use that new virtual variable for the distribution.

To do this is JSL, here is an example

Distribution(
	Transform Column(
		"sex expanded",
		Nominal,
		Set Property( "Value Order", {Numerical Order( 0 )} ),
		Formula( If( :sex == "", "Missing", :sex ) )
	),
	Nominal Distribution( Column( :sex expanded ) )
);

Re: How to use N missing values in a distribution frequencies table

Chris_Kirchberg — Thu, 30 Mar 2023 20:13:33 GMT

Aside from recoding as mentioned by others, it might be worth while to add to the JMP Wish List a request for an option to display missing values as a category/level in distributions and other places where categorical data is used.

Re: How to use N missing values in a distribution frequencies table

Ekarshalev — Thu, 30 Mar 2023 22:48:59 GMT

Thanks txnelson,

This seems like a pretty easy way to do it.

Re: How to use N missing values in a distribution frequencies table

Ekarshalev — Thu, 30 Mar 2023 22:49:31 GMT

Thx dale,

I have not played with recoding much but it seems like a pretty fast solution.

Re: How to use N missing values in a distribution frequencies table

Ekarshalev — Thu, 30 Mar 2023 22:49:49 GMT

Thanks Chris,

I will be sure to do that