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
xtreg results or margins to show correlation coefficent with each level of interacted factori'm trying to model the linear relation in a panek of continuous indep var X on continuous dep var Y…
Creating a variable by grouping based on three variablesHi Everyone, I am working with the following experiment data, where I have provided a sample below.…
generating DHS indiciatorCan someone guide me how to generate percentage of basic and limited sanitation service for nigeria …
Time-invariant characteristics conflict in panel data.Dear all, I am reading a description of panel data. According to the description, it says that gend…
RMSEA 90% CI using Satorra-Bentler in sem CFAI am running a CFA using sem but am having trouble figuring out the output and possibly whether ther…
Subscribe to:
Post Comments (Atom)
0 Response to Year over Year Calculations
Post a Comment