nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

WanCine

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?

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.

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.

Accepted answers

WanCine

		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.

All comments

ian_jmp

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

Use Summary to Automatically Add Reference Lines to Graph Builder

WanCine

		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.