Help me solve this using excel miner:

$1)$ Financial Condition of Banks. The file Banks.xls includes data on a sample of $20$ banks. The

$$Financial Condition$$ column records the judgment of an expert on the financial condition of

each bank. This dependent variable takes one of two possibilities $$ Weak or Strong $$ according

to the financial condition of the bank. The predictors are two ratios used in the financial

analyses of banks: TotLns&Lses$/$Assets is the ratio of total loans and leases to total assets and

TotExp$/$Assets is the ratio of total expenses to total assets.

Run a logistic regression $($on the entire dataset$)$ that models the status of the bank as a function

of the two financial ratios mentioned above. Specify the success class as a week $($this is similar to

creating a dummy that is one for financial week banks and $0$ otherwise$)$ and use the default

cutoff value of $0\mathrm{.}5.$

a$)$ Write the estimated equation that associates the financial conditions of a bank with its

two predictors in three formats:

i$.$

ii$.$

iii.

The logit as a function of the predictors

The adds as a function of the predictors

The probability as a function of the predictors

b$)$ Consider a new bank whose total loans and leases$/$assets ratio $=0\mathrm{.}6$ and total

expenses$/$assets ratio $=0\mathrm{.}11.$ From your logistic regression model, estimate the

following four quantities for this bank $($use Excel to do all the intermediate calculations;

show your final answer to $4$ decimal places$)$: the logit$,$ the odds, the probability of being

financial weak, and the classification of the bank $($use cutoff $=0\mathrm{.}5)$

c$)$ Classify the above record using XLMiner.

Obs Financial Condition TotCap$/$Assets TotExp$/$Assets TotLns&Lses$/$Assets

$119\mathrm{.}70\mathrm{.}120\mathrm{.}65$

$2110\mathrm{.}110\mathrm{.}62$

$316\mathrm{.}90\mathrm{.}091\mathrm{.}02$

$415\mathrm{.}80\mathrm{.}10\mathrm{.}67$

$514\mathrm{.}30\mathrm{.}110\mathrm{.}69$

$619\mathrm{.}10\mathrm{.}130\mathrm{.}74$

$7111\mathrm{.}90\mathrm{.}10\mathrm{.}79$

$818\mathrm{.}10\mathrm{.}130\mathrm{.}63$

$919\mathrm{.}30\mathrm{.}160\mathrm{.}72$

$1011\mathrm{.}10\mathrm{.}160\mathrm{.}57$

$11011\mathrm{.}10\mathrm{.}080\mathrm{.}43$

$12020\mathrm{.}50\mathrm{.}120\mathrm{.}8$

$1309\mathrm{.}80\mathrm{.}070\mathrm{.}69$

$1407\mathrm{.}90\mathrm{.}080\mathrm{.}53$

$1509\mathrm{.}60\mathrm{.}090\mathrm{.}73$

$16012\mathrm{.}50\mathrm{.}090\mathrm{.}3$

$17018\mathrm{.}30\mathrm{.}080\mathrm{.}49$

$1807\mathrm{.}20\mathrm{.}110\mathrm{.}55$

$190140\mathrm{.}080\mathrm{.}44$

$2008\mathrm{.}30\mathrm{.}080\mathrm{.}51$