This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

- JMP User Community
- :
- Discussions
- :
- N categories statistics and grouping in summary tables

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content

Created:
Apr 20, 2023 12:17 PM
| Last Modified: Jun 10, 2023 08:00 PM
(614 views)

Hello,

I would like to ask about summary tables.

I have a grouping variable and i want to use the N categories statistic to get the count for each group.

If the column I will use for the N categories statistic has a value that appears on multiple groups of the grouping variable will the N categories count include them all, once for each group or will it only keep it once, the first time it appears in any group and it will not be counted for the rest of the groups.

Hope my wording is not confusing.

Best Regards and thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content

I would try it on a sample case, to prove to yourself that it is working the way you want it to.

Jim

4 REPLIES 4

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content

It will be counted in the N Statistic for each of the Grouping it is found in.

Jim

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content

Good morning,

Thank you for the reply.

To make sure I understood correctly. I should choose just N instead of the N categories statistic?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content

I would try it on a sample case, to prove to yourself that it is working the way you want it to.

Jim

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content

I tried with few data points (used duplicates as well to make sure) and N categories:

-doesn't count duplicates (as was expected) and

-if a value appears in multiple groups, in the summary table it is counted once for every group.

So no data other than the duplicates are left out.

Thank you very much for the recommendation.

- © 2024 JMP Statistical Discovery LLC. All Rights Reserved.
- Terms of Use
- Privacy Statement
- About JMP
- JMP Software
- JMP User Community
- Contact