Plotting Nonlinear Regression using GraphBuilder and/or Analyze (with scripts)

wendy1123

This post is similar to this one, and I posted a comment there, but since the post is 2 years old it might not get seen and I'm having trouble adapting the solution(s) to my equation.

 

I'm doing nonlinear regression using the script below to prepare the data and then using the Analyze option with Normalized Fluorescence as the Y value, and the Model (formula) column as the X value (reversing the axis), and by Well Position, but this only does one at a time. If I use the GraphBuilder, I can't get the Smoother to use the formula . I would like to have all the plots on one graph OR in an absolutely ideal unicorn world, graph 3 well positions at a time (eg. B2-B4) but that seems unrealistic

 

Data Table( "Melt Curve Raw Data" ) << New Column( "Normalized Fluorescence",
formula(
(:Fluorescence - Col Min( :Fluorescence, :Well Position )) / (
Col Max( :Fluorescence, :Well Position )
-Col Min( :Fluorescence, :Well Position ))
)
);

Data Table( "Melt Curve Raw Data" ) << New Column( "Model", Numeric, 
"Continuous", Format( "Best", 12 ), 
Formula(Parameter({m1 = -60, m2 = 0.2, m3 = -50, m4 = -0.3, m5 = 100000, m6 = 320}, 
((m1 + m2 * (:Temperature + 273)) + (m3 + m4 * (:Temperature + 273)) * Exp((-m5 / (1.987 * 
(:Temperature + 273))) * (1 - (:Temperature + 273) / m6))) / 
(1 + Exp((-m5 / (1.987 * (:Temperature + 273))) * (1 - (:Temperature + 273) / m6))))));

Melt Curve Raw Data.jmp

ih

I can't tell exactly what you are looking for, by chance does one of these charts show what you are looking for, or can you post a screenshot of the chart that only does one at a time?  You said you used Analyze, but I'm not sure which option in that menu you picked.

 

Graph Builder(
	Size( 671, 507 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Model ),
		Y( :Normalized Fluorescence ),
		Overlay( :Well Position )
	),
	Elements( Smoother( X, Y, Legend( 12 ) ), Points( X, Y, Legend( 13 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :Well Position ),
			Where( :Well Position == {"B2", "B3", "B4"} ),
			Display( :Well Position, N Items( 15 ), Find( Set Text( "" ) ) )
		)
	)
);

Graph Builder(
	Size( 671, 543 ),
	Show Control Panel( 0 ),
	Variables( X( :Model ), Y( :Normalized Fluorescence ), Wrap( :Well Position ) ),
	Elements( Points( X, Y, Legend( 9 ) ), Smoother( X, Y, Legend( 11 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :Well Position ),
			Where( :Well Position == {"B2", "B3", "B4"} ),
			Display( :Well Position, N Items( 15 ), Find( Set Text( "" ) ) )
		)
	)
);

Graph Builder(
	Size( 1308, 384 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Model ),
		Y( :Normalized Fluorescence ),
		Group X( :Well Position )
	),
	Elements( Smoother( X, Y, Legend( 12 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :Well Position ),
			Where( :Well Position == {"B2", "B3", "B4"} ),
			Display( :Well Position, N Items( 15 ), Find( Set Text( "" ) ) )
		)
	)
);