I have tried to develop an Unrestricted VAR Model in EVIEWS, but the values were coverted to Log. Now that the forecasting has been done, I want the values to revert to Normal VALUES so I can work out the Year-on-Year inflation.
If you want to delog, you can simply take the exponent of the value(s) that you've got. However, if you need to calculate year-on-year inflation, you can still use those log values that you have, because log differences give you growth rates and in the case of prices/cpi, log differences of cpi is inflation. Hope this helps!
Thank you very much Navin Perera for your response. This is excellent.
Hi Emerson Abraham Jackson
You can convert the log values to normal values by raising 10 to the power the log values (you want to convert). For instance if you have 0.30103 as the log value and want to get the normal value, you will have: "10^0.30103" and the result will be the normal value. You can do this in excel given the large nature of your data to save time. In Excel, you give the following command or formula and you will obtain the normal values:
"=10^A", where A represents the log value you want to convert and then you press the "enter key". You don't have to repeat same for all the remaining values; you can just drag starting from the first value you have obtained to the last log value you want to convert. By doing this you will automatically generate the remaining values.
Thanks and all the best.
Thank you very much Samuel Tawiah Baidoo. I have tried it with Exponential of the values in MS Excel instead and it came out very well.
Cheers for your suggestions. Alternatively, I'll also use the method you suggested.
You may use this calculator https://www.healthcare.uiowa.edu/path_handbook/Appendix/Calculators/TenExponential.html
- Badges
- Science method