Hi all,
I have a problem reagrding statistics/bar graphs using multiple response columns. As an example, I will use the Big Class Families data table, and I'm using JMP18.
I want to plot the fraction of persons, which have visited specific countries, for simplicity I restricted the age to 14. I made a graph builder with the following script:
Graph Builder(
Size( 1097, 475 ),
Legend Position( "Right" ),
Fit to Window( "Off" ),
Summary Statistic( "Median" ),
Order Statistic( "Median" ),
Variables( X( :countries visited ), Group X( :age ) ),
Elements(
Bar(
X,
Legend( 5 ),
Summary Statistic( "N" ),
Label( "Label by Percent of Total Values" )
),
Caption Box( X, Legend( 6 ), Summary Statistic( "Median" ) )
),
Local Data Filter(
Add Filter(
columns( :age ),
Where( :age == 14 ),
Display( :age, N Items( 6 ) )
)
)
);
The percentage labels on the bar plot show values of 9.1 and 18% for counts of 1 and 2, respectively. I would expect (correct me if I'm wrong) to have a value of 1/12~ 8.3% and 2/12 ~ 17% if the percentage is calculated with the number of persons in the respective age (12) as a base value. For some reason, JMP seems to use the number of responses as the base value for the percentage calculation (which is 11 in this case, so 1/11 ~ 9.1% and 2/11 ~ 18%)
Is it intended, that the number of responses is used as a base value for such calculation with Multiple Response columns instead of the number of respective rows? What is the best practice to plot the values like I intend (percentage respective to the number of rows as labels)?
maybe with Consumer Research/Categorical Response Study?
https://community.jmp.com/t5/Discussions/Question-related-to-multiple-response-variable-how-to-gener...
Open( "$SAMPLE_DATA/Big Class Families.jmp" );
Categorical(
Count Missing Responses( 1 ),
Multiple Delimited( :countries visited )
);
student's who travel a lot count N times - even in the denominator!
→ fixed
students which don't travel don't count!
→ fixed via Count Missing Responses( 1 )
and - tada! - [the statistics at the bottom]:
Open( "$SAMPLE_DATA/Big Class Families.jmp" );
Categorical(
Count Missing Responses( 1 ),
Multiple Delimited( :countries visited ),
Legend( 0 ),
Local Data Filter(
Close Outline( 1 ),
Add Filter(
columns( :age ),
Where( :age == 14 )
)
)
);