Hi,
I have seen an example of a macro which finds Alpha, Gamma, phi and some data statistics from data set. This spreadsheet is attached "Exponential_Smoothing_Macro-2017", this appears to be using data analysis toolkit in excel.
I am hoping to use this methodology in my own spreadsheet, but have trouble trying to replicate. I am hoping to use this in the attached spreadsheet "Scenario Analysis" under forecasting.
Does anyone know how to replicate this macro, or how to impliment the smoothing in excel?
Thank you all kindly for any help or suggestions.
