Stata required

Excel reference data in : Comment section

I don't know how to attach excel file in question so provide you data in comment

Question No.2 (Marks 15) 1. For question 2 refer to the MS excel named as dataforquestion2. 2. Make a do file as question2 do file and a result (SMCL)_file as question2 result file. 3. Perform the following steps a. Run the following model on the data file using fixed and random effects QPR./TAu=6. + 6: 1/TAjes + 6, (OPR./ TAu.)+ 6,MTB.. + 64(ARecu/ TAct2) + 8,(ARec. / TAu) + Ha In the equation , QPRif is operating revenues for firm / in year f, defined as the sum of revenues from sales and services and other revenues generated from operating activities; Air-/ is total lagged assets; MYBi, t-/ is the market-to-book ratio in lagged period while ARecit is accounts receivable of current period. The first central variable is operating revenues of immediate previous period (OPRit-/). This variable is incorporated by researchers as mechanism to regulate operating revenues perseverance and this approach is consonant with the method adopted by McVax (2006). Furthermore, many researchers have used lagged period variable as a proxy to find succeeding period specific variable. Though, only including lagged operating revenue as proxy for determining the following period earnings has its own limitation as this might not be applicable for firms experiencing abnormal growth. Thus market-to-book ratio in lagged period (MYBit-/) is comprehended in this model to eliminate the paucity of previous researcher model and this is consistent with the work of several researchers who significantly contributed in the methodological literature of earnings management (Abdelsalam et al, 2016; Roychowdhury, 2006). b. Decide whether to go for fixed or random effects c. Submit the do and result file as instructed