topic Calculating & Positive Response in Discussions

Calculating & Positive Response

emma_121 — Fri, 09 Jun 2023 00:35:34 GMT

I have some Consumer Research data, in which the answer set was an agreement scale (Agree Strongly, Agree, Agree Slightly, Disagree Slightly, Disagree and Disagree Strongly). How do I combine the % totals for all the positive respondents (i.e. those that selected any of the Agree answer sets) in JMP?

I have attached an Excel example for reference.

If possible, an interactive explanation would be great.

Thanks!

Re: Calculating & Positive Response

Thierry_S — Mon, 28 Jun 2021 15:21:15 GMT

Hi,
It looks like you may be able to get what you need by simply creating a new Column with the formula: (Sum (N Agree Strongly, N Agree, N Agree Slightly)/ Total N). You can then format the output as Percent (Column Info > Format > Percent).
Is that you were looking for?
Best,
TS

Re: Calculating & Positive Response

ledi_trutna — Tue, 29 Jun 2021 13:32:09 GMT

There is a column property called Supercategories where you can define the levels of the response that you want to group together into the positive response. This property is used in the categorical platform when analyzing your survey data.

If you have multiple columns you would like to apply the supercategories property to, define it for one, and use Standardize Attributes to copy the property to the other response columns.