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

- JMP User Community
- :
- Discussions
- :
- categorical response analysis report show percentage of response for each respon...

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

Highlighted

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

Aug 19, 2020 8:35 AM
(314 views)

Under categorical response analysis report, how can I show percentage of response for each response value. For example (see the report below), how to include percentage of response for each preference group (1, 2, or 3), i.e. calculate column-wise percentage. Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions

Highlighted
Ah, so right...since preference group is your response all %s are calculated in terms of the preference group. To get the %s in terms of gender either swap your response and grouping variable or use Fit Y by X to get a full contingency table.

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

Highlighted

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

5 REPLIES 5

Highlighted
##

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

Re: categorical response analysis report show percentage of response for each response value

There is a red triangle option called "crosstab transposed". That will transpose the table and provide those %s. Otherwise if you use fit y-by-x you will get a cross tab with row, column, and total %s.

Highlighted
##

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

Re: categorical response analysis report show percentage of response for each response value

Created:
Aug 24, 2020 9:57 AM
| Last Modified: Aug 24, 2020 10:02 AM
(259 views)
| Posted in reply to message from KarenC 08-22-2020

Thanks @KarenC. However "crosstab transposed" doesn't give me what I wanted. It simply transposed the table. What I want is to get percentage of response for each gender by each preference group (1, 2, or 3), i.e. calculate column-wise percentage. For example, the % number in the 1-1 cell should be 54/(54+62)=46.55%.

Highlighted
Ah, so right...since preference group is your response all %s are calculated in terms of the preference group. To get the %s in terms of gender either swap your response and grouping variable or use Fit Y by X to get a full contingency table.

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

Highlighted

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

Highlighted
##

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

Re: categorical response analysis report show percentage of response for each response value

Created:
Aug 24, 2020 11:08 AM
| Last Modified: Aug 24, 2020 11:14 AM
(242 views)
| Posted in reply to message from KarenC 08-24-2020

Thanks, @KarenC. Fit Y by X or the Structured Tab in Consumer Research > Categorical solves my problem.