Percent of Factor for "X and below"

[#1]

Hi,

In JMP every row know to which bar it belongs in a bar graph. So, it's very easy to calculate % of Factor.

e.g. ratio of female and male students plotted versus age ("X"):

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" );
Graph Builder(
	Variables( X( :age ), Overlay( :sex ) ),
	Elements(
		Bar(
			X,
			Bar Style( "Stacked" ),
			Summary Statistic( "% of Factor" )
		)
	)
);

Is there an easy way to generate a plot showing the percentage of factors, with the ratio of female to male students plotted against age as "X and below"? So, for 12 years old, it would be the same ratio as above (5 vs. 3), and for 17 years old, it would be the total ratio of male and female students: 22 vs. 18.

[#2 · Accepted solution]

Workaround via summary table:

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" );


dtsum = dt << Summary(Group( :age, :sex ));
dtsum << New Column( "N cumulative", Formula( Col Cumulative sum(:N Rows, :sex)));


Graph Builder(
	Variables( X( :age ), Y( :N cumulative  ), Overlay( :sex ) ),
	Elements(
		Bar(
			X,
			Y,
			Bar Style( "Stacked" ),
			Summary Statistic( "% of Factor" )
		)
	)
);