Exponential Smoothing on Excel, use MSE, MAE, and MAFE

Поділитися
Вставка
  • Опубліковано 12 лис 2024

КОМЕНТАРІ • 25

  • @Vegbunny
    @Vegbunny 3 роки тому +3

    I was drowning in my forecast chapter for my MBA, this really helped!

  • @radhakrishnanr9067
    @radhakrishnanr9067 Рік тому +1

    Good explanation. You could use 'AVERAGE' function to calculate MEAN

    • @DavidJohnk
      @DavidJohnk  Рік тому

      Thanks for the positive feedback! Yes, when I was doing the video I thought about that, but decided to show an alternate way.

  • @VinnyG1995
    @VinnyG1995 3 роки тому

    Incredibly helpful! Been struggling with this for a week in my MBA program. Thank you so much!

    • @DavidJohnk
      @DavidJohnk  3 роки тому

      Glad it helped thanks for the positive feedback !

  • @georgiakicklighter5943
    @georgiakicklighter5943 3 роки тому +1

    Thanks so much for making this a public video! Really helped me for my own class!

  • @nvsyashwanth918
    @nvsyashwanth918 Рік тому +1

    Thanks for the clear explanation!

  • @deepanshu1077
    @deepanshu1077 Рік тому +1

    Great explanation sir👍👍

    • @DavidJohnk
      @DavidJohnk  Рік тому

      Thanks for the postive feedback!

  • @austinbright-j3o
    @austinbright-j3o 3 місяці тому

    How can I build forecast.ets function essentially by hand so I have more control over inputs? I ran forecast.ets.stat so I have the smoothing parameters. Do you have videos on the equations so I can reproduce the results of the exponential smoothing by hand?

  • @LalitKumar-nj7xc
    @LalitKumar-nj7xc 2 роки тому +1

    Thank You

    • @DavidJohnk
      @DavidJohnk  2 роки тому +1

      You're very welcome, hope it helped!

  • @sunilvaland7833
    @sunilvaland7833 3 місяці тому

    Alpha value _0.1 is it fixed or change

  • @DavidJohnk
    @DavidJohnk  4 роки тому +1

    You're welcome!

  • @curlieq20
    @curlieq20 4 роки тому +1

    Thanks for the explanation!

  • @ganshuqianbriana7081
    @ganshuqianbriana7081 4 роки тому +1

    Thank you so much for this video! IT helped me!!!

    • @DavidJohnk
      @DavidJohnk  4 роки тому

      Glad it helped, thanks for the positive feedback.

  • @madinagurgunayeva5506
    @madinagurgunayeva5506 4 роки тому +1

    It's so helpful. thank you!

  • @aridirgaa
    @aridirgaa 4 роки тому +1

    Tanks you mr