Pivot Table
Hi,I like to transform the following attached JMP table (sample) into sample_out. I appreciate your help. Thanks
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi,I like to transform the following attached JMP table (sample) into sample_out. I appreciate your help. Thanks
I am creating a subset where I am using Select Where :Login Date == 01/18/2019; I cannot get it to work. I also tried opening the subset and running the query builder. I can add all of the fields and then filter by login date. The login dates show in the filter. If I choose one of the dates and hit update, no records show. Below is my code and I have attached the screen shot of the query bui...
I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
Hi All, I have this data table for example test = Graph Builder(
Variables( X( :X ), Y( :Y ), Color( :Value ) ),
Elements( Points( X, Y, Legend( 23 ) ) ),
SendToReport(
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
23,
Properties(
0,
{gradient(
{Scale Values( [-2 2] ), Label Format( "Fixed Dec", 15, 3 )}
)},
Item ID( "Value", 1 )
)
)}
)
...
Dear community I have a question and that is how to eliminate rows with the first duplicate. Example NrDateCount45672017-01-21155552017-02-03155552017-02-10287452015-03-10183452016-05-01195632016-01-02195632016-01-102 Is there a script how to, in this example, find the duplicates that I have marked here with bold text and either eliminate these rows directly or create an additional column where it...
I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
Hi All, I have this data table for example test = Graph Builder(
Variables( X( :X ), Y( :Y ), Color( :Value ) ),
Elements( Points( X, Y, Legend( 23 ) ) ),
SendToReport(
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
23,
Properties(
0,
{gradient(
{Scale Values( [-2 2] ), Label Format( "Fixed Dec", 15, 3 )}
)},
Item ID( "Value", 1 )
)
)}
)
...
Hi,I would like to ask if somebody has encounter the issue I got. I would like to verify the 95% CI for a case as below in the table. 95% Confidence Intervals for the True Rate at all Possible Observed Rates within a Subgroup (n=15)Observed Rate Lower Bound 95% CIUpper Bound 95% CI5/150.1520.723 I used JMP Analyze/Distribution and got the correct Lower CI (0.151763 which verifies 0.152 in the tabl...
I am getting error "JMP has performed access violation and will shut down while starting JMP" . It also says start up error information is recorded in some folder. I am running JMP 13.0.0 on Windows 7. Any help would be appreciated
Hello, I have such a diagram and want to figure out the equation which produces it: One can imagine it as a 3-dimentional space with color responces for every S/U/D combination.I filled S/U/D into a JMP table to fit (some kind of) model but realized immediately, that the response in color code (e.g. 1 for green, 2 for yelow and 3=red) doesn't make much sense.To my understanding, the equation...
I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
// For a contingency table report, swap the x and y
// currently can swap the mosaic plot only
Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
myr = Contingency( Y( :Age ), X( :sex ) );
// Have to have a Contingency Analysis report open
// Can add test to make sure it is open in the future
myr = Current Report();
// taking apart CrossTabBox was easier using XML than JSL
...
I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
8,...
Hello!
How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...