SMAPE and MASE formulas in ETS

%3CLINGO-SUB%20id%3D%22lingo-sub-2098958%22%20slang%3D%22en-US%22%3ESMAPE%20and%20MASE%20formulas%20in%20ETS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2098958%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20knows%20the%20formulas%20Microsoft%20used%20for%20SMAPE%20and%20MASE%20errors%20produced%20when%20using%20ETS%20routine%20for%20forecasting%20in%20Excel%3F%20Is%20there%20a%20technical%20documentation%20available%20anywhere%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2098958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2098977%22%20slang%3D%22en-US%22%3ERe%3A%20SMAPE%20and%20MASE%20formulas%20in%20ETS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2098977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943576%22%20target%3D%22_blank%22%3E%40bpecaruk1953%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-forecast.ets.stat-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHow%20to%20use%20the%20Excel%20FORECAST.ETS.STAT%20function%20%7C%20Exceljet%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2100902%22%20slang%3D%22en-US%22%3ERe%3A%20SMAPE%20and%20MASE%20formulas%20in%20ETS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2100902%22%20slang%3D%22en-US%22%3ESergei%2C%20thanks.%20I%20did%2C%20but%20there%20is%20no%20formula%2Fequation%20showing%20how%20are%20these%20two%20errors%20calculated.%20Wikipedia%20shows%20at%20least%20three%20formulae%20for%20SMAPE%2C%20for%20example.%20Which%20one%20was%20implemented%20in%20Excel%3F%3C%2FLINGO-BODY%3E
New Contributor

Does anyone knows the formulas Microsoft used for SMAPE and MASE errors produced when using ETS routine for forecasting in Excel? Is there a technical documentation available anywhere?

4 Replies
Sergei, thanks. I did, but there is no formula/equation showing how are these two errors calculated. Wikipedia shows at least three formulae for SMAPE, for example. Which one was implemented in Excel?

@bpecaruk1953 sorry, I'm not an expert here and I don't think more info as in above post is published. Concrete algorithms are usually hided.

No worries. I was hoping that someone who has access to technical documentation might pick this one up an respond. In any case, thank you for trying.