Standard deviation in each year & dummy industry
Posted: Sat Dec 22, 2018 1:38 am
Hi! I have a question about the standard deviation function in Eviews. Let's say I have GDP of a country over a period of about 20 years. I want to calculate the standard deviation of it in each year. When I use @stdev function, it gives me the same value for every company in every year. What I want is the standard deviation in each year which means it would change every year for every firms. I tried @stdevsby function but it gives me yearly standard deviation and does not change over companies. So, how to calculate it to get yearly and firmly data?
And I have an industry variable that takes value of 1 to 48 to specify 48 industries. I want to run a regression with a control of industry. However, since I am needed to drop the observations that is less than 20, therefore there are some industries that is dropped which makes the industry variable becomes not continuous. For example, for industry I might only have industry 1, 5, 8, 13, and 21. I want to use @expand(industry, @drop(1)) function in the regression, but it suddenly shows near singular problem. Can anyone help me?
Thank you in advance!
And I have an industry variable that takes value of 1 to 48 to specify 48 industries. I want to run a regression with a control of industry. However, since I am needed to drop the observations that is less than 20, therefore there are some industries that is dropped which makes the industry variable becomes not continuous. For example, for industry I might only have industry 1, 5, 8, 13, and 21. I want to use @expand(industry, @drop(1)) function in the regression, but it suddenly shows near singular problem. Can anyone help me?
Thank you in advance!