Hello everyone,
I am analyzing a sample of many firms with data recorded over a period of 30 years. I have data related to Total Assets (End of Period), but in order to go on with my analysis I need (for every firm in every year) the Average Total Assets between current year and previous year.
For example, let's say I have three firms (X, Y and Z) with data related to total assets for three years (20X1, 20X2, 20X3). I'm looking for a single function that compute the average total assets between 20X1 and 20X2 for firm X, the average total assets between the same years for firm Y, the average total assets between 20X2 and 20X3 for firm X, and so on.
Thanks for the attention.
Daniel
Related Posts with Year over Year Calculations
Correlation tables and R-squared in panel dataDear all, currently I'm running a panel regression as a part of a seminar. My topic is the statisti…
Count function using stringDear All, I am using firm-level data to gather information on the number of products produced withi…
MergeHi all, I have the following two datasets. The first one looks like follows: Code: * Example gene…
type mismatch in a regression with &Hello, When I run this regression : xi: areg z_educ i.stateid hhsize highest_maleeduc highest_femed…
Numbering Similar ObservationsHello, I'm having significant difficulty numbering observations. I've attached a screenshot for cla…
Subscribe to:
Post Comments (Atom)
0 Response to Year over Year Calculations
Post a Comment