No video

Using Excel for Basic Forecast Smoothing

Naive forecast, moving average, weighted moving average, and exponential smoothing with monthly data and excel.

Пікірлер: 54

  • @TheJamesgus
    @TheJamesgus12 жыл бұрын

    I just have to say that you have actually saved my life, I think it is a wonderful, generous gesture to share your knowledge with everyone like you have done. Angus - University of Sydney, Australia

  • @Romeowasbleeding1
    @Romeowasbleeding113 жыл бұрын

    Great stuff! No frills, no nonsense, just pure info! This is how teaching should be done

  • @gayleotherson
    @gayleotherson5 жыл бұрын

    Thank you! Thank you! Thank you! For the life of me I could not figure out how to forecast with only one known month value. Very helpful.

  • @zebbiereed6843
    @zebbiereed68439 жыл бұрын

    This is great, has everything needed on one spreadsheet and easy to understand. Thanks!

  • @PrincessCandiPants
    @PrincessCandiPants12 жыл бұрын

    THANK YOU SOOOO MUCH, YOU SAVED ME ABOUT 5 HOURS AND A COUPLE OF TEARS! GOD BLESS!

  • @baconandeggslol
    @baconandeggslol12 жыл бұрын

    You sir, are a scholar and a gentleman. Thank you so much for this useful tutorial!

  • @henrymorgan3212
    @henrymorgan321210 жыл бұрын

    Very well done. Crisp and to the point. Thank you

  • @sophiavaldes9150
    @sophiavaldes91509 жыл бұрын

    Thank you so much! This was incredibly helpful and easy to follow along.

  • @EDGE94
    @EDGE947 жыл бұрын

    This vid is awesome! Perfect for simultaneously understanding simple logistic methods and Excel formulas. My recommendation: Draw the graphs to for a quick guesstimation of accuracy of the smoothing types. ;)

  • @jaebee75
    @jaebee7513 жыл бұрын

    Great video for this MBA student who was really lost! that's ME... thank you so much for posting this info.

  • @joanolivero3112
    @joanolivero31127 жыл бұрын

    You my man are by far the best

  • @gretinaaaron7076
    @gretinaaaron707611 жыл бұрын

    BIGGGG THANK YOU!!! You mad this so simple :) OMG!! I'm so thanking you RIGHT NOW

  • @NawfKarkar
    @NawfKarkar9 жыл бұрын

    You are amazing this was truly helpful - Keep it up : )

  • @dmoney141414
    @dmoney1414142 жыл бұрын

    Amazing video! Thanks for creating this.

  • @SpaceOverTime

    @SpaceOverTime

    2 жыл бұрын

    Glad you liked it!

  • @Alsterz09
    @Alsterz0912 жыл бұрын

    This was incredibly helpful!!!!

  • @mikemcpherson7246
    @mikemcpherson72467 жыл бұрын

    life saving! Thank you!

  • @danutoprisan8657
    @danutoprisan86574 жыл бұрын

    I know this is an old video and you are probably not reading the comments anymore but thank you so much for the video! It has been extremely helpful!

  • @randomnormal

    @randomnormal

    4 жыл бұрын

    Thanks! Comments come in but it's hard to get back to folks - busy, busy, busy. I'm glad it helped out.

  • @SpaceOverTime

    @SpaceOverTime

    4 жыл бұрын

    Thanks! Glad it helped. I'm looking into updating the videos, adding missing parts, etc. I love this stuff. Excel has had multiple version updates since these videos were created.

  • @Ange6681
    @Ange668110 жыл бұрын

    Thank you, very helpful.

  • @MrMuhamad1994
    @MrMuhamad19947 жыл бұрын

    Really helped me thanks!

  • @thelovepirate99
    @thelovepirate9913 жыл бұрын

    Thank you. I wish you were my teacher!

  • @swspain1
    @swspain19 жыл бұрын

    Nice and easy explained

  • @jererider1473
    @jererider147310 жыл бұрын

    where is the second part

  • @meralynlebante
    @meralynlebante7 жыл бұрын

    Do you have an example for Annual data. Can I use this method using annual data like 4 years?

  • @TheJadeleesyra
    @TheJadeleesyra11 жыл бұрын

    Nice tutorial but I was wondering if the second video ever released?

  • @derekm5861
    @derekm58617 жыл бұрын

    @Spaceovertime did you ever make a part 2?

  • @verygood5377
    @verygood53778 жыл бұрын

    Can we have the tutorial video on MAD from you? Thanks!

  • @amarkurkute1897

    @amarkurkute1897

    7 жыл бұрын

    hj)),ll&¡😐😡😬😉😠😡😯😐😅😆😇😈😉😉

  • @michaelinman5720
    @michaelinman57207 жыл бұрын

    did anyone ever find the MAD from this guy. he is clear.

  • @rockstonedread
    @rockstonedread12 жыл бұрын

    LIFESAVER!!!!!!

  • @francimemoris
    @francimemoris8 жыл бұрын

    thanks much!!

  • @TheNotho
    @TheNotho11 жыл бұрын

    At 5:00, if I were to do an exponential smoothing forecast for January (cell E17) then is it true that the previous forecast would be the forecast for the preceding December which can be calculated by taking the average of all actual demand values preceding that for December (B16)?

  • @loredix9221
    @loredix92218 жыл бұрын

    Thank youuuuuuuuu

  • @TheodoreLemoi
    @TheodoreLemoi10 жыл бұрын

    TY

  • @estrelitameneses2292
    @estrelitameneses229211 жыл бұрын

    agree

  • @chocolate1617
    @chocolate161713 жыл бұрын

    nice vido

  • @syn3rgy86
    @syn3rgy8613 жыл бұрын

    this is a great video. straight to the point. my prof teaches like shit.

  • @ambergraham7421
    @ambergraham74218 жыл бұрын

    Is this how much money you make on a monthly basis to get the average of 3 months?

  • @aydaalsherooqi8745
    @aydaalsherooqi87458 жыл бұрын

    Dear, where is the next lesson for MAD. Pleeease replayyyy. Thank yoooou alot

  • @verygood5377

    @verygood5377

    8 жыл бұрын

    +Ayda Alsherooqi Hello, have you found lesson for MAD finally? I need MAD too. Thanks!

  • @faykimura152

    @faykimura152

    2 жыл бұрын

    @@verygood5377 OMG it is 2022 now... so did you find it? XD

  • @verygood5377

    @verygood5377

    2 жыл бұрын

    ​@@faykimura152 not yet...🤦‍♂

  • @snowman3232
    @snowman323211 жыл бұрын

    Where is part two?

  • @teresapoon157
    @teresapoon1573 жыл бұрын

    I learnt it from james brox at my master of econometrics degree lectures. Teresa, Monash university, Australia.

  • @nicktelsa3473
    @nicktelsa34736 жыл бұрын

    Mr. Philip are you still alive? no reply since a couple of years? where is the other part of the video?

  • @NormanTyron
    @NormanTyron11 жыл бұрын

    IM From SLU Baguio and I cant answer my midterm exam please help me with this

  • @anthonydillon8596
    @anthonydillon859611 жыл бұрын

    I wish youtube was a university, so i can choose the professors i want.

  • @firmannugraha1
    @firmannugraha112 жыл бұрын

    You make it easier to do with cigaret!!

  • @teresapoon157
    @teresapoon1573 жыл бұрын

    And I don't think Sam Wong or Kevin poon can answer. I got all the PhD of econometrics theory answers. From banking field econometricians.

  • @shohanhoque
    @shohanhoque11 жыл бұрын

    Have you heard about Smarter Money Maker? (Go google it) It is a fast and simple way for you to earn money fast