topic Re: Table summary: "N non-zero" ? in Discussions

Table summary: "N non-zero" ?

hogi — Sat, 10 Jun 2023 23:57:54 GMT

In the Table summary menu ...

N counts all non-Missing entries (including 0s)
N Missing counts all missing values
Sum sums the values,
which acts like ~ N non-Zero, if values are just 0 and 1

But I miss an entry

N non-Zero (which works in general ,not just for 0/1 values)

There are many applications for such an aggregation, like:

which cities had >=1 covid cases in the month/year xx/yyyy.
which wafers had >=1 defects.

It's clear that one can add aditional columns to the data table, set non-zero values to 1, and use sum as a workaround for N non-Zero,

but is there a way to get it directly via Table Summary?

Re: Table summary: "N non-zero" ?

jthi — Tue, 06 Dec 2022 11:55:11 GMT

I think most of the available summary statistics are mentioned here Using JMP > Summarize Your Data > Explanation of Summary Statistics and there is none for N Zero/N Non-Zero. Plenty of workarounds though as you said. There are most likely quite a few others which would be nice to have in Summary table (and in many other platforms, such as Tabulate and Graph Builder's Summary statistic).

Edit:

I work quite often with new (to me) data tables and that is why I wrote this add-in . It has quite many different summary statistics but it's purpose isn't really same as Summary tables.

Re: Table summary: "N non-zero" ?

hogi — Tue, 06 Dec 2022 14:51:58 GMT

Thanks for the feedback. Hm ...

edit: everything fine with median

~~Another thing which I really miss a lot in Table Summary:~~

~~Median~~

~~Sure, there is Quantiles - but with an additional Median, things would be a bit easier:~~

Re: Table summary: "N non-zero" ?

jthi — Tue, 06 Dec 2022 14:29:24 GMT

Summary does have Median (but it isn't close to Mean so it is fairly easy to miss)

Re: Table summary: "N non-zero" ?

hogi — Tue, 06 Dec 2022 14:50:10 GMT

Ah, right - there is definitely a median -- also on my system :)

looks like I got trapped in some weird belief.