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
Multiple first difference generationI have a number of macro variables that are common and are only differentiated in their names by add…
xtcointreg - "command cointreg is unrecognized r(199)"Dear Statalists, After successfully installing the command xtcointreg using "ssc install xtcointreg"…
Problem in creating a string variableHi dear profs and colleagues, I am going to create the native_districts_constant variable. The vari…
Delete panel data observation if price i below certain thresholdHi, I'm working with a panel data set that consists of daily stock prices. I would like to create a…
Multiple stored results from tabstat and esttabDear All, I am running different summary statistics based on the if condition. Then I am trying to …
Subscribe to:
Post Comments (Atom)
0 Response to Wrangling panel data - calculating growth rates and cagr
Post a Comment