Welcome to the JMP User Community!

Latest Discussions

• 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

• How to store the current filename as entries in a new variable

  Let's imagine we open cities.jmp. How could I get the name (pun intended) of 'cities' as entries for a new variable, say "MY_NAME". So, the variable-to-be "MY_NAME" contains multiple instances of 'cities'. By nature, it has to be character, and "MY_NAME" is not a variable, but a constant.   Anyway, any idea how do do this? I know there's a file function. GET NAME. But, I haven't made it so far to ...

  Newbie2Jumpie

  Discussions |

  May 27, 2019 12:06 PM

  3983 views | 4 replies