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
Choose Language Hide Translation Bar
GoodMan
Level III

Anyone can show me how to use Freq zone in graph builder?

Dear all,

Can you show me an example on how to use Freq zone in graph builder ?

Thank you in advance.

Kun

5 REPLIES 5
XanGregg
Staff

Re: Anyone can show me how to use Freq zone in graph builder?

Whatever variable you put there acts as a weight/frequency variable on the response variables. Basically a multiplier.

Matheus_Plana
Level III

Re: Anyone can show me how to use Freq zone in graph builder?

@XanGregg, could you please detail how JMP decides what number will be used as a multiplicator? 

 

To better explain the situation, I created this example: 

 

The data table 

Matheus_1-1586369592169.png

 

The graph only with Y by X, without frequency.

Matheus_2-1586369643716.png

And the graph putting "#non conformities" in Frequency.

Matheus_3-1586369703448.png

 

What JMP used as multiplicator? 

 

The column #non conformities has the following distribution, if you need. 

Matheus_4-1586369833004.png

 

Looking forward to read your response, once I have to explain it in a course where I´m the instructor. 

 

Thanks in advance

 

 

Jeff_Perkinson
Community Manager Community Manager

Re: Anyone can show me how to use Freq zone in graph builder?

The Freq role (Freq zone in Graph Builder) is useful with summarized data. You can simply imagine that each row of your table is duplicated as many times as the value of in the Freq column. That is, a value of 4 says that this row should be treated as if it exists 4 times.

-Jeff
Matheus_Plana
Level III

Re: Anyone can show me how to use Freq zone in graph builder?

Thanks @Jeff_Perkinson for your quick answer. 

 

I think I got your point. I've just redone my example and understood what JMP did. 

 

Thank you.

txnelson
Super User

Re: Anyone can show me how to use Freq zone in graph builder?

I have written a little script, that compares a data table of the structure of your example, using the Freq drop zone of Graph Builder, vs. expanding the data into real observations and then doing a graph builder based upon the expanded data.

compare.PNG

Names Default To Here( 1 );
/*dt = New Table( "Example", Add Rows( 16 ), New Column( "#non conformities", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [1, 1, 1, 4, 1, 2, 1, 1, 1, 1, 1, 1, 2, 1, 2, 2] ) ), New Column( "X", Numeric, "Nominal", Format( "Best", 12 ), Set Values( [2, 4, 3, 5, 5, 4, 2, 1, 2, 3, 3, 1, 4, 2, 4, 1] ) ), New Column( "Y", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [87.6761003304139, 69.8609169241848, 87.4616511288794, 70.3768356100406, 70.8645383423261, 85.4167498650613, 85.0039197906326, 83.0781777845281, 81.445262575383, 77.6469864353613, 73.528707708996, 91.6793408130229, 82.0904076861622, 74.5541146955842, 95.3095947684666, 80.9917511770325] ) ) );*/ dt = current data table(); dt << Add Multiple Columns( "Y", Col Max( :name( "#non conformities" ) ) - 1, numeric, after last ); For Each Row( For( i = 2, i <= :Name( "#non conformities" ), i++, Column( 2 + i )[Row()] = :Y[Row()] ) ); theList = {"Y"}; For( i = 1, i <= Col Max( :name( "#non conformities" ) ) - 1, i++, Insert Into( theList, "Y " || Char( i ) ) ); dtStack = dt << Stack( columns( theList ), Source Label Column( "Label" ), Stacked Data Column( "Data" ) ); dtStack << select where( Is Missing( :Data ) == 1 ); dtStack << delete rows; New Window( "Comparison", H List Box( dt << Graph Builder( Size( 528, 450 ), Show Control Panel( 0 ), Variables( X( :X ), Y( :Y ), Frequency( :Name( "#non conformities" ) ) ), Elements( Box Plot( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "graph title", TextEditBox, {Set Text( "Using Freq" )} ) ) ), dtStack << Graph Builder( Size( 528, 450 ), Show Control Panel( 0 ), Variables( X( :X ), Y( :Data ) ), Elements( Box Plot( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "graph title", TextEditBox, {Set Text( "Stacked" )} ) ) ) ) );

 If you run this script against your data, you should get identical graphs of the form of your Freq version created with your data.

Jim