Lancaster Savings bank that is interested in the mortgage default risk for its home mortgage customers. Specifically,
Question:
Lancaster Savings bank that is interested in the mortgage default risk for its home mortgage customers. Specifically, the company want to check whether the probability of a customer defaulting differs by marital status. Use the data from 300 home mortgages of customers at Lancaster savings and loan provided in excel to: 1) Draw a Pivottable to calculate the following Marginal probabilities: P(M), P(S), P(DC), and P(D) . 2) What is the Probability that a randomly selected customer is single and the customer defaults on his or her mortgage P(SD)? 3) What is the probability that the customer NOT defaults on the mortgage given that the customer is married: P(DC|M)? Please list your answer in a *.DOC or *.DOCX or *.PDF or Excel file. Assume: = event that a customer is single = event that a customer is married = event that a customer defaulted on his or her mortgage = event that a customer did not default on his or her mortgage