I know that taking log can’t apply with “0” (zero); however the raw data has some of “0”.
So my question is how can I take log with such data (include some “0”? Or if you have any suggestion please let me know. My friend told me that I might classify data in group, but I have no idea how to do it. Please help.
The data is “panel data”
Thank you.
[example data]
https://imageshack.com/i/pnO3QDLQj
Taking log of non-positive number as “0”
Moderators: EViews Gareth, EViews Moderator
Taking log of non-positive number as “0”
Last edited by Namploy on Mon Mar 05, 2018 11:49 pm, edited 1 time in total.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Taking log of non-positive number as “0”
What do you want the log of zero to be?
Follow us on Twitter @IHSEViews
Re: Taking log of non-positive number as “0”
EViews Gareth wrote:What do you want the log of zero to be?
Thank you for you response.
For your question, I still have no idea what could "log of zero" be? Actually, I don't understand EView Program very well.
Let me explain it
I do "Simultaneous Equations" between demand and supply by running data in 3 steps as follows:
1. run all data by regression
2. adjust result/equation by take log, which is the problem because "0" in data
3. estimate data by 2SLS (two-state least square)
I already test data in Stata which the program exclude "0" automaticly and has some summary. Anyway I would like to run data agian by EViews program to compare the results, but I stuck in 2nd step.
Thank you
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Taking log of non-positive number as “0”
Not sure what you mean. EViews will drop the zero observations if you're taking logs.
Follow us on Twitter @IHSEViews
Re: Taking log of non-positive number as “0”
EViews Gareth wrote:Not sure what you mean. EViews will drop the zero observations if you're taking logs.
I'll check data now. thank you
Who is online
Users browsing this forum: Google [Bot] and 38 guests