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%3EEstad%C3%ADsticas%20de%20ventana%20m%C3%B3vil%2Fen%20movimiento%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%C2%BFQu%C3%A9%20inspir%C3%B3%20esta%20solicitud%20de%20lista%20de%20deseos%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ECon%20frecuencia%20utilizo%20estad%C3%ADsticas%20de%20ventana%20de%20tama%C3%B1o%20fijo%20en%20movimiento%20(rodantes)%20que%20se%20pueden%20calcular%20de%20forma%20independiente%20para%20un%20activo%20(byVar)%20para%20una%20cantidad%20de%20X%20variables%20sobre%20datos%20ordenados%20por%20fecha%20y%20hora.%20En%20mi%20an%C3%A1lisis%2C%20un%20modelo%20de%20calidad%20predictivo%20no%20s%C3%B3lo%20ha%20seleccionado%20X%20importantes%20sino%20tambi%C3%A9n%20un%20ciclo%20de%20fecha%20y%20hora%20donde%20los%20efectos%20son%20m%C3%A1s%20significativos%20para%20distinguir%20los%20activos%20normales%20de%20los%20anormales.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSTRONG%3E%C2%BFCu%C3%A1l%20es%20la%20mejora%20que%20le%20gustar%C3%ADa%20ver%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EExiste%20una%20versi%C3%B3n%20de%20estos%20en%20la%20pila%20de%20f%C3%B3rmulas%20como%20media%20m%C3%B3vil%20Col.%20Me%20gusta%20la%20posibilidad%20de%20agregar%20muchas%20otras%20estad%C3%ADsticas%20mediante%20f%C3%B3rmulas%20(y%20no%20scripts).%3C%2FP%3E%3CP%3EMe%20gusta%20que%20las%20siguientes%20estad%C3%ADsticas%20en%20movimiento%20est%C3%A9n%20disponibles%20simplemente%20a%20partir%20de%20f%C3%B3rmulas%3C%2FP%3E%3CP%3Eestos%20incluyen%20(pero%20no%20necesariamente%20se%20limitan%20a)%20..%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3Emover%20cuantiles%20espec%C3%ADficos%20(lista%20de%20deseos%20de%20%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)%3C%2FP%3E%3CP%3Emoviendo%20stdev%3C%2FP%3E%3CP%3Ependientes%20en%20movimiento%3C%2FP%3E%3CP%3EEstad%C3%ADstica%20m%C3%B3vil%20de%20Kendall%20Tau%20no%20param%C3%A9trica%3C%2FP%3E%3CP%3Euno%20podr%C3%ADa%20imaginar%20mover%20%3CEM%3E%3CSTRONG%3Ecualquier%20estad%C3%ADstica%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%C2%BFPor%20qu%C3%A9%20es%20importante%20esta%20idea%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3ESin%20la%20funcionalidad%20de%20f%C3%B3rmula%2C%20necesito%20volver%20a%20una%20secuencia%20de%20comandos%20para%20recordar%20c%C3%B3mo%20hacer%20esto%20cada%20vez%20que%20lo%20necesito.%20Creo%20que%20una%20de%20las%20principales%20fortalezas%20de%20JMP%20es%20ser%20una%20de%20las%20herramientas%2Fplataforma%20m%C3%A1s%20sencillas%20para%20ofrecer%20estad%C3%ADsticas%20y%20modelos%20avanzados.%20Las%20f%C3%B3rmulas%20son%20una%20excelente%20manera%20de%20seguir%20transmitiendo%20la%20noci%C3%B3n%20de%20%22lo%20m%C3%A1s%20f%C3%A1cil%22.%20Puedo%20escribir%20pero%20prefiero%20no%20hacerlo.%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%3EModelado%20estad%C3%ADstico%20avanzado%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExploraci%C3%B3n%20y%20visualizaci%C3%B3n%20de%20datos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EModelado%20predictivo%20y%20aprendizaje%20autom%C3%A1tico%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%3ERe%3A%20Estad%C3%ADsticas%20de%20ventanas%20m%C3%B3viles%2Fdeslizantes%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%3ELa%20funci%C3%B3n%20propuesta%20ser%C3%ADa%20muy%20%C3%BAtil%2C%20por%20ejemplo%2C%20para%20el%20an%C3%A1lisis%20de%20series%20temporales.%20Permitir%C3%ADa%20al%20usuario%20determinar%20la%20amplitud%20de%20la%20ventana%20y%20el%20paso.%20Mover%20cualquier%20funci%C3%B3n%20estad%C3%ADstica%20suena%20genial.%20%C2%BFSer%C3%ADa%20posible%20incluir%20una%20funci%C3%B3n%20definida%20por%20el%20usuario%3F%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?