Thank you for explaining this all so easily. This video really helped me with these concepts I was struggling in. One note: My textbook says MAPE needs to be represented not by dividing by N, but by N minus 1, or 11 in the video's case. So if anyone is also struggling, that could by it.
hello, I am writing a paper on "state-dependent fiscal multiplier in Sub-Saharan Africa (SSA) countries" I want to identify fiscal identification shocks by a forecast error approach. Data: annual data from 15 SSA countries I read in one paper how to compute a forecast error of a variable. forecasts of government spending are taken from October publications of the IMF’s WEO. Then, the fiscal spending shocks are identified as the forecast errors of government spending. Thus, FEi,t=gi,t(actual)-gi,t(forecast) where gi,t= Gi,t/Yi,t is government spending as a share of GDP. The actual government spending comes from the October WEO of the following year. i-refers to country and t refers to time. question? 1. can you help me in attaching the codes of the forecast error approach on excel?
Thanks Dr indeed, can you supplement regarding evaluation performance range/class on each statistical indicator to demonstrate as an interpretation factor.
Use SMAPE instead. ) values in the actual data distort MAPE. See the new version of the worksheet you can download www.drdawnwright.com/use-excel-to-calculate-mad-mse-rmse-mape/
Most authors I know use n. I suspect there maybe some authors who use n-1. I used Evans' 5th Statistics, Data Analysis, and Decision Modeling. Here is a link to Wikipedia that also says use n. en.wikipedia.org/wiki/Mean_squared_error
Hi there, are there any ways to calculate QLike loss function on Excel? Thanks for your content. I achieved the same result for RMSE AND MSE with EViews.
You can model QLike loss function in Excel, though I do not have a video on it now. The thrust of my work is on showing students how to do basic business analytics with just Excel and only the add-ins that come standard with Excel. EViews is nice but expensive.
I've been studying this all week and could not quite "get it", I watched this video and it clicked. Thank you so much!
Thank you for explaining this all so easily. This video really helped me with these concepts I was struggling in. One note: My textbook says MAPE needs to be represented not by dividing by N, but by N minus 1, or 11 in the video's case. So if anyone is also struggling, that could by it.
So helpful, especially for online summer classes, thanks!
Thanks for the positive feedback!
i AM SOOOO GRATEFUL FOR THIS!
Thank you so much for the helpful and simple explanation Dr. Wright. This video was great! 😊
Saved my day! THANK YOU SO MUCH
It is very clear. Thank you for this. Please extend this including how to interpret MAD, MAPE, RMSE
th-cam.com/video/vxtxrcdmqbw/w-d-xo.html
Hi All, what if I have 0 sales but FC what would be then Absolute Value of the Error/ Act Value?
Thank you very much. This was very helpful to me.
Thank you so much for this video. It saved the day!!!
Hi, I would like to ask, does the MAD is similar with MAE? Because the formula looks the same.
Yes, Mean Absolute Error MAE and Mean Absolute Deviation MAD are the same. Different authors use different names .
@@TheStatsFilesDawnWrightPhD Thanks for the explanation and also the video!
It is a perfect explanation. Thank you.
Hallo, what if I have a 0 value as the actual? How to work this out? Thanks
You can use SMAPE when you have zero or near zero actuals.
hello,
I am writing a paper on "state-dependent fiscal multiplier in Sub-Saharan Africa (SSA) countries"
I want to identify fiscal identification shocks by a forecast error approach.
Data: annual data from 15 SSA countries
I read in one paper how to compute a forecast error of a variable.
forecasts of government spending are taken from October publications of the IMF’s WEO. Then, the fiscal spending shocks are identified as the forecast errors of government spending. Thus,
FEi,t=gi,t(actual)-gi,t(forecast)
where gi,t= Gi,t/Yi,t is government spending as a share of GDP. The actual government spending comes from the October WEO of the following year. i-refers to country and t refers to time.
question?
1. can you help me in attaching the codes of the forecast error approach on excel?
Thank you so much, it was very easy to understand ...
Thanks for the positive feedback
Great overview and Excel template setup; thank you!
Can we use forecast minus actual values?
Thank you for the clear explanation, how to select the best method in forecats
Thank you for the positive feedback. Glad it helped.
You can download the Excel worksheet here: www.drdawnwright.com/?p=15718
Thank you :)
Thanks Dr indeed, can you supplement regarding evaluation performance range/class on each statistical indicator to demonstrate as an interpretation factor.
very clear. you are the best . Thank you
Love you bro, thx a lot
I'm trying to calcule WMAPE for some itens. How to proceed when At = 0 for some item?
Use SMAPE instead. ) values in the actual data distort MAPE. See the new version of the worksheet you can download www.drdawnwright.com/use-excel-to-calculate-mad-mse-rmse-mape/
Thank you for the video. I was taught that MSE is divided by n-1, as opposed to n. Is this correct?
Most authors I know use n. I suspect there maybe some authors who use n-1. I used Evans' 5th Statistics, Data Analysis, and Decision Modeling. Here is a link to Wikipedia that also says use n. en.wikipedia.org/wiki/Mean_squared_error
how can i calculate Absolute Error?
MAPE should be in % or not?
MAPE is a percentage. You can reformat to show "%" if you like.
what is ABS?
ABS is the Excel function which finds the Absolute Value.
simply excellent!!!!
Hi, how do we calculate Bias on Excel?
Hi there, are there any ways to calculate QLike loss function on Excel? Thanks for your content. I achieved the same result for RMSE AND MSE with EViews.
You can model QLike loss function in Excel, though I do not have a video on it now. The thrust of my work is on showing students how to do basic business analytics with just Excel and only the add-ins that come standard with Excel. EViews is nice but expensive.
thanks for the reply. much appreciated
Very helpful, thank you!
Glad it was helpful!
MY FIRST ENCOUNTER WITH A CLEAR EXPLANATION TO THIS ITEM BOOKS AREN´ T EASY.COULD BE A GOOD INTERPRETATION OF THE DATA RESULTS ? BEST REGARDS ...
very helpful thank you!
thanks .. you save my life :D
Thanks for the feedback. What other videos/topics would be helpful to you?
How did you get forecast value?
You can use any method to calculate the forecast values, e.g. moving average, exponential.
this eksponential smooting ?
Yes, you can use these metrics to evaluate forecasts made using exponential smoothing.
Thank you!!!!!!!! so helpful
Top esse conteúdo. Muito obrigado!🙂
Great Thank you so much.
Can you share .xls for me? thanks brother...
As soon as I can find it - I made this video about a year ago - I will put a link here.
Thanks for saving my ass/life! Hope you have a good day!!!
Thanks!!!!
Awesome !
Thanks!
Mean square error formula is wrong. The numerator should be divided by n-1 not n.
Check your sources. I think most authors divide by n.
Handy work
very nice work dear.. (y)
Muchas Gracias!!!
Con mucho gusto!
I LOVE YOU
thank you
Thank you for the positive feedback!
formula of MSE is wrong, it is not 'n', it is 'n-1'
Please check your source. My references all use n and not n-1.
super! thanks!
great
thanks, my nigga!