topic fit y by x question: show equation on chart in Discussions

fit y by x question: show equation on chart

stevend1219 — Sun, 11 Jun 2023 11:29:51 GMT

Hi all JMP experts,

The equation along with R^2 are shown below in summary and it takes twice copy/paste to copy both the chart & summary to my slide.

So Is it possible to show the fitting equation & R-square on chart? The feature is feasible in Excel.

Thanks!

Re: fit y by x question: show equation on chart

txnelson — Mon, 05 Dec 2022 06:49:36 GMT

There are a couple of ways to handle this. With Fit Y by X, a little script can be added that can add the desired stats onto the graph. Secondly, the Graph Builder has the feature you are looking for as a build in capability.

Re: fit y by x question: show equation on chart

stevend1219 — Tue, 06 Dec 2022 02:13:15 GMT

Hi Jim, Thanks for the feedback! Could you give me a hint how the script looks like? Usually I start scripting by the template of functionality in GUI -> save to script, but not for this one because I couldn't find it in GUI. Thank you!

Re: fit y by x question: show equation on chart

txnelson — Tue, 06 Dec 2022 02:34:56 GMT

Here is a simple example.

I developed it interactively by using the Customize Graph designer dialog box available by right clicking on the graph and selecting "Customize".

Once I developed the code, using the Text Template, I then had JMP generate the complete JSL, see below.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

Bivariate(
	Y( :height ),
	X( :weight ),
	Fit Line( {Line Color( {212, 73, 88} )} ),
	SendToReport(
		Dispatch(
			{},
			"Bivar Plot",
			FrameBox,
			{Add Graphics Script(
				4,
				Description( "" ),
				Text(
					Center Justified,
					{75, 67},
					"R2 = " || Char( Round( (Current Report()[Number Col Box( 1 )] << get)[1], 5 ) )
				)
			)}
		)
	)
);

Re: fit y by x question: show equation on chart

pmroz — Tue, 06 Dec 2022 19:06:49 GMT

Here's an example with Graph Builder:

Note that I left the control panel open so you could see the options to display the line of fit.

Here's the code:

Graph Builder(
	Size( 909, 580 ),
	Variables( X( :weight ), Y( :height ) ),
	Elements(
		Points( X, Y, Legend( 5 ) ),
		Line Of Fit(
			X,
			Y,
			Legend( 7 ),
			Confidence of Prediction( 1 ),
			Root Mean Square Error( 1 ),
			R²( 1 ),
			Equation( 1 ),
			F Test( 1 )
		)
	)
);

Re: fit y by x question: show equation on chart

stevend1219 — Wed, 14 Dec 2022 14:47:07 GMT

Hi Jim, Thanks, it works, but encounter another problem: I'd like to use variables in the "{75, 67}," i.e. the position but seems the variables cannot be passed into the function. I need to use variable instead of fixed value because the text position should depend on x/y scale, which differs chart by chart.

Something like this: the my_pos_lst seems cannot be successfully fed into the function. Do you have any idea? Thanks!!

my_pos_lst = {100, 100};

Bivariate(
	///...
			{Add Graphics Script(
				4,
				Description( "" ),
				Text(
					Center Justified,
					my_pos_lst,
					"R2 = " || Char( Round( (Current Report()[Number Col Box( 1 )] << get)[1], 5 ) )
				)
			)}
		)
	)
);

Re: fit y by x question: show equation on chart

stevend1219 — Wed, 14 Dec 2022 14:49:23 GMT

oh BTW, I've used evallist(my_pos_lst) whether outside or inside Bivariate function, but it still doesn't work.

Re: fit y by x question: show equation on chart

txnelson — Wed, 14 Dec 2022 16:54:45 GMT

It works for me

It just isn't in the default range for the chart, so I had to scroll up to 100 on the Y axis to see it