The following is an extract from a credit risk spreadsheet. A B E F J K...

 

Transcribed Image Text:

The following is an extract from a credit risk spreadsheet. A B E F J K L. 1 Credit Risk Data Loan Purpose Checking Savings Months Customer Small Appliance Months Employed Gender Marital Status Age Housing Years Job Credit Risk 12 23 Unskilled $0 SO $0 $638 $963 $2,827 $739 $1,230 $389 $347 $4,754 $0 $229 $533 $493 $0 $989 so $3,305 13 Single Own Low Furniture 25 Divorced 32 Own Skilled Single 38 Single 36 31 High High High Low New Car 19 119 Own 4 Management 13 M M Furniture 14 Own Unskilled Education 40 45 Single Married Rent 3 Skilled Furniture 11 13 M 25 Own 1 Skilled Low 10 New Car 13 16 M Married 26 Own 3 Unskilled Low $0 $6,509 $966 11 Business 14 M Single Single 25 Divorced 27 Own 1 Unskilled Low Small Appliance Small Appliance Business 37 9 Own 2 Skilled High High High Low 25 4 43 Own 1 Skilled Single 32 Single 34 14 49 Rent 2 Management 2 15 New Car 11 15 Rent Unskilled The bank manager wants to know the standard deviation of age by category of loan purpose. The bank manager would: Insert =STDEV.S(H4:H15) somewhere in the spreadsheet Create a PivotTable for data using "Loan Purpose" for the row labels, drag "Age" into the "Z Values" section. Then click the pull-down for "Sum of Age" and change the operation to Standard Deviation. Sort the data by loan purpose and using the VLOOKUP function to search for age Create a Pivot Table for data using "Loan Purpose" for the row labels, drag "Age" into the "Standard Deviation Values" section. EMM 123 t567 89e 23 45 1ULL The following is an extract from a credit risk spreadsheet. A B E F J K L. 1 Credit Risk Data Loan Purpose Checking Savings Months Customer Small Appliance Months Employed Gender Marital Status Age Housing Years Job Credit Risk 12 23 Unskilled $0 SO $0 $638 $963 $2,827 $739 $1,230 $389 $347 $4,754 $0 $229 $533 $493 $0 $989 so $3,305 13 Single Own Low Furniture 25 Divorced 32 Own Skilled Single 38 Single 36 31 High High High Low New Car 19 119 Own 4 Management 13 M M Furniture 14 Own Unskilled Education 40 45 Single Married Rent 3 Skilled Furniture 11 13 M 25 Own 1 Skilled Low 10 New Car 13 16 M Married 26 Own 3 Unskilled Low $0 $6,509 $966 11 Business 14 M Single Single 25 Divorced 27 Own 1 Unskilled Low Small Appliance Small Appliance Business 37 9 Own 2 Skilled High High High Low 25 4 43 Own 1 Skilled Single 32 Single 34 14 49 Rent 2 Management 2 15 New Car 11 15 Rent Unskilled The bank manager wants to know the standard deviation of age by category of loan purpose. The bank manager would: Insert =STDEV.S(H4:H15) somewhere in the spreadsheet Create a PivotTable for data using "Loan Purpose" for the row labels, drag "Age" into the "Z Values" section. Then click the pull-down for "Sum of Age" and change the operation to Standard Deviation. Sort the data by loan purpose and using the VLOOKUP function to search for age Create a Pivot Table for data using "Loan Purpose" for the row labels, drag "Age" into the "Standard Deviation Values" section. EMM 123 t567 89e 23 45 1ULL

Answer rating: 100% (QA)

Option b is the correct answer Because A pivot table or turn table is a table ... View the full answer