cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
WanCine
Level II

How to re-scale graph and generate Min, Max and Standard Deviation?

Hi Guys,

Need your expertise to solve this problem.

First of all, I generate data analysis by using JMP script. However, I got 4 data group which are Site 1,2,3 and 4. For each site, i would like to display the min, max and standard deviation value. Do you have any idea how to display that value on this graph by using script?

WanCine_2-1605168651496.png

Secondly, I set scale for this graph by using high and low limit to check the measured data still within the range or not. But in case the measured value is out of limit, the graph is not re-scale and I can't see that value. Is there any method to re-scale this graph by maintaining high/low limit line?

Third, is there any chance I can see the value directly by pointing at the graph? Just like below figure.

WanCine_3-1605169221901.png

Here I attach portion of my script for displaying that graph:

New Window( "F01 - EMP Measurement Systems Analysis by site_num",
	V List Box(
		EMP Measurement Systems Analysis(
			Y( :Name( "0:" ) ),
			X( :site_num ),
			Part( :part_id ),
			Model( Crossed ),
			Dispersion Chart Type( Range ),
			Average Chart(
				1,
				Show Control Limits( 0 ),
				Show Control Limits Shading( 0 )
			),
			Max Iter( 100 ),
			Conv Limit( 0.00000001 ),
			SendToReport(
				Dispatch(
					{"Average Chart"},
					"2",
					ScaleBox,
					{ Min(0.9), Max(4.1), Add Ref Line( 0.9, "Solid", "Red", "", 5 ),
					Add Ref Line( 4.1, "Solid", "Red", "", 5 )}
				)
			)
		),

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
WanCine
Level II

Re: How to re-scale graph and generate Min, Max and Standard Deviation?

		Tabulate(
			Show Control Panel( 0 ),
			Add Table(
				Column Table(
					Analysis Columns( Column( dtopen,  param[n] ) ),
					Statistics( Max, Median, Min, Mean, Std Dev )
				),
				Row Table( Grouping Columns( Column( dtopen, groupby ) ) )
			)

Thanks Ian. I change the method to display the min, max and sd by generating table using this code. For re-scaling, i take max and min data from column and do if,else case.

View solution in original post

3 REPLIES 3
ian_jmp
Level X

Re: How to re-scale graph and generate Min, Max and Standard Deviation?

You can get most of what you want just through point and click (which could be scripted if need be). See the code below to get an idea. But if you want to put the summary stats in the FrameBox (rather than in a table) you will have to write some more code.

NamesDefaultToHere(1);

// Sample data
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

// Label by the variable we will plot
Column(dt, "NPN1") << Label(1);

// Variablity chart (double click on the vertical axis and look at the properties)
v = dt <<
Variability Chart(
	Y( :NPN1 ),
	X( :SITE ),
	Variability Summary Report( 1 ),
	Std Dev Chart( 0 ),
	SendToReport(
		Dispatch(
			{"Variability Chart for NPN1"},
			"2",
			ScaleBox,
			{Min( 80 ), Max( 150 ), Inc( 10 ), Minor Ticks( 4 ),
			Add Ref Line( 0, "Dotted", "Medium Light Gray", "", 1 ),
			Add Ref Line( 90, "Solid", "Medium Dark Red", "Low Limit", 1 ),
			Add Ref Line( 140, "Solid", "Medium Dark Red", "High Limit", 1 )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"Mean",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"CV",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"Std Err Mean",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"Lower 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"Upper 95%",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"Range",
			NumberColBox,
			{Visibility( "Collapse" )}
		),
		Dispatch(
			{"Variability Chart for NPN1", "Variability Summary for NPN1"},
			"Median",
			NumberColBox,
			{Visibility( "Collapse" )}
		)
	)
);

 

Craige_Hales
Super User

Re: How to re-scale graph and generate Min, Max and Standard Deviation?

WanCine
Level II

Re: How to re-scale graph and generate Min, Max and Standard Deviation?

		Tabulate(
			Show Control Panel( 0 ),
			Add Table(
				Column Table(
					Analysis Columns( Column( dtopen,  param[n] ) ),
					Statistics( Max, Median, Min, Mean, Std Dev )
				),
				Row Table( Grouping Columns( Column( dtopen, groupby ) ) )
			)

Thanks Ian. I change the method to display the min, max and sd by generating table using this code. For re-scaling, i take max and min data from column and do if,else case.