topic Re: Show means on box plot in graph builder in Discussions

Show means on box plot in graph builder

twillkickers — Tue, 14 Aug 2018 20:34:48 GMT

Is there any way to show and connect means on a box plot in graph builder? Is there also a way to show the diamonds that point to the mean without bottom and top 5% of outliers?

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 15 Aug 2018 03:04:14 GMT

Right click on the graph builder frame box and select Customize. Then select a box and there is a check box for Confidence Interval.

Via the UI you have to edit each box. Below is a picture with several options that you can select.

However, it is much easier to do this via a script. The script to create the picture below is attached.

Re: Show means on box plot in graph builder

Thomas1 — Wed, 15 Aug 2018 05:54:54 GMT

I'm also interested in this topic. What is the best way to show the numeric mean of each box at the corresponding box?

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 15 Aug 2018 07:25:07 GMT

The attached script has been updated. Note this script shows hardcoded column names and rounding units, it does not include data prep etc. Both the mean and n has been added

Re: Show means on box plot in graph builder

Thomas1 — Wed, 15 Aug 2018 07:59:06 GMT

Thanks. That is a great solution. Is there a way to do this without scripting, by using default built in features in JMP?

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 15 Aug 2018 09:40:05 GMT

Right click on the Graph Builder Frame Box. Select Customize. Select the plus sign (+) above the list of boxplots.

Select the Templates menu above the Script Box, and select Text, then fill in the information. Select Text again and add the information for the next box. Note there is an option available in JMP 14 Graph Builder boxplots to show the 5 number summay for the box, but that does not include the mean.

Re: Show means on box plot in graph builder

Thomas1 — Wed, 15 Aug 2018 13:51:49 GMT

Thanks for your advice on how to customize graphs. What are the 5 numbers within the 5 Numbers Summary in JMP 14? Could you display an example? Unfortunately I don't have access to JMP 14 yet.

Re: Show means on box plot in graph builder

Dan_Obermiller — Wed, 15 Aug 2018 15:57:56 GMT

I think the easiest way to get the mean labeled on the boxplot graph is to add another element. Use the Shift-click on the bar chart icon. Make sure that the summary statistic for the bar chart is the Mean. Change the bar style to "Float". You then have the option to "Label by Value". All interactive and provides the label. Enclosed is an example using Big Class Families (with the control panel still on so you can see those options).

Re: Show means on box plot in graph builder

Thomas1 — Wed, 15 Aug 2018 17:59:59 GMT

Thanks Dan. That is great way to show the mean right at the box plot.

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 15 Aug 2018 18:31:00 GMT

Thank you, Dan. I never investigated Float bar type. Your post got me thinking of alternative methods to add the means and hav them appear at the bottom or the top of the graph.

One method was interesting but messy and changed the original table. [See *** below]. Then I notoced that JMP has a new element called a Caption Box. It is very cool, but each Caption Box seems to allow only one caption per FrameBox. This can be easy by making the categorical X-axis the X Group variable. See the picture and script. However, now the connected means gets tough. This might be a nice wish list item for future versions: add a caption box option for nominal X-axis plots. So for boxplots, one option could be the Five number Summary another N, Mean, Std dev.

gb2 = dt << Graph Builder(
	Size( 1065, 516 ),
	Show Control Panel( 0 ),
	Variables( Y( :Sales ), Group X( :Month ) ),
	Elements(
		Box Plot( Y, Legend( 6 ), Box Style( "Solid" ) ),
		Line( Y, Legend( 7 ) ),
		Caption Box( Y, Legend( 9 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Sales",
			ScaleBox,
			{Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )}
		),
	
	)
);
bpseg = gb2 << Xpath("//BoxPlotSeg");
bpseg << {Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 )};

//if you want to color each by month
for(i=1, i<=nitems(bpseg), i++,
 bpseg[i] << Fill Color(Color Of(As Row State(cc[i])))	
);

The full script is attached.

***Method takes some work all UI. I might do this once. Scripting seems easier, especially if the Caption Box wish

Concatenate the original table and the table summary.
Add a column called Means that is really the positon where you want the means to appear.
Make the Mean(Sales) column a label.
Plot both Sales and Means versus Month
Move Mean sales to the right and align tick marks
Make the changes as shown previously for the left axis (chaging points to the boxplot, add a line)
Change the Points on the right to a bar style single and Label ("Label by Row")

Re: Show means on box plot in graph builder

Thomas1 — Wed, 15 Aug 2018 20:10:25 GMT

@gzmorgan0 wrote:
Thank you, Dan. I never investigated Float bar type. Your post got me thinking of alternative methods to add the means and hav them appear at the bottom or the top of the graph.

One method was interesting but messy and changed the original table. [See *** below]. Then I notoced that JMP has a new element called a Caption Box. It is very cool, but each Caption Box seems to allow only one caption per FrameBox. This can be easy by making the categorical X-axis the X Group variable. See the picture and script. However, now the connected means gets tough. This might be a nice wish list item for future versions: add a caption box option for nominal X-axis plots. So for boxplots, one option could be the Five number Summary another N, Mean, Std dev.
@gzmorgan0 wrote:
Thank you, Dan. I never investigated Float bar type. Your post got me thinking of alternative methods to add the means and hav them appear at the bottom or the top of the graph.

One method was interesting but messy and changed the original table. [See *** below]. Then I notoced that JMP has a new element called a Caption Box. It is very cool, but each Caption Box seems to allow only one caption per FrameBox. This can be easy by making the categorical X-axis the X Group variable. See the picture and script. However, now the connected means gets tough. This might be a nice wish list item for future versions: add a caption box option for nominal X-axis plots. So for boxplots, one option could be the Five number Summary another N, Mean, Std dev.
gb2 = dt << Graph Builder(
	Size( 1065, 516 ),
	Show Control Panel( 0 ),
	Variables( Y( :Sales ), Group X( :Month ) ),
	Elements(
		Box Plot( Y, Legend( 6 ), Box Style( "Solid" ) ),
		Line( Y, Legend( 7 ) ),
		Caption Box( Y, Legend( 9 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Sales",
			ScaleBox,
			{Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )}
		),
	
	)
);
bpseg = gb2 << Xpath("//BoxPlotSeg");
bpseg << {Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 )};

//if you want to color each by month
for(i=1, i<=nitems(bpseg), i++,
 bpseg[i] << Fill Color(Color Of(As Row State(cc[i])))	
);
The full script is attached.

***Method takes some work all UI. I might do this once. Scripting seems easier, especially if the Caption Box wish
Concatenate the original table and the table summary.
Add a column called Means that is really the positon where you want the means to appear.
Make the Mean(Sales) column a label.
Plot both Sales and Means versus Month
Move Mean sales to the right and align tick marks
Make the changes as shown previously for the left axis (chaging points to the boxplot, add a line)
Change the Points on the right to a bar style single and Label ("Label by Row")
You can add as much caption boxes as you want by drag & drop. By default they are displaying the mean. This however can be changed to Std Dev, N etc.
However, in case of the mean, I prefer to show him at the box plot.
gb2 = dt << Graph Builder(
	Size( 1065, 516 ),
	Show Control Panel( 0 ),
	Variables( Y( :Sales ), Group X( :Month ) ),
	Elements(
		Box Plot( Y, Legend( 6 ), Box Style( "Solid" ) ),
		Line( Y, Legend( 7 ) ),
		Caption Box( Y, Legend( 9 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Sales",
			ScaleBox,
			{Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )}
		),
	
	)
);
bpseg = gb2 << Xpath("//BoxPlotSeg");
bpseg << {Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 )};

//if you want to color each by month
for(i=1, i<=nitems(bpseg), i++,
 bpseg[i] << Fill Color(Color Of(As Row State(cc[i])))	
);
The full script is attached.

***Method takes some work all UI. I might do this once. Scripting seems easier, especially if the Caption Box wish
Concatenate the original table and the table summary.
Add a column called Means that is really the positon where you want the means to appear.
Make the Mean(Sales) column a label.
Plot both Sales and Means versus Month
Move Mean sales to the right and align tick marks
Make the changes as shown previously for the left axis (chaging points to the boxplot, add a line)
Change the Points on the right to a bar style single and Label ("Label by Row")

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 15 Aug 2018 21:51:16 GMT

I am learning on the fly. JMP 14 already has a feature that fulfilled my wish list: the CaptionBox has a factor checkbox so it work for each category displayed on the X-Axis.

This displays the 5 number summary (min, Q1, Median, Q3, max) and the means as a caption box.

Here is the script showing the customization, for just the first boxplot.

Graph Builder(
	Size( 1029, 608 ),
	Show Control Panel( 0 ),
	Variables( X( :Month ), Y( :Sales ) ),
	Elements(
		Box Plot( X, Y, Legend( 6 ), Name( "5 Number Summary" )(1) ),
		Line( X, Y, Legend( 7 ) ),
		Caption Box(
			X,
			Y,
			Legend( 9 ),
			X Position( "Middle" ),
			Y Position( "Bottom" ),
			Per Factor( 1 )
		)
	),
	SendToReport(
		Dispatch(
			{},
			"Sales",
			ScaleBox,
			{Min( 50 ), Max( 700 ), Inc( 100 ), Minor Ticks( 1 )}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{DispatchSeg(
				Box Plot Seg( "Box Plot (June)" ),
				{Box Style( "Solid" ), Confidence Diamond( 1 ), Fences( 0 ),
				Fill Color( {162, 43, 221} )}
.....

Re: Show means on box plot in graph builder

DANN — Wed, 16 Jan 2019 01:35:22 GMT

Hi, I'm having a trouble with making a line connecting all those middle value of each of box plots. What do I do?

Thanks in advance

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 16 Jan 2019 01:46:03 GMT

@DANN, please specify which version of JMP you are using. Also, if you could use the Graphbuilder menu pull down, and select Save Script, Copy script or save to Script Window and save it and attach in a reply, I can look to see if you missed something.

Re: Show means on box plot in graph builder

DANN — Wed, 16 Jan 2019 02:23:25 GMT

Hi, I appreciate your comment. I'm a user of JMP Pro 14 and I'm afraid I can't upload the script you said. Because of e-scecurity program in my office, I can't upload any file online. if it's enough to describe what I've done to get a way, then I would. Thanks again.

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 16 Jan 2019 03:20:57 GMT

Okay, describe your steps. Hopefully, I can see what might be missing.

Re: Show means on box plot in graph builder

DANN — Wed, 16 Jan 2019 04:55:20 GMT

Okay, thank you for your patience.
There's four column and each has twenty different values.
ex) Design 1 2 3 4
1 a .. .. ..
2 b .. .. ..
3 c
4 ..
5
6
...
20
First, I opend Graph Builder.
Second, I dragged those four columns into x-axis( default box plot ). As a result, I got four different box plots.
at this point, I want to get the line connecting the median of each box plot. What should I do?
Thanks in advance.

Re: Show means on box plot in graph builder

gzmorgan0 — Wed, 16 Jan 2019 11:09:57 GMT

@DANN, are the 4 columns responses (results) of the experiment or factors (input) for the design?

As your table is setup, it would take a custom function to connect the box medians, since you have no Y variable. I am going to use the JMP sample data Iris.JMP to emulate your data and the steps.

If using the UI (point and click):

Select Tables > Stack choose your 4 columns as the Stack Columns, change the names (Data and Label) if you like and select OK. Data will be the values of the 4 columns and Values will be the column names. For your example a better name than label might be Factors or Responses.
Now select Graphs > Graphbuilder and drag Data to the Y column and Label to the X column.
Right Click and select Box Plots and Line and select the Summary Statistics to be Median

Here is a picture of the Iris data table after following the instructions above

Without stacking the data, I can only provide a JSL solution. My earlier post/example had one or multiple columns for Y and and a categorical X (Months). The elements Line or Smoother need both and X and Y. There is another graph called the parallel plot that would be appropriate if your 4 columns were responses to an experiment. Each of the 20 lines would represent a "profile" of each experimental trial's results.

Hope that helps.

Re: Show means on box plot in graph builder

DANN — Wed, 16 Jan 2019 23:46:42 GMT

@gzmorgan0 Oh My Gosh, It just was A perfect solution that I really needed. Now everything's preperly working with no problem. I really appreciate your kindness and expertise. Thank you so much! Have a great day.

Re: Show means on box plot in graph builder

Jeff_Perkinson — Thu, 30 Jan 2020 19:16:25 GMT

This is easily done interactively.

Start with the box plots turned on. Then click and drag the points element into the graph. Change the summary statistic for the points to mean. Then drag the line element into the graph.