The database German Credit.xlsx** contains data on prior applicants for credit, including whether they proved to have good or bad credit.

a. How many records are in this database?
b. How many fi elds are in this database?
c. Is the field HISTORY nominal or ordinal?
d. Is the field PRESENT_RESIDENT nominal or ordinal?
e. How m any records are male, divorced, and unskilled resident?
f. Which record number has the highest credit amount?
g. What percentage of records has less than 100DM in a savings account?
h. How does the credit amount compare for those who own their residence versus those who do not?
i. How are the amount of credit and the duration of the loan related?