I have to make a double sorted portfolio analysis.
First I need to regress a simple linear model with 4 independent variables, and find the error term.
I need to do this for around 100 persons in a sample, in a quarterly time span for 6 years.
From the error term I should then estimate the standard deviation.
Then I need to categorize the standard deviations of the error terms into four portfolios, from low to high.
How could I estimate the error for all persons at every different time all at once?
The data that I use is in Excel and looks like this:
Dates Name Variable1 Variable2 ... etc
Q12013 X 100
Q22013 X 103
Q32013 X 122
Q42013 X 98
Q12014 X 128
.......
.....
Q12013 Y 110
Q22013 Y 105
Q32013 Y 132
Q42013 Y 39
Q12014 Y 138
.......
.....
Q12013 Z 87
Q22013 Z 115
Q32013 Z 139
Q42013 Z 87
Q12014 Z 132
Related Posts with Double sorted portfolio - Error Estimation
Marginal effect for multiple quantile regressionsHi all, I am running multiple quantile regressions (16 to be exact) with an interaction of two cont…
Analysis of stock market data - Excel or Stata?Hi, I have daily stock market data of 728 firms from 2000 to 2015 (about 4200 prices per stock). I …
results missing from correlation matrix?Hi guys I am not sure why STATA dropped some variables in the corr table:as attached the second pic…
How to run Nearest Neighbor Matching (nnmatch) on panel data?I am trying to run a Nearest Neighbor Matching in order to run a DID inference on it. Background: …
Using fixed effects with Bayesian analysisI am working on a project where I use Bayesian regression. My dataset has multiple records for each …
Subscribe to:
Post Comments (Atom)
0 Response to Double sorted portfolio - Error Estimation
Post a Comment