Introduction to Panel Data, Multiple Regression Method, and Principal Components Analysis Using Stata: Study on the Determinants of Executive Compensation—A Behavioral Approach Using Evidence From Chinese Listed Firms

Abstract

This case study illustrates a quantitative research study on accounting and finance using panel data from firm databases. Our research argues for the existence of a reference point effect on executive compensation determination, internally (the pay of other directors on board), externally (the industry peer executives’ average pay), and historically (the executive’s pay in the last period), in Chinese listed firms. We illustrate (1) the research process of variable design, including the design and understanding of dependent variables, independent variables, and control variables, as well as the relevant hypotheses development and multiple regression models using firm data and the panel data context; (2) the process of data collection using secondary data from financial database and the construction of a panel dataset; (3) the commands in Stata to run the ordinary least squares multiple regression; and (4) the principal components analysis capturing the systematic effect of the three reference points and perform the principal components analysis in Stata.