I am working with bisnode panel data https://www.bisnodegroup.com/solutio.../company-data/ which has ID, year, and company revenue info.
I would like to calculate Year-on-year revenue growth (i.e. growth compared to previous year) and CAGR (Compounded Annual Growth Rate) over a multiple year period https://www.investopedia.com/terms/c/cagr.asp
I have never worked with panel data before, so not sure how to it....I've only ever done it for timeseries data (i.e. single company).
The other thing I want to do is remove all companies that at some point had revenues, but had zero revenues in a later year. (if they had zero revenues in the beginning, but later had positive revenues, then I don't want to remove them.
Any suggestions/ideas/advice?
Related Posts with Wrangling panel data - calculating growth rates and cagr
How to use "/" in StataHi everyone, I would like to know how to build a code that lets me display the following data: Ind…
Merging two databases. With different dates. Best method?Dear members, These days I am working on my (master) thesis and I am working with Stata in order t…
panelsubmatrix(): 3301 subscript invalidI use stata15 and I write Code: xsmle INDEX CREDDEV CHEXCHRATE UNINF, wmat(Z) model(sdm) and I ge…
is it possible to do a repeated Measures ANOVA without case identifierHi all, I am currently using a Qualtrics platform survey to measure the perceived social consensus …
Implement Multinomial Logit Model using ml commandI would like to implement multinomial logit model using maximum likelihood command to generate the s…
Subscribe to:
Post Comments (Atom)
0 Response to Wrangling panel data - calculating growth rates and cagr
Post a Comment