Testing Roberts's Law: data request on CEO pay and company characteristics

Question

I posted here regarding sources for Roberts's Law.

In this paper it gives a clear qualification of what Roberts's law is. (Page 9, ...Cross-sectional prediction..)

..In a given year, the compensation of a CEO is proportional to the size of the firm to the power of 1/3, S(n)1/3, an empirical relationship sometimes called Roberts’ (1956) law.

This gives us the following formula:

$ Pay$~$Size^b$ with $b ≃ 1/3. $

I could not find much info on how to calculate firm size so I dug around and found another paper titled "What Determines Firm Size? "

I found that there was an equation given and explained on page 10.

The average firm size in each size bin is first calculated by dividing the number of employees by the number of firms. The average size for the entire sector is then calculated as the weighted sum of these bin averages, using as weights the proportion of the total sectoral employment in that bin. This produces a “employee-weighted” average of firm size.

Employee Weighted Average Number of Employees =$${\sum_{bin=1}^n}(\frac{N^{Emp}_{bin}}{N^{Emp}_{Sector}})(\frac{N^{Emp}_{bin}}{N^{Firm}_{bin}})$$

Emp bin is the total number of employees in a bin, N Emp Sector is the total number of employees in the sector, and NFirms bin is the total number of firms in a bin. In contrast to the firm-weighted simple average, the employee-weighted average emphasizes the larger firms; note the squaring of bin employment in the numerator.

Robert's law is now:

$$Pay={\sum_{bin=1}^n}\left[\left(\frac{N^{Emp}_{bin}}{N^{Emp}_{Sector}})(\frac{N^{Emp}_{bin}}{N^{Firm}_{bin}}\right)\right]^{b}$$ Now I am aware I'm kinda just copying and pasting and my research may be incorrect. But i'd like some data to test Roberts's law.

Where can I find data on CEO pay and company information?

Answer 1

There are plenty of papers studying CEO pay and firm size empirically. Check a long list here. Some examples of data sources:

• US: Execucomp, used by Gabaix, Landier, and Sauvagnat (2014).

• UK: Hemscott and Datastream, as used by Ozkan (2009) or Gregg, Jewell, and Tonks (2011). Also, BoardEx and Datastream, as used by Tarkovska (2017). You also have the Bureau van Dijk FAME dataset (used by the Bank of England, e.g. here), but it is proprietary.

• Germany: handpicked from financial reports as in Heimes and Seemann (2012), or data obtained from the consulting firm Kienbaum, as in Fabri and Marin (2015).