Q6 Find the total amount for of the current balance for each underwriter and find out...

Transcribed Image Text:

Q6 Find the total amount for of the current balance for each underwriter and find out top 10 richest underwriter Q7 Create a pivot table for the entire data and find out the total current balance for each lender and draw two charts 1) Draw a bar chart for the total current balance for each lender Q8 Q9 Q10 2) draw an histogram by creating bins/classes by using the max and min value Create a small data by keeping only the columns A,I,N,O,R,X,Y, and generate many interpretations as much as possible Create 7 charts of any type from the data provided to you or create 10 different charts on 10 different datasets created by you and add your interpretations for each chart Find out if there is any correlation (Positive or Negative) between any columns in the dataset. if so what type of correlation is present how many correlation relationship between the variables are found name the variables that are have correlation between then Q6 Find the total amount for of the current balance for each underwriter and find out top 10 richest underwriter Q7 Create a pivot table for the entire data and find out the total current balance for each lender and draw two charts 1) Draw a bar chart for the total current balance for each lender Q8 Q9 Q10 2) draw an histogram by creating bins/classes by using the max and min value Create a small data by keeping only the columns A,I,N,O,R,X,Y, and generate many interpretations as much as possible Create 7 charts of any type from the data provided to you or create 10 different charts on 10 different datasets created by you and add your interpretations for each chart Find out if there is any correlation (Positive or Negative) between any columns in the dataset. if so what type of correlation is present how many correlation relationship between the variables are found name the variables that are have correlation between then