Hello everyone!!!, a question:
What graph in JMP can answer the probabilities of obtaining a value or range of response, for example like the following graph.
Greetings,
Marco
4 ACCEPTED SOLUTIONS
Accepted Solutions
Created:
| Last Modified:
Then what you need is just a Local Data Filter - and a Filter Change Handler that updates the results in the probabilities panel.
The advantage: With the Data Filter it doesn't matter how many questions you will ask - just add as many selections as you want and the corresponding probabilities will show up automatically:
View more...
/*""" https://community.jmp.com/t5/Discussions/Can-JMP-show-the-probability-of-1-result-or-range-through-a/m-p/697164/highlight/true#M88257
Author: hogi
Date: 2023-11-12
NB: back again at simple Data Filter
*/
Names Default To Here( 1 );
convertToList = Function( {myExpr},
myHead = Head( Name Expr( myExpr ) );
Substitute( Name Expr( myExpr ), Name Expr( myHead ), Expr( List() ) );
);
findArgs = Function( {myList, myHead},
{NArgs, myArg},
matches = {};
NArgs = N Arg( myList );
For Each( {i}, 1 :: NArgs,
myArg = Arg( Name Expr( myList ), i );
If( Head( Name Expr( myArg ) ) == Name Expr( myHead ),
Insert Into( matches, convertToList( Name Expr( myArg ) ) )
);
);
matches;
);
all Cols = Current Data Table() << get column references();
New Window( "probabilites",
H List Box( Current Data Table() << data filter( Local,Title("Selection"), Show Controls( 0 ),
Show Modes( 0 ),
Show Counts( 0 ), Conditional( 0 ), columns( Name Expr( all Cols ) ) ), hlb = H List Box() )
);
ldf = ((Current Report()["Selection"]) << get scriptable object);
update = Function( {a},
{ldflist,filterExpr,myCols,myFilters,lookupTable,myValue},
ldf = ((Current Report()["Selection"]) << get scriptable object);
ldflist = Convert To list( ldf << get script );
filterExpr = findArgs( ldflist, Expr( AddFilter() ) );
myCols = Transform Each({x},findArgs( Name Expr( filterExpr ), Expr( columns() )),x << get name) ;
myFilters = findArgs( Name Expr( filterExpr ), Expr( Where() ) );
lookupTable = Associative Array( Transform Each( {x, i}, myFilters, Eval List( {If(Head(x)==Expr(And()),Arg( Arg(x,1), 1 )<< get name, Arg(x,1)<< get name) , i} ) ) );
myBox = Outline Box( "probabilities" );
For Each( {x}, myCols,
Try( myPos = Eval(substitute(Expr(lookupTable[_x_]),Expr(_x_),Name Expr(x)));
Eval(
Substitute(
Expr(
sel_rows = Current Data Table() << get rows where( _match_ );
myValue = Char( Round( N Items(sel_rows) / N rows(current data table()) * 100, 2 ) ) || "%";
),
Expr( _match_ ), Name Expr( myFilters[myPos] ),
)
),
myValue = "100%");
Insert Into( myBox, Panel Box( x, Text Box( myValue ) ) );
);
Try(result << delete);
hlb << append( result = myBox );
);
rs = ldf << make filter change handler( update );
(Current Report() << xpath("//FrameBox")) << Frame Size( 500, 50 );
This code isn't good enough for me to turn it into an add-in (it would require at least one partial rewrite for me to consider it adequate), especially because I won't be updating it. If you wish to make it into an adding using is the best option.
The script has been added as .zip file because it contains multiple files which must be in specific folders. After unpacking it
you should be able to open and run probability_calculator.jsl
Created:
| Last Modified:
Here is an alternative implementation which also allows "combined" filter conditions (A and B and C ...).
For this case it makes sense to enable the Conditional(1) setting - then additional filters will only show values that are within the range of the first filters.
In addition, one can create several filter "groups". Click on OR and a filter group N+1 is generated with the corresponding probability value.
drawbacks:
- with the current version of Jmp, Conditional(1) and filter groups via OR are not compatible
So, if you want to compare different selection groups, you have to do this without the Conditional(1) feature.
here is a wish to fix this problem: - The possibilities to adjust the graph are more restricted than in GraphBuilder:
- selected values are indicated via the semitransparent blue region, which looks nice.
On the other hand, it's not possible to switch "different colors for selected/unselected"
- the default number of bins in a data filter is 10, just giving a rough idea of the actual distribution.
Number of Bins can be adjusted via the red triangle menu:
View more...
/*""" https://community.jmp.com/t5/Discussions/Can-JMP-show-the-probability-of-1-result-or-range-through-a/m-p/697074/highlight/true#M88231
Topic: direct access to data filter selections via ldf << get where clause
Author: hogi
Date: 2023-11-12
*/
Names Default To Here( 1 );
convertToList = Function( {myExpr},{Nargs,myList},
Nargs= N Arg(Name Expr(myExpr));
myList={};
For(i=1, i<=NArgs, i++,
Insert Into(myList,Arg(Name Expr(myExpr),i))
);
return(Name Expr(myList))
);
New Window( "probabilites",
H list Box (
Current Data Table() <<
data filter(
Local,
Title( "Selection" ),
Show Controls( 1 ),
Show Modes( 0 ),
Conditional( 1 ),
add Filter (columns(Column(1),Column(2)),Display( Column(1), NBins( 100 ) ),Display( Column(2), NBins( 100 ) ))
),
H List Box( Name Expr( myExpr ), hlb = H List Box() ));
);
update = Function( {a}, {myExpr,myselection},
// collect Selections from Local Data Filter - every OR is a group - kind of ...
ldf = Current Report()["Selection"] << get scriptable Object;
myExpr = Parse( ldf << get where clause );
myExpr=Arg( myExpr, 1 );
mySelections = If( (Head( myExpr ) == Expr( Or() ) & Head( Arg(myExpr,1) ) != Expr( Equal() )),
convertToList(Name Expr(myExpr) ), // several filter groups
Eval List({Name Expr(myExpr)}) // one filter group
);
// calculate the new values
myBox = Outline Box( "probabilities" );
For Each( {x, i}, mySelections,
Eval(
Substitute(
Expr(
sel_rows = Current Data Table() << get rows where( _match_ );
myValue = Char( Round( N Items( sel_rows ) / N Rows( Current Data Table() ) * 100, 2 ) ) || "%";
),
Expr( _match_ ), Name Expr( x )
)
);
Insert Into( myBox, Panel Box( "selection group # " || Char( i ), Text Box( myValue ) ) );
);
// update the results
Try( result << delete );
hlb << append( result = myBox );
);
ldf = ((Current Report()["Selection"]) << get scriptable object);
rs = ldf << make filter change handler( update );
(Current Report() << xpath( "//FrameBox" )) << Frame Size( 500, 50 ) << Fill Selection Mode( "Selected Same Color" );
Created:
| Last Modified:
Created:
| Last Modified:
Hi @Marco1,
I think the Design Space Profiler may be helpful for what you intend to do.
Based on Monte-Carlo simulations, and if you provide some specifications (Lower and/or Upper Specification Limits), the Design Space Profiler will calculate and display the in-spec rate, based on specific inputs ranges.
You can look at an example here and see if it corresponds to your needs : Example of Design Space Profiler.
I hope this answer will help you,
Created:
| Last Modified:
The Design Space Profiler is only available for continuous responses :
As the original poster @Marco1 did not mention any nominal response, I thought the Design Space Profiler may be close to his expectations and goal :
What graph in JMP can answer the probabilities of obtaining a value or range of response
Best,