Thank you so much for this simple yet informative explanation, Doc!

thank you!! I was so confused and so tired of doing each one by hand!

Thank you so much. You have the simplest explanation. Very easy to understand

Thanks for this video!!

THANK YOU FOR MAKING THIS VIDEO.

Nice tutorial. Learnt a lot.

Seriously, thank you.

@TheStatsFilesDawnWrightPhD

4 жыл бұрын

Thanks for the positive feedback.

Nice explanation. I need this information for a class. Thanks for making the video.

@TheStatsFilesDawnWrightPhD

4 жыл бұрын

Thanks for the feedback!

thank you so much sir. I need this thankssss again

Yes.Helpful for me.Thanks for making video

@TheStatsFilesDawnWrightPhD

5 жыл бұрын

Thanks for the positive feedback. If you have a topic you need help on, let me know and I will make a video.

@simfinso858

5 жыл бұрын

The Stats Files - Dawn Wright Ph.D. Sir I want to calculate 50 day or 200 day EXponentially smoothing average for Google stock price .what demping factor I should use? or Guide me How to calculate 200day EMA for stock price?.Thanks.

@markcamfferman

5 жыл бұрын

Dear Mr wright, do you also made a explanation video for trend and trend/season forecast method?

THANK YOU SO MUCH

Hi, How can I use Exponential Smoothing to find, for example, the forecast values for Feb and Mar and so on in that year?

@TheStatsFilesDawnWrightPhD

4 жыл бұрын

Exponential smoothing and moving average are limited to just one period ahead. There are many more advanced forecasting tools. Take a look at the Forecast Sheet tool in the Data ribbon in Excel 2016.

Thank you

Hi, for exponential smoothing forecast, I can only forecast for a month?

@TheStatsFilesDawnWrightPhD

6 жыл бұрын

Yes, generally that is true because you need an "actual" period value in the formula for the next period. But depending upon your real-world situation, you could possibly use the calculated value for an estimate of 2 or at most 3 periods beyond your actual data. In many academic settings, the answer would be that you can only go 1 period into the future.

@chengyeeshee7424

6 жыл бұрын

Thanks for your reply. Your video is very helpful for my assignment

What is the benefit of this technology since we can only forecast one month? How can I forecast for several months to come?

@TheStatsFilesDawnWrightPhD

4 жыл бұрын

Yes, it is just a basic tool, as is moving average. There are a number of other ways to forecast ahead using forms of regression. But with all of them, you must understand that the accuracies of the forecasts get worse the farther into the future you try to forecast. Take a look at Excel 2016's Data >Forecast Sheet tool and you will be able to forecast further into the future and get the confidence intervals around the forecasts.

@sulimanalmasry6854

4 жыл бұрын

@@TheStatsFilesDawnWrightPhD Thanks for replying

how can i find alpha from my data ?

@TheStatsFilesDawnWrightPhD

6 жыл бұрын

Degi, in an academic setting, you will likely be given the alpha to use in your problem. In the "real" world, I would suggest using an optimization of an error metric, e.g. MAD, MSE, MAPE, perhaps using Solver. I have a video showing how to do that. kzread.info/dash/bejne/eXunx5dyYdWaqtI.html Hope this helps.

@degigerel6286

6 жыл бұрын

thanks Dear :), i needed alpha in real world.