A bank requires eight pieces of information from loan applicants: income, education level, age, length of time at current residence, length of time with current employer, savings, debt, and number of credit cards. A bank administrator wants to analyze this data to determine the best way to group and report it. The administrator collects this information for 30 loan applicants.
Because this data contains multiple related measurement variables, you can use it to demonstrate Principal Components Analysis, Correlation, and graphs such as Bubble Plot.
Worksheet column | Description |
---|---|
Income | The income of the applicant, in US dollars |
Education | The education level of the applicant, in years |
Age | The age of the applicant |
Residence | The length of time that the applicant has lived at the current residence, in years |
Employ | The length of time that the applicant has worked for the current employer, in years |
Savings | The amount of savings that the applicant has, in US dollars |
Debt | The amount of debt that the applicant has, in US dollars |
Credit cards | The number of credit cards that the applicant has |