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

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

eijoac — Fri, 09 Jun 2023 00:20:11 GMT

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.

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

KarenC — Sat, 22 Aug 2020 17:01:49 GMT

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.

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

eijoac — Mon, 24 Aug 2020 17:02:02 GMT

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%.

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

KarenC — Mon, 24 Aug 2020 17:13:25 GMT

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.

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

KarenC — Mon, 24 Aug 2020 17:18:13 GMT

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

to get....

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

eijoac — Mon, 24 Aug 2020 18:14:23 GMT

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