cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
%3CLINGO-SUB%20id%3D%22lingo-sub-722620%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E7%A7%BB%E5%8B%95%2F%E6%BB%BE%E5%8B%95%E8%A6%96%E7%AA%97%E7%B5%B1%E8%A8%88%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722620%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CSTRONG%3E%E6%98%AF%E4%BB%80%E9%BA%BC%E6%BF%80%E7%99%BC%E4%BA%86%E9%80%99%E5%80%8B%E9%A1%98%E6%9C%9B%E6%B8%85%E5%96%AE%E8%AB%8B%E6%B1%82%EF%BC%9F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%E6%88%91%E7%B6%93%E5%B8%B8%E4%BD%BF%E7%94%A8%E7%A7%BB%E5%8B%95%EF%BC%88%E6%BB%BE%E5%8B%95%EF%BC%89%E5%9B%BA%E5%AE%9A%E5%A4%A7%E5%B0%8F%E7%9A%84%E8%A6%96%E7%AA%97%E7%B5%B1%E8%A8%88%E4%BF%A1%E6%81%AF%EF%BC%8C%E9%80%99%E4%BA%9B%E7%B5%B1%E8%A8%88%E8%B3%87%E6%96%99%E5%8F%AF%E4%BB%A5%E9%87%9D%E5%B0%8D%E6%97%A5%E6%9C%9F%E6%99%82%E9%96%93%E6%8E%92%E5%BA%8F%E8%B3%87%E6%96%99%E4%B8%8A%E7%9A%84%E5%A4%9A%E5%80%8B%20X%20%E8%AE%8A%E6%95%B8%E7%9A%84%E8%B3%87%E7%94%A2%20(byVar)%20%E7%8D%A8%E7%AB%8B%E8%A8%88%E7%AE%97%E3%80%82%E5%9C%A8%E6%88%91%E7%9A%84%E5%88%86%E6%9E%90%E4%B8%AD%EF%BC%8C%E9%A0%90%E6%B8%AC%E5%93%81%E8%B3%AA%E6%A8%A1%E5%9E%8B%E4%B8%8D%E5%83%85%E9%81%B8%E6%93%87%E4%BA%86%E9%87%8D%E8%A6%81%E7%9A%84%20X%EF%BC%8C%E8%80%8C%E4%B8%94%E9%82%84%E9%81%B8%E6%93%87%E4%BA%86%E4%B8%80%E5%80%8B%E6%97%A5%E6%9C%9F%E6%99%82%E9%96%93%E9%80%B1%E6%9C%9F%EF%BC%8C%E5%85%B6%E4%B8%AD%E5%BD%B1%E9%9F%BF%E6%9C%80%E9%A1%AF%E8%91%97%EF%BC%8C%E4%BB%A5%E5%8D%80%E5%88%86%E6%AD%A3%E5%B8%B8%E8%B3%87%E7%94%A2%E5%92%8C%E7%95%B0%E5%B8%B8%E8%B3%87%E7%94%A2%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSTRONG%3E%E6%82%A8%E5%B8%8C%E6%9C%9B%E7%9C%8B%E5%88%B0%E4%BB%80%E9%BA%BC%E6%94%B9%E9%80%B2%EF%BC%9F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%E5%85%B6%E4%B8%AD%E7%9A%84%E4%B8%80%E5%80%8B%E7%89%88%E6%9C%AC%E4%BD%9C%E7%82%BA%20Col%20%E7%A7%BB%E5%8B%95%E5%B9%B3%E5%9D%87%E7%B7%9A%E5%AD%98%E5%9C%A8%E6%96%BC%E5%85%AC%E5%BC%8F%E5%A0%86%E7%96%8A%E4%B8%AD%E3%80%82%E6%88%91%E5%96%9C%E6%AD%A1%E4%BD%BF%E7%94%A8%E5%85%AC%E5%BC%8F%EF%BC%88%E8%80%8C%E4%B8%8D%E6%98%AF%E8%85%B3%E6%9C%AC%EF%BC%89%E6%B7%BB%E5%8A%A0%E8%A8%B1%E5%A4%9A%E5%85%B6%E4%BB%96%E7%B5%B1%E8%A8%88%E6%95%B8%E6%93%9A%E7%9A%84%E8%83%BD%E5%8A%9B%E3%80%82%3C%2FP%3E%3CP%3E%E6%88%91%E5%96%9C%E6%AD%A1%E4%BB%A5%E4%B8%8B%E7%A7%BB%E5%8B%95%E7%B5%B1%E8%A8%88%E6%95%B8%E6%93%9A%E5%8F%AF%E4%BB%A5%E7%B0%A1%E5%96%AE%E5%9C%B0%E5%BE%9E%E5%85%AC%E5%BC%8F%E4%B8%AD%E7%8D%B2%E5%BE%97%3C%2FP%3E%3CP%3E%E9%80%99%E4%BA%9B%E5%8C%85%E6%8B%AC%EF%BC%88%E4%BD%86%E4%B8%8D%E9%99%90%E6%96%BC%EF%BC%89..%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E7%A7%BB%E5%8B%95%E7%89%B9%E5%AE%9A%E5%88%86%E4%BD%8D%E6%95%B8%EF%BC%88%E9%A1%98%E6%9C%9B%E6%B8%85%E5%96%AE%E4%BE%86%E8%87%AA%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FCol-Moving-Quantile-function%2Fidi-p%2F321573%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FCol-Moving-Quantile-function%2Fidi-p%2F321573%3C%2FA%3E%20%EF%BC%89%3C%2FP%3E%3CP%3E%E7%A7%BB%E5%8B%95%E6%A8%99%E6%BA%96%E5%B7%AE%3C%2FP%3E%3CP%3E%E7%A7%BB%E5%8B%95%E6%96%9C%E5%9D%A1%3C%2FP%3E%3CP%3E%E7%A7%BB%E5%8B%95%E9%9D%9E%E5%8F%83%E6%95%B8%20Kendall%20Tau%20%E7%B5%B1%E8%A8%88%E9%87%8F%3C%2FP%3E%3CP%3E%E4%BA%BA%E5%80%91%E5%8F%AF%E4%BB%A5%E6%83%B3%E5%83%8F%E7%A7%BB%E5%8B%95%3CEM%3E%3CSTRONG%3E%E4%BB%BB%E4%BD%95%E7%B5%B1%E8%A8%88%E6%95%B8%E6%93%9A%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSTRONG%3E%E7%82%BA%E4%BB%80%E9%BA%BC%E9%80%99%E5%80%8B%E6%83%B3%E6%B3%95%E5%BE%88%E9%87%8D%E8%A6%81%EF%BC%9F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E5%A6%82%E6%9E%9C%E6%B2%92%E6%9C%89%E5%85%AC%E5%BC%8F%E5%8A%9F%E8%83%BD%EF%BC%8C%E6%88%91%E9%9C%80%E8%A6%81%E8%BF%94%E5%9B%9E%E8%85%B3%E6%9C%AC%E4%BE%86%E5%9B%9E%E6%86%B6%E6%AF%8F%E6%AC%A1%E9%9C%80%E8%A6%81%E6%99%82%E5%A6%82%E4%BD%95%E5%9F%B7%E8%A1%8C%E6%AD%A4%E6%93%8D%E4%BD%9C%E3%80%82%E6%88%91%E8%AA%8D%E7%82%BA%20JMP%20%E7%9A%84%E4%B8%BB%E8%A6%81%E5%84%AA%E5%8B%A2%E4%B9%8B%E4%B8%80%E6%98%AF%E6%88%90%E7%82%BA%E6%8F%90%E4%BE%9B%E9%AB%98%E7%B4%9A%E7%B5%B1%E8%A8%88%E5%92%8C%E5%BB%BA%E6%A8%A1%E7%9A%84%E6%9C%80%E7%B0%A1%E5%96%AE%E7%9A%84%E5%B7%A5%E5%85%B7%2F%E5%B9%B3%E5%8F%B0%E4%B9%8B%E4%B8%80%E3%80%82%E5%85%AC%E5%BC%8F%E6%98%AF%E4%BF%9D%E6%8C%81%E3%80%8C%E6%9C%80%E7%B0%A1%E5%96%AE%E3%80%8D%E6%A6%82%E5%BF%B5%E7%9A%84%E5%A5%BD%E6%96%B9%E6%B3%95%E3%80%82%E6%88%91%E5%8F%AF%E4%BB%A5%E7%B7%A8%E5%AF%AB%E8%85%B3%E6%9C%AC%EF%BC%8C%E4%BD%86%E6%88%91%E4%B8%8D%E6%83%B3%E9%80%99%E6%A8%A3%E5%81%9A%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-722620%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E9%80%B2%E9%9A%8E%E7%B5%B1%E8%A8%88%E5%BB%BA%E6%A8%A1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E6%95%B8%E6%93%9A%E6%8E%A2%E7%B4%A2%E5%92%8C%E8%A6%96%E8%A6%BA%E5%8C%96%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E9%A0%90%E6%B8%AC%E5%BB%BA%E6%A8%A1%E5%92%8C%E6%A9%9F%E5%99%A8%E5%AD%B8%E7%BF%92%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-753058%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%20translate%3D%22no%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E7%A7%BB%E5%8B%95%2F%E6%BB%BE%E5%8B%95%E8%BB%8A%E7%AA%97%E7%B5%B1%E8%A8%88%E6%95%B8%E6%93%9A%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-753058%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%E6%89%80%E6%8F%90%E8%AD%B0%E7%9A%84%E5%8A%9F%E8%83%BD%E9%9D%9E%E5%B8%B8%E6%9C%89%E7%94%A8%EF%BC%8C%E4%BE%8B%E5%A6%82%E7%94%A8%E6%96%BC%E6%99%82%E9%96%93%E5%BA%8F%E5%88%97%E5%88%86%E6%9E%90%E3%80%82%E6%88%91%E5%BB%BA%E8%AD%B0%E5%85%81%E8%A8%B1%E7%94%A8%E6%88%B6%E8%87%AA%E8%A8%82%E8%A6%96%E7%AA%97%E5%A4%A7%E5%B0%8F%E5%92%8C%E6%AD%A5%E9%95%B7%E3%80%82%E7%A7%BB%E5%8B%95%E4%BB%BB%E4%BD%95%E7%B5%B1%E8%A8%88%E5%87%BD%E6%95%B8%E8%81%BD%E8%B5%B7%E4%BE%86%E9%83%BD%E5%BE%88%E6%A3%92%E3%80%82%E6%98%AF%E5%90%A6%E5%8F%AF%E4%BB%A5%E6%96%B0%E5%A2%9E%E4%BD%BF%E7%94%A8%E8%80%85%E8%87%AA%E8%A8%82%E5%87%BD%E6%95%B8%EF%BC%9F%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Moving/Rolling Window Statistics

What inspired this wish list request? 

I frequently use moving (rolling) fixed size window statistics that can be computed independently for an asset (byVar) for a number of X variables over a datetime ordered data. In my analysis, a predictive quality model has not only select important X's but also a datetime cycle where the effects are most significant from to distinguish normal from abnormal assets. 

 

What is the improvement you would like to see? 

A version of these exist in formula stack as Col moving average. I like the ability to add many other statistics using formulas (and not scripts). 

I like the following moving statistics be available simply from formulas

these include (but not necessarily limited to) ..

 

moving specific quantiles (wish list from https://community.jmp.com/t5/JMP-Wish-List/Col-Moving-Quantile-function/idi-p/321573

moving stdev

moving slopes

moving non parametric Kendall Tau statistic

one could imagine moving any statistic

 

 

Why is this idea important? 

 

Without the formula functionality, I need to go back to a scripting to recall how to do this every single time I need it. I think one of the main strengths of JMP is being  one of the easiest tool/platform to offer advanced statistics & modeling . Formulas is a great way to keep carrying the notion of "easiest". I can script but I prefer not to. 

1 Comment
Sextus
Level II

The proposed function would be very (!) useful, for example for the analysis of time series.  I would let the user determine the span of the window and the step.  Moving any statistic function sounds great.  Would it be possible to include a user-defined function?