A lending institution supplied the following data on loan approvals by four loan officers. Use a =0.5 and test to determine whether the loan approval decision is independent of the loan officer reviewing the loan application. Loan officer Approved Rejected Miller 24 16 McMahon 17 13 Games 35 15 Runk 11 9

I need to know how to solve this on excel. So could you give me the exact steps on how to answer the different questions this question involves just from using excel?