Overview Why use Formulas? How to work with Formula analysis? Aliases Expression Case sensitivity Include input series as output Applying formulas: Series list vs. Formula analysis How to create a formula in the Series list? How to create a formula in the analysis tree? Frequency How does the Formula language work? Input variables Dates Window … Continue reading “Introduction to Formula”
Overview Estimation model Working with Rolling regression analysis Settings How to create simple rolling regression model? Common errors Forecast Report How to output indicators? Calculating regression with formulas Examples Questions Why rolling regression’s average residual is not zero? Why model’s values are different than the ones coming from a same model but rolling? Overview The … Continue reading “Rolling regression”
Overview Estimation model Working with Regression analysis Settings How to create simple regression model? How to add best fit line through different series’ last values? Common errors Too few time series in graph Degree of freedom is too low Forecast How it works? Dynamic forecast Report Overview How to output indicators? Errors Calculation range end … Continue reading “Regression”
Built-in formulas Extend() Extend with last value to the end of a period Extend with another value to a specified point in time Extend with last YoY percentage from same series ExtendLinear() vs LinearExtended() Extend trend from part of series Extend with value x observations from end of series Extend with x last values and … Continue reading “All about extending series”
How to: annualize a monthly P/P series with a formula? change the color of a series when it’s below / above 0 (or any other value)? create an if condition/statement? create a continuous growth rate? combine an if condition/statement with the logical operators and/or? disaggregate a series? make an index out of P/P series? replace … Continue reading “Calculations with formulas”
Overview Settings General Select method for creating matrix Select window type Output Example Overview The Rolling principal components analysis (Rolling PCA) allows you to calculate a set of linearly uncorrelated series, or components, from a set of possibly correlated series. Rolling PCA enables you to do a time-dependent calculation which uses a moving or expanding … Continue reading “Rolling principal components analysis”
Introduction Benefits of using Ratios Types of ratios How it works? Other macros Settings Frequency conversion Missing Data Seasonal adjustment Currency conversion Additional settings How to apply a ratio? Checking calculation behind a ratio Introduction With the Ratios feature, you can have most series as divided by common rations such as GDP or population in … Continue reading “Ratios”
Overview Estimation model References Settings Report Examples Questions If I’m getting p < 0.05 does that mean series has unit root or not? Overview The Unit Root Test provides you with a tool to test if a series is non-stationary. More specifically, it performs an Augmented Dickey-Fuller (ADF) test of the null hypothesis that a … Continue reading “Unit Root Test”
What is it for? Settings Any series All series All points Settings for Daily series Setting the missing value method What is it for? The Observations setting allows you to adjust how inconsistencies between different calendars of observations should be treated. This is useful when time series have missing observations for certain calendar dates like … Continue reading “Observations setting”
Purpose Region key/Concept Change region / Change region & duplicate How to apply change? Change region in… Documents Series and expressions Series information Documents tab Multiple documents File > Open documents Presentation documents Purpose The Change region feature is used to replace a series in your document by an equivalent series for another country. Applying … Continue reading “Change Region”