Choose Language Hide Translation Bar
Highlighted
Level I

## categorical response analysis report show percentage of response for each response value

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
Super User

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

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.

Highlighted
Super User

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

or....to stay in categorical use the structured tab:

to get....

5 REPLIES 5
Highlighted
Super User

## 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
Level I

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

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
Super User

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

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.

Highlighted
Super User

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

or....to stay in categorical use the structured tab:

to get....

Highlighted
Level I

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

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

Article Labels