Dear community,
I am trying to use the prediction profiler with one of the factors having the nominal data type. In the example below, the Factor 1 can assume two values, “One” and “Two”. The formula to be profiled contains a ‘Match’ statement that selects the numerical value 1 or 2, according to which string (“One” or “Two”) is entered, see the example code:
dt = New Table("Simulate",
Add Rows( 1 ),
New Column("Factor 1",
Character,
"Nominal",
Set Values({"One"})
),
New Column("Factor 2",
Numeric,
"Continuous",
Format("Best", 12),
Set Values([3])
),
New Column("Response",
Numeric,
"Continuous",
Format("Best", 12),
Formula(Match( :Factor 1, "One", 1, "Two", 2 ) * :Factor 2)
)
);
Profiler(
Y(:Response),
Simulator(
Factors(
Factor 2 << Random( Normal( 3, 0.1 ) )
)
)
)
When I run this code, a profiler report opens, like the one shown.
Now, here is my question: How do I get the dropdown menu below the graph for Factor 1 to show both options “One” and “Two”? The profiler and the simulation result should then change, according to which string value is chosen for Factor 1.
Any help is much appreciated.
Try adding another row to your table:
dt = New Table("Simulate",
Add Rows( 1 ),
New Column("Factor 1",
Character,
"Nominal",
Set Values({"One", "Two"})
),
New Column("Factor 2",
Numeric,
"Continuous",
Format("Best", 12),
Set Values([3, 3])
),
New Column("Response",
Numeric,
"Continuous",
Format("Best", 12),
Formula(Match( :Factor 1, "One", 1, "Two", 2 ) * :Factor 2)
)
);
Profiler(
Y(:Response),
Simulator(
Factors(
Factor 2 << Random( Normal( 3, 0.1 ) )
)
)
);
