Use “Auditfees” data, sample codes and refer to the course ppt to perform the following

Use “Auditfees” data, sample codes and refer to the course ppt to perform the following tasks:
1. How Accounting firms charge audit fees may differ when firms report loss. The relations between our Xs and Y might be different for these two scenarios.
Run the following regression model by whether a firm’s earnings before extraordinary items is negative or not, respectively.
Log(Audit Fees) i,t = β0 + β1 Log(Assets)i, t + β2 Leverage i, t + β3 Profitability t + β4
Rec_Inventory i, t
+ β5 nseg i, t + β6 Big5 i, t ε
Hint: Remove the outliers of leverage, profitability and rec_inventory first.
Briefly comment on the regression results, such as which independent variables are statistically significant and how they are related to audit fees. Are the associations between each independent variables and audit fees same when firms report losses versus when they report profits?
2. Propose a model to examine tax fees. Write down your dependent variable (Y) and independent variables (Xs). Show your codes on how to generate these variables. The independent variables should have some economic meanings and comparable across firms. Briefly explain what firm characteristics each independent variable is used to measure.
3. Run the regression model you proposed for tax fees and report the results.
4. Briefly comment on what you find based on results reported in Question 5.
Hint: focus on the positive and negative relation between Xs and Y, and whether the coefficients are statistically significant