Set up additional transformation parametersSeries values transformation enables the user to perform the What If analysis by applying different transformations for the series values and compare the results.
To select the series values transformation method:
Select the Apply Transformation checkbox on the Primary side panel tab and specify the required transformation in the drop-down list.
Use the drop-down menu of the Show As button on the Home or Data ribbon tab.
Use the submenu of the Show As item in the time series's context menu in the data table.
Transformation results are displayed in the current workbook.
The following transformations are available:
Initial Value. No transformation (default).
Natural Logarithm (log). Taking the logarithm of series points: ln(X[t]).
Logarithms Difference. Calculation of the difference of logarithms of neighboring points of the series for a certain period (ln(X[t]/X[t-N])):
dlog PoP. Previous period.
dlog YoY. Corresponding period of the previous year.
dlog YTD. The end of the previous year.
Rate of Change. Calculation of the rate of change to the previous period (in percents) (X[t]/X[t-N]-1)*100):
pch PoP. Previous period.
pch YoY. Corresponding period of the previous year.
pch YTD. The end of the previous year.
Difference. Performs transformation y[t] = X[t] – X[t-N] for a certain period:
diff PoP. Previous period.
diff YoY. Corresponding period of the previous year.
diff YTD. The end of the previous year.
Normalization (norm). Normalization of modeled variable points: X[t]/(σX), where σ - root mean square error.
Standardization (std). Standardization of modeled variable points: (X[t]-M(X))/σ(X), where σ - root mean square error, M - average of the series.
Growth Coefficient. Growth rate calculation for a certain period (X[t]/X[t-N]):
ratio PoP. Previous period.
ratio YoY. Corresponding period of the previous year.
ratio YTD. The end of the previous year.
Annual Rate of Change (pchA). Calculation of the annual rate of change in percents: (((X[t]/X[t-1])^S)-1)*100, where S - the number of periods in a year.
Set up additional transformation parameters
See also:
