Complete Question

Advanced Research Methods

reference: Excel Data (bit . ly / 2UihCNv) remove space

General Instructions

1.Individual assignment

3.This assignment should be completed on excel file

5.Late submissions will not be entertained and there is no second say about this.

I'm unable to post excel data so i provide sheet link

I provide you Excel file in Comment Section

_Questinn 1. Refer to the Excel Data File 2. Estimate the following model using 0L5, random effects and xed effects with robust standard errors- (Lisa's = at] + 'lNWC + gaze! + arm's}, + graph + C'APEX In above equation 1, CASH is refers to cash and cash equivalents held by rm i at time t. The star denotes that it is the optimal 1'ralue or equilibrium represented by the tted line of this equation. is the intercept. W n. represents networking capital employed by rm iat time t, measured bjr taking the di'erence of current assets and current liabilities. Mr is actually the rm's size which is measured by taking the natural log of total assets held by a rm. Br depicts rm's book to market ratio used to measure the growth opportunities of rm i at time t. LEE]. stands for leverage of rm i at time t= measured by dividing total liabilities with total assets. CAPEX; is the ratio of rm's total capital expenditure to rm's total assets. DUE]. is the net operating cash ows ofrmi attime t. skis the random error term. 3. Make two quartiles on the basis of SIZE 4. Calculate detailed summary statistics and across the two size quartiles created in step 3 5. Re-Estimate the equation using OLS, FIXED EFFECTS and random effects across the two quartiles 6. Interpret the results in this separate word file and focus your discussion between the IVs and DV across the two quartiles (compare the results for bigger size and lower size firms) 7. Submit the STATA result file (SMCL file) and the word file in a compressed file as question3