How does Excel calculate the Alpha, Beta, Gamma parameters in the AAA-ETS algorithm?

demosfen 20 Reputation points
2025-03-18T10:51:42.9533333+00:00

FORECAST.ETS and other .ETS functions uses an AAA version of the Exponential Smoothing (ETS) algorithm. I have not found mentioning what specific parameters are used in these functions and the result in them differs from the results in the same functions in other editors (LO for example with the same data). Is there a link explaining what value is used in the forecast under the hood?image

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua 18,065 Reputation points Moderator
    2025-03-19T05:31:33.5566667+00:00

    Hi @demosfen

    Sorry, I do not find any Microsoft documents that describe the specific calculation formula or optimization algorithm of the parameters in detail.

    Excel formula calculation has a high degree of automation, it is difficult for us to directly obtain the exact values ​​of α, β, and γ parameters, which involves the development of Excel.

    Thanks for your understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.