Overview Settings Period Percentage Rolling Examples Questions How do I calculate a rolling sum? How to keep series as is and start aggregating it from certain point in time? Overview Example of general use of Aggregate analysis comparing aggregated values by each year annually and starting 3 year from the end of series: The Aggregate … Continue reading “Aggregate”
Overview Settings Direction Observation limit Missing values Examples Questions Why I see numbers instead of categories? How to show the top 10 highest values in Descending order? I set Observation limit number but it doesn’t work? Overview Example of general use of Sorting analysis (also Lists, data Concepts and Cross sampling) to show how to … Continue reading “Sorting”
Overview Settings Period Set to year/quarter/month Custom ranges Custom points in time Calendar mode Include only periods available in all series Rebase Rebase with base value Additive rebase with base value Use legacy format Examples Overview Example of general use of Slice analysis comparing individually rebased year-length slices: The Slice analysis cuts a time series … Continue reading “Slice”
Overview Settings Method Base Example Questions How do I lag or lead a series? Overview Example of general use of Lag analysis to compare growth trend of two series: When you are investigating the relationship between series, it can happen that their movements are not synchronized. This is where the Lag analysis becomes useful. It … Continue reading “Lag”
Overview Settings Method Length Standard deviation Coefficient Examples Questions How do I calculate a moving average / rolling mean? Overview Example of general use of Smoothing analysis with Moving average method and HP filter: The Smoothing analysis is used for minimizing the fluctuations of a time series. You can choose from several smoothing methods which … Continue reading “Smoothing”
Overview Method Limitations Settings Method Type Holiday regressor ARIMA Trading day Easter Outlier Constant Conditional Output Report Example Overview Example of general use of Seasonal adjustment Census X-13 analysis using ‘Chinese New Year’ regressor: The Seasonal adjustment Census X-13 analysis removes seasonal patterns, such as weather fluctuations or holiday effects, from time series. It’s useful … Continue reading “Seasonal adjustment Census X-13”
Overview Settings Method Length Mode Force Examples Questions What is the difference between the Rate of change analysis and selecting ‘Rate of change since’ when doing a Cross sampling analysis? Why annualization in Rate of change analysis works differently than in Cross sampling analysis? Overview Example of general use of Rate of change analysis calculating … Continue reading “Rate of change”
Overview Settings Change since, date and period Method Examples Questions Why does the output doesn’t start with 0? Why Year-to-date isn’t calculated till selected date? Overview Example of general use of Performance analysis calculating Year to date for current year (in percentage): The Performance analysis allows you to see how a time series has changed … Continue reading “Performance”
Overview Settings Output series Epochs Prefer before previous Example Overview The Zero coupon rate analysis uses the Libor Market model to construct zero coupon rates at different maturities. Such rates can typically not be observed directly on the market except for short deposit rates. Longer rates are then constructed based on the shorter rates by … Continue reading “Zero coupon rate”
Overview Theory Automatic bin Density methods Cumulative distribution methods Settings Report Examples Questions Can I plot two histograms on one chart? How to display the relative density as percentage of the total number of observations? Overview Example of general use of Histogram analysis showing distribution of YoY% values for US CPI: With the Histogram analysis, … Continue reading “Histogram”