topic How can I Fit y by x, with 2 By groups, to display in rows with By as columns? in Discussions

How can I Fit y by x, with 2 By groups, to display in rows with By as columns?

KurtAnderson — Tue, 26 Sep 2023 17:10:05 GMT

I have one x and multiple y. I have only 2 By groups, although I could have more and I think this question would be valid. I would like to display the y by x in columns with the By groups as columns.

After creating the plots using Fit y by x, if I choose "Arrange in rows" = 2, the default display will place all By group 1 first, then By group 2, etc. I'd like to visually observe how y1 responds to x within By group 1 side-by-side with By group 2. To plot both By groups on the same y by x, or using Graph Builder, is too messy.

Can I teach the "Arrange in rows" feature to place the By groups in parallel columns? I looked in Preferences and couldn't find a way to do it. Thanks.

Re: How can I Fit y by x, with 2 By groups, to display in rows with By as columns?

txnelson — Tue, 26 Sep 2023 18:01:06 GMT

Here is a simple method to align the output. It does assume that there are data at each x and y combination

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

nw = New Window( "Output",
	Lineup Box( N Col( 2 ),
		bivariate(
			y( :height ),
			x( :weight ),
			by( :age,:sex  )
		)
	)
);

Re: How can I Fit y by x, with 2 By groups, to display in rows with By as columns?

KurtAnderson — Tue, 26 Sep 2023 21:17:14 GMT

Thanks Jim. I'm less than a novice coder. My code results in a blank page. X and Y are continuous; By (material) is categorical. All variable names are sanitized. Thanks in advance for your help.

Fit Group(
	Lineup Box( N Col( 2 ), 
 
		Bivariate(
			Y( :"delP/delQ"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :" flow rate at 5 deg"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :" flow rate at 30 deg"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :" calc outlet (inches)"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :" wall angle (deg)"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :" rathole (inches)"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :"off gas"n ),
			X( :M wt% ),
			By( :material ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
	) 
)

Re: How can I Fit y by x, with 2 By groups, to display in rows with By as columns?

txnelson — Tue, 26 Sep 2023 21:29:02 GMT

I checked the Scripting Index, and Fit Group does not appear to support the LineUp Box(). I believe you will get what you want, if you just replace

Fit Group(

with

nw = New Window( "Output",

the results will be displayed in your 2 columns

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

nw = New Window( "Output",
	Lineup Box( N Col( 2 ), 
 
		Bivariate(
			Y( :weight ),
			X( :age ),
			By( :sex ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		),
		Bivariate(
			Y( :height ),
			X( :age ),
			By( :sex ),
			Fit Line( {Line Color( {212, 73, 88} )} )
		)
	) 
)

BTW, if you click on the JSL at the top of the Discussion Entry, and then cut and paste your JSL into the JSL Entry Window, the code is displayed in a more readable form for the Community Members