Construct a graph that displays the number of loans made

Reference no: EM132166464

Question One.

a. Create a single table that displays the mean interest rate charged for each combination of loan grade and loan status. Briefly describe any patterns that you observe from the table.

b. Create a table (or expand your table from part a.) so that the number of loans for each combination of loan grade and loan status is also displayed. Briefly describe any pattern(s) that you observe.

c. Construct an appropriate graph for displaying the percentage of loans that are "Charged Off" by loan grade.

Question Two.

a. Construct a graph that displays the number of loans made for each month from June 2007 through December 2011. What, if any, trend do you observe?

b. Modify your graph from part a. to determine if the trend over time is consistent across loan grade (i.e., do you see the same pattern for each grade). What do you find?

Question Three.

Consider the variable rev_util (revolving credit utilization). We would like to learn if this variable may be a good predictor of loan outcome. Construct a table or graph (choice is yours) that helps answer this question. What do you conclude?

Question Four.

Is income related to loan grade? First, filter the data so that only observations having incomes less than $250,000 appear. Use the filtered data to create a pivot table with income as the row variable and loan grade as the column variable. Group income from $0<$50,000;$50,000<$100,000;$100,000<$150,000; $150,000<$200,000;$200,000<$250,000. Use your pivot table to answer the following questions:

a. What is P(Grade A, B, or C |$0<$50,000)
b. What is P(A,B, or C|$100,000<$150,000)?
c. Do these values appear to be significantly different? What does this say about the relationship between income and loan grade

int_rate	interest rate
grade	loan grade
loan_status	loan status
issue_d	loan issue date--month and year
revol_util	revolving credit utilization
loan_status	loan status (outcome fully paid or charged off)
annual_inc	annual income
dti	debt to income ratio

Attachment:- homework.rar

Reference no: EM132166464

Questions Cloud

What are disney biggest strategic challenges : What are Disney’s biggest strategic challenges? What recommendations would you give to Robert Iger to address these challenges?

Analyze the cost and benefit data you developed : For this assignment, evaluate and analyze the cost and benefit data you developed for the discussions in this unit and Unit 5. Remember that your cost-benefit.

How many bits are needed for the opcode : i. How many bits are needed for the opcode ii. How many bits are left for the address part of the instruction

Emphasizing need for equal participation : Explain that you need their help (emphasizing the need for equal participation) Praise them for being in the group (providing motivation)

Construct a graph that displays the number of loans made : Construct a graph that displays the number of loans made for each month from June 2007 through December 2011. What, if any, trend do you observe

Direct impact on the quality of services : Can these complications also have a direct impact on the quality of services provided by flight instructors to their students?

What is franchising : What is franchising? What steps should a potential franchisee take before investing in a franchise?

What are the primary predictions of the model : Define leadership ans situation factors included in Fiedlers Contingency Model. What are the primary predictions of the model?

Exit strategies business owners can use for their businesses : Is keeping the work enviorment clean and tidy important? Why? Explain five exit strategies business owners can use for their businesses.

User Account

All Pages