Question

Some students of LCWU were so attached with their institute that they decided to donate some of their earnings to their university. Their plan was to offer the education to 5 students per year. University told these pioneer students that per student cost would be 30000. So these pioneer students decided to pay the required amount to the university and interest rate discussed between university and bank was 12%. How this scenario guides you about your calculation

Answer 1

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

Log Obs 1 1 2 3 4 5 6 8 1 Logit=bo+b1* independent variable 1 + b2* independent Prob=exp (logit)/{1 likelihoo Financial Condition Total Exp/ Assets Total Ins & Lses/ Assets variable 2 Exp(logit) + exp(logit)} d 0.12 0.65 1.500425831 4.483598 0.817637979 -0.20134 1 0.11 0.62 0.350931034 1.420389 0.586843334 -0.533 1 0.09 1.02 1.902863938 6.70507 0.870215324 -0.13901 1 0.1 0.67 -0.128838112 0.879116 0.467834953 -0.75964 1 0.11 0.69 0.936940979 2.552162 0.718481335 -0.33062 1 0.13 0.74 3.152214867) 23.38781 0.958995905 -0.04187 1 0.1 0.79 0.875750366 2.400676 0.705940819 -0.34822 0.13 0.63 2.231342096) 9.312356 0.9030289471 -0.102 1 0.16 0.72 5.679826487 292.8986 0.9965974661 -0.00341 0.16 0.57 4.42409089 83.43692 0.988156839 -0.01191 0 0.08 0.43 -3.934710423 0.019551 0.019176435 -0.01936 0 0.12 0.8 2.756161428 15.73931 0.940260382 -2.81776 0 0.07 0.69 -2.656449732) 0.070197 0.065592595 -0.06784 0 0.08 0.53 -3.097553358 0.045161 0.043208289 -0.04417 0 0.09 0.73 -0.52489155 0.59162 0.371709139 -0.46475 0 0.09 0.3 -4.124666929 0.016169 0.015911606 -0.01604 0 0.08 0.49 -3.432416184 0.032309 0.031297595 -0.0318 0 0.11 0.55 -0.235078912 0.790508 0.44149943 -0.5825 0 0.08 0.44 -3.8509947161 0.021259 0.020816061 -0.02104 0 0.08 0.51 -3.264984771 0.038198 0.036792148 -0.03749 -6.57376 9 10 1 11 12 13 14 15 16 17 18 19 20

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605