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 Example … 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 End date Report Overview How to output coefficients? Errors Calculation … Continue reading “Regression”
Overview Settings Covariation type Explanatory Length Annualize Examples Overview Example of general use of Covariation analysis showing 3-year covariance and correlation on Y/Y series: The Covariation analysis can measure several statistical indicators on a rolling basis: standard deviation correlation covariance linear regression intercept (alpha) linear regression slope (beta) Settings Covariation type Select the type of … Continue reading “Covariation”
There are two ways of adding trend/best fit line – Statistics and Regression analyses. First one is designed for typical Time charts, second for Scatter charts. Note, it is also possible to omit both those analyses and just use calculations recreating what Regression does and present outcome on Category scatter chart. Line from Statistics In … Continue reading “How to add a trend line/best fit line?”