Welcome to the JMP User Community!

Latest Discussions

• Select Multiple Columns and Update Missing Column Value

  Hello,I am new to JMP scripting. I am working on a script to slelect multiple columns that contain the word "Censor" and update missing value. below is a set of sample data. I've listed three columns Censor A, Censor B, and Censor C. but in real world, the number of columns can be different every time. so I will have to select columns that contain the work " Censor", then update all missing value ...

  Nata007

  Discussions |

  May 28, 2019 11:10 PM

  4069 views | 4 replies

• How to calculate moving average of column with 10 million entries ?

  I am trying to run the below formula on a column with 10 million rows to calculate the moving average , but the script keeps running forever and jmp stops responding: thisTable << New Column( "av", Numeric, Continuous, Formula( Mean( :x[Index( Row() - 99999, Row() )] ) ) ); Is there any limitation or something wrong with the formula. How can I calculate the moving average in this case?

  jojmp

  Discussions |

  May 28, 2019 12:39 PM

  11575 views | 8 replies

• Move column to first using JSL script

  Hi JMP community I seem to have a simple question.I want to move a specific column to the first position using JSL script. I started withselecting it:"That's my column" << set selected (1) ; /*seemed OK*/ However, ...move selected column ( (:"That's my column"), to first) ;...just doesn't work. Could you help me solve this one?Thanks a lot!

  Newbie2Jumpie

  Discussions |

  May 28, 2019 8:51 AM

  7168 views | 2 replies

• Statistical significance test for multiple linear regression model

  I assume that for multiple linear regression model in JMP, Lack of Fit's p value test (Prob > F) value signifies whether the whole model is significant or not right? Is it the case that if the value is less than 0.05 then we consider the model as statistically significant? What is the use of Analysis of Variance then or is there anything helpful for it's  (Prob > F)  value for the result findings?...

  shuddha7435

  Discussions |

  May 28, 2019 8:32 AM

  8563 views | 3 replies

• How to customized color map levels in Clustering > Hierarchical (without standardization)?

  I would like to modify the color setting (i.e. gradient) for the legend of a color map generated by the Clustering > Hierarchical. Specifically, I would like to center the color gradient to 0 and assign the maximum and minimum values manually so that the color map is symmetrical. In all other platforms that use color gradients, I just right-click the legend and edit its parameters but this option ...

  Thierry_S

  Discussions |

  May 27, 2019 3:12 PM

  2485 views | 1 replies