Welcome to the JMP User Community!

Latest Discussions

• How to calculate moving average of column with more than 10000 million entries in JMP 11?

  I am trying to run the below formula on a column with 100 million rows to calculate the moving average.Could you please suggest an JMP11 alternative for  Col Moving Average  Col Moving Average( :x, 1, 9999999, 0 ) is not supported by JMP11. Please find below the code I have tried: NamesDefaultToHere(1); // Use a function to open a .CSV file: Given the path to such a file, returns a reference to t...

  jojmp

  Discussions |

  May 29, 2019 3:48 AM

  3662 views | 5 replies

• Customize Oneway analysis

  Hi guys! 
  I'm wondering if there is a way/script to move the minimum, median and maximum in to the Means and Std Deviations area.
  Thank you ! 
  
  dt = Open( "$SAMPLE_DATA\Big Class.jmp",invisible(1) );

ow= dt<<Oneway( Y( :Eval(colListY<<GetItems) ), X( :Eval(colListX<<GetItems) ), All Graphs( 0 ), Quantiles( 1 ), Means and Std Dev( 1 ), Plot Quantile by Actual( 1 ), Line of Fit( 0 ), Points( 0 ), Box Plo...

  Jax

  Discussions |

  May 29, 2019 1:28 AM

  3953 views | 2 replies

• Likert scale in correlation analysis

  Hi all. I am working on my master thesis and are struggling with my correlation analysis.My plan for the statistics from my survey are:Item analysisPCA and factor analysisCorrelation analysisMultiple regressionCluster analysis. In my assumptions in correlation analysis I have problems with the fitting of the likert scale data to find linearity among other things. Is it better to use the factor sco...

  MScMasterStuden

  Discussions |

  May 29, 2019 1:14 AM

  3035 views | 2 replies

• 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

  4157 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

  11710 views | 8 replies