import excel "C:\Users\Gideon\Desktop\CMU ECONOMICS\ECONOMETRIC APPLICATIONS\TERM PAPER\TERM_CMU ECONOMETRICS\ANALYSIS\Data_3.xlsx", sheet("Sheet1") firstrow
tsset Bank Year
summarize ReturnOnEquity ReturnOnAssets CurrentRatio QuickRatio FinancialLeverage
regress ReturnOnEquity ReturnOnAssets CurrentRatio QuickRatio FinancialLeverage
regress lnROE lnROA lnCurrentRatio lnQucikRatio lnFL
gen CAL=(Bank==1)
gen EGH=(Bank==2)
gen GCB=(Bank==3)
gen SCB=(Bank==4)
reg ReturnOnEquity CAL EGH GCB SCB ReturnOnAssets CurrentRatio QuickRatio FinancialLeverage
regress lnROE CAL EGH GCB SCB lnROA lnCurrentRatio lnQucikRatio lnFL
xtreg lnROE lnROA lnCurrentRatio lnQucikRatio lnFL, fe
xtreg lnROE lnROA lnCurrentRatio lnQucikRatio lnFL, re