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%3EStatistik%20des%20sich%20bewegenden%2Frollenden%20Fensters%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%3EWas%20hat%20diese%20Wunschlistenanfrage%20inspiriert%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIch%20verwende%20h%C3%A4ufig%20bewegliche%20(rollende)%20Fensterstatistiken%20mit%20fester%20Gr%C3%B6%C3%9Fe%2C%20die%20unabh%C3%A4ngig%20f%C3%BCr%20ein%20Asset%20(byVar)%20f%C3%BCr%20eine%20Reihe%20von%20X-Variablen%20%C3%BCber%20geordnete%20Datums-%2FUhrzeitdaten%20berechnet%20werden%20k%C3%B6nnen.%20In%20meiner%20Analyse%20hat%20ein%20pr%C3%A4diktives%20Qualit%C3%A4tsmodell%20nicht%20nur%20wichtige%20Xs%20ausgew%C3%A4hlt%2C%20sondern%20auch%20einen%20Datum-Uhrzeit-Zyklus%2C%20in%20dem%20die%20Auswirkungen%20am%20signifikantesten%20sind%2C%20um%20normale%20von%20abnormalen%20Verm%C3%B6genswerten%20zu%20unterscheiden.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSTRONG%3EWelche%20Verbesserung%20w%C3%BCrden%20Sie%20sich%20w%C3%BCnschen%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EEine%20Version%20davon%20ist%20im%20Formelstapel%20als%20gleitender%20Col-Durchschnitt%20vorhanden.%20Mir%20gef%C3%A4llt%20die%20M%C3%B6glichkeit%2C%20viele%20andere%20Statistiken%20mithilfe%20von%20Formeln%20(und%20nicht%20mit%20Skripten)%20hinzuzuf%C3%BCgen.%3C%2FP%3E%3CP%3EMir%20gef%C3%A4llt%2C%20dass%20die%20folgenden%20Bewegungsstatistiken%20einfach%20aus%20Formeln%20verf%C3%BCgbar%20sind%3C%2FP%3E%3CP%3EDazu%20geh%C3%B6ren%20(aber%20nicht%20unbedingt%20beschr%C3%A4nkt%20auf)%20..%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EVerschieben%20spezifischer%20Quantile%20(Wunschliste%20von%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%3EUmzug%20stdev%3C%2FP%3E%3CP%3Ebewegliche%20H%C3%A4nge%3C%2FP%3E%3CP%3EVerschieben%20der%20nichtparametrischen%20Kendall-Tau-Statistik%3C%2FP%3E%3CP%3Eman%20k%C3%B6nnte%20sich%20vorstellen%2C%20%3CEM%3E%3CSTRONG%3Ejede%20Statistik%3C%2FSTRONG%3E%3C%2FEM%3E%20zu%20verschieben%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSTRONG%3EWarum%20ist%20diese%20Idee%20wichtig%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EOhne%20die%20Formelfunktion%20muss%20ich%20jedes%20Mal%2C%20wenn%20ich%20sie%20brauche%2C%20auf%20ein%20Skript%20zur%C3%BCckgreifen%2C%20um%20mich%20daran%20zu%20erinnern%2C%20wie%20das%20geht.%20Ich%20denke%2C%20eine%20der%20Hauptst%C3%A4rken%20von%20JMP%20besteht%20darin%2C%20dass%20es%20eines%20der%20einfachsten%20Tools%2FPlattformen%20ist%2C%20um%20erweiterte%20Statistiken%20und%20Modellierung%20anzubieten.%20Formeln%20sind%20eine%20gro%C3%9Fartige%20M%C3%B6glichkeit%2C%20den%20Gedanken%20des%20%E2%80%9EEinfachsten%E2%80%9C%20aufrechtzuerhalten.%20Ich%20kann%20Skripte%20schreiben%2C%20m%C3%B6chte%20es%20aber%20lieber%20nicht.%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%3EErweiterte%20statistische%20Modellierung%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDatenexploration%20und%20-visualisierung%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPr%C3%A4diktive%20Modellierung%20und%20maschinelles%20Lernen%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%3EBetreff%3A%20Statistiken%20zu%20gleitenden%20Fenstern%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%3EDie%20vorgeschlagene%20Funktion%20w%C3%A4re%20sehr%20n%C3%BCtzlich%2C%20beispielsweise%20f%C3%BCr%20die%20Analyse%20von%20Zeitreihen.%20Ich%20w%C3%BCrde%20dem%20Benutzer%20die%20M%C3%B6glichkeit%20geben%2C%20die%20Fenstergr%C3%B6%C3%9Fe%20und%20die%20Schrittweite%20festzulegen.%20Die%20M%C3%B6glichkeit%2C%20beliebige%20statistische%20Funktionen%20zu%20verschieben%2C%20klingt%20vielversprechend.%20W%C3%A4re%20es%20denkbar%2C%20eine%20benutzerdefinierte%20Funktion%20einzubinden%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?