https://drive.google.com/file/d/1dUxaTr5f06I49TguetMjpss60g1lS58z/view?usp=sharing

It is the data is from the link,

answer the following question, using excel.

File germean_credit_data.xlsx (source: Kaggle.com) contains data on default of some customers. Risk = Good means no default, and Risk = Bad means default. Use this data to answer the following questions:

1.What is odds of default for this data? What does that mean in Layman's terms?

2.What is probability of default conditional on being a home owner?

3.

Being male, changes odds of default by ?

4.sentence.

1 unit increase in duration, changes credit amount by ?

5.What is unconditional expected credit amount for this sample?