cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar

Copy pasting means and std deviation table from a Oneway analysis.

Hello all!

 

First time posting here so I apologize if I miss anything. I wrote script which essentially creates a oneway analysis for user imported data. I was wondering if it was possible to extract (copy paste) the "Means and Std Deviations" table to a different table in JSL.

 

Ex:

OhThatArabGuy_1-1703880407651.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Copy pasting means and std deviation table from a Oneway analysis.

Here is an example that shows how to take the complete Means and Std table and create a new data table from it and also and example of how to take a specific column of the stat table and add it to the current data table.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

Oneway(
	Y( :height ),
	X( :sex ),
	Quantiles( 1 ),
	Means and Std Dev( 1 ),
	t Test( 1 ),
	Box Plots( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 )
);

theReport = current report();

// Create it own new table
theReport["Means and Std Deviations", TableBox(1)] << make into data table;

// and/or add the data to the current data table
dt << new column( "Mean" );
theMeans = theReport["Means and Std Deviations", NumberColBox(2)] << get;
dt:Mean << set values( theMeans );
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Copy pasting means and std deviation table from a Oneway analysis.

Here is an example that shows how to take the complete Means and Std table and create a new data table from it and also and example of how to take a specific column of the stat table and add it to the current data table.

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

Oneway(
	Y( :height ),
	X( :sex ),
	Quantiles( 1 ),
	Means and Std Dev( 1 ),
	t Test( 1 ),
	Box Plots( 1 ),
	Mean Error Bars( 1 ),
	Std Dev Lines( 1 )
);

theReport = current report();

// Create it own new table
theReport["Means and Std Deviations", TableBox(1)] << make into data table;

// and/or add the data to the current data table
dt << new column( "Mean" );
theMeans = theReport["Means and Std Deviations", NumberColBox(2)] << get;
dt:Mean << set values( theMeans );
Jim