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

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

GoodMan — Fri, 28 Sep 2012 16:24:58 GMT

Dear all,

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

Thank you in advance.

Kun

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

XanGregg — Wed, 03 Oct 2012 19:15:56 GMT

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

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

Matheus_Plana — Wed, 08 Apr 2020 18:20:39 GMT

@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

The graph only with Y by X, without frequency.

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

What JMP used as multiplicator?

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

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

Thanks in advance

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

Jeff_Perkinson — Wed, 08 Apr 2020 18:43:20 GMT

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.

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

Matheus_Plana — Wed, 08 Apr 2020 20:40:35 GMT

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.

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

txnelson — Wed, 08 Apr 2020 21:08:27 GMT

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.

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.