cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EKopieren%20Sie%20die%20Mittelwerte%20und%20die%20Standardabweichungstabelle%20aus%20einer%20Oneway-Analyse.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHallo%20alle!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIch%20schreibe%20zum%20ersten%20Mal%20hier%20und%20entschuldige%20mich%2C%20wenn%20ich%20etwas%20%C3%BCbersehe.%20Ich%20habe%20ein%20Skript%20geschrieben%2C%20das%20im%20Wesentlichen%20eine%20Einweganalyse%20f%C3%BCr%20vom%20Benutzer%20importierte%20Daten%20erstellt.%20Ich%20habe%20mich%20gefragt%2C%20ob%20es%20m%C3%B6glich%20ist%2C%20die%20Tabelle%20%E2%80%9EMittelwerte%20und%20Standardabweichungen%E2%80%9C%20in%20eine%20andere%20Tabelle%20in%20JSL%20zu%20extrahieren%20(kopieren%20und%20einf%C3%BCgen).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20style%3D%22width%3A%20266px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60127i4B2D68594D2AE9DA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22OhThatArabGuy_1-1703880407651.png%22%20alt%3D%22OhThatArabGuy_1-1703880407651.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712901%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAutomatisierung%20und%20Skripterstellung%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGrundlegende%20Datenanalyse%20und%20Modellierung%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Einf%C3%BCgen%20von%20Mittelwerten%20und%20Standardabweichungstabelle%20aus%20einer%20Oneway-Analyse%20kopieren.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712908%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHier%20ist%20ein%20Beispiel%2C%20das%20zeigt%2C%20wie%20man%20aus%20der%20vollst%C3%A4ndigen%20Mittelwert-%20und%20Std-Tabelle%20eine%20neue%20Datentabelle%20erstellt%20und%20wie%20man%20eine%20bestimmte%20Spalte%20der%20Statistiktabelle%20nimmt%20und%20sie%20zur%20aktuellen%20Datentabelle%20hinzuf%C3%BCgt.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0Adt%3Dopen(%22%24SAMPLE_DATA%2Fbig%20class.jmp%22)%3B%0A%0AOneway(%0A%20Y(%20%3Aheight%20)%2C%0A%20X(%20%3Asex%20)%2C%0A%20Quantiles(%201%20)%2C%0A%20Means%20and%20Std%20Dev(%201%20)%2C%0A%20t%20Test(%201%20)%2C%0A%20Box%20Plots(%201%20)%2C%0A%20Mean%20Error%20Bars(%201%20)%2C%0A%20Std%20Dev%20Lines(%201%20)%0A)%3B%0A%0AtheReport%20%3D%20current%20report()%3B%0A%0A%2F%2F%20Create%20it%20own%20new%20table%0AtheReport%5B%22Means%20and%20Std%20Deviations%22%2C%20TableBox(1)%5D%20%26lt%3B%26lt%3B%20make%20into%20data%20table%3B%0A%0A%2F%2F%20and%2For%20add%20the%20data%20to%20the%20current%20data%20table%0Adt%20%26lt%3B%26lt%3B%20new%20column(%20%22Mean%22%20)%3B%0AtheMeans%20%3D%20theReport%5B%22Means%20and%20Std%20Deviations%22%2C%20NumberColBox(2)%5D%20%26lt%3B%26lt%3B%20get%3B%0Adt%3AMean%20%26lt%3B%26lt%3B%20set%20values(%20theMeans%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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