769472_en-US

liliconcom

Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

Hi,

How do I create plots with error bars based on "Fit y by x", Graph builder, other?

The question may  refer to two ways to achieve the plots:

1. The error bars can be derived from explicitly from the data by creating columns of means, upper/lower errors, from which the plots are created, for e.g. time dependent data.

2. From the raw data by grouping several variables (columns) from which the means and STD/SDE are calculated (per row) and subsequently are used to create the Y by X plot ()means with the error bars (STD/SDE).

 

I have seen some examples using the Graph Builder using Bar format as intermediate stage, however, it seem not to work for me.

 

Thanks,

 

 - Dean

 

Basic Data Analysis and ModelingData Exploration and VisualizationRe: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

What do you mean by "it seem not to work for me" so what have you already tried? Bar chart for example has many different options you can use

https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/bar.shtml#

There is also the Interval zone

https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/graph-zones.shtml#

 

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

The error bar or interval estimate is usually an option in a red triangle (context) menu. Click the red triangle to the left of the fit under the scatter plot in Bivariate (Fit Y by X). You can select dotted lines or regions for the confidence or prediction interval.

See the Essential Graphing guide for similar instructions when using Graph Builder.

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

Hi jthi and thanks.

I was referring for instance to the following sources:

https://community.jmp.com/t5/JMPer-Cable/How-to-create-custom-error-bars-in-Graph-Builder/ba-p/35611

https://community.jmp.com/t5/Discussions/X-and-Y-error-bars-in-X-Y-Plot/td-p/36135

 

for implementations that haven't worked for me (or I am missing some intermediate steps in he process).

 

Thanks again,

 

 - Dean

 

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

I have added three column to JMP's sample data Big Class (0.25, 0.75 quantile and mean)

By using Interval bar chart I can get plot like this (I left the points there for visualization purposes)

 

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

Thanks Mark.

following your reply were in the drop down menu from the red triangle:

 

can I insert/add error bars? 

How/where do I implement what you mentioned "You can select dotted lines or regions for the confidence or prediction interval" for the above bivariant figure?

 

Thanks,

 

 - Dean

 

 

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

It is the red triangle under the plot for the desired fit:

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

Thanks Mark,

To make it clear what I aim at looks like the following (created in Excel):

For sync, each exponentially decreasing line represents the mean for each of four groups (Legend) as a function of time (x-axis), and their corresponding Stds/ as the vertical lines. Simple... easily implemented via python's matplotlib package or alike, MATLAB, excel...

 

How to create such a figure from Fit Y by X, Graph Builder?

 

Thanks,

 

 - Dean

 

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

If you can share your dataset it makes it easier to demonstrate.

 

Here is one example using JMP's Big Class data table

https://www.jmp.com/support/help/en/18.0/#page/jmp/element-types-and-options.shtml

https://www.jmp.com/support/help/en/18.0/#page/jmp/points.shtml#

https://www.jmp.com/support/help/en/18.0/#page/jmp/line.shtml#

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

Hi  jhti,

 

I have attached a dataset.

 

thanks,

 

 - Dean

Re: Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

You could stack your data, rename columns, create category column. Then you can use Mean as Y, Std as Interval and the category column as Overlay

 

You can also do it from your data table but I think you will have to add multiple plots into your graph and disable variables correctly

Here is a script for that option, so you can maybe a bit easier get an idea how variables could be disabled

Graph Builder(
	Transform Column("Row", Formula(Row())),
	Size(545, 741),
	Show Control Panel(1),
	Variables(
		X(:Row),
		Y(:"Mean_Double-KO"n),
		Y(:Mean_WT, Position(1)),
		Interval(:"Std_Double-KO"n),
		Interval(:Std_WT)
	),
	Elements(
		Points(X, Y(1), Interval(1), Legend(4)),
		Points(X, Y(2), Interval(2), Legend(5)),
		Line(X, Y(1), Interval(0), Legend(6), Error Interval("None")),
		Line(X, Y(2), Interval(0), Legend(7), Error Interval("None"))
	),
	Local Data Filter(Add Filter(columns(Row), Where(:Row <= 16))),
	SendToReport(Dispatch({}, "Graph Builder", FrameBox, {Reference Line Order(6)}))
);