Possible outputs 1. How many borrowers (BorrName) are in each state (BorrState)?

Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Possible outputs 1. How many borrowers (BorrName) are in each state (BorrState)? Table(s) needed: Borrower table. Output: Borr state and a count of the borr names in that borr state. 2. How much was borrowed (Gross Approval)in each state(BorrState)?Table(s) needed: Borrower table. Output: Borr state and sum of gross approvals by borr state 3. How much was borrowed (Gross Approval) per capita (Population in 2015) in each state (Borr State)? Table(s) needed: Borrower table and state table Output: Sum of gross approvals by borrow state partioned by population in 2015 4. What is the Average, Minimum, and Maximum of borrowings (Gross Approval) in each state(BorrState)? Table(s) needed: Borrower table. Output: Avg of gross approval, min of gross approval, max of gross approval by state 5. How many borrowers (BorrName) in each State (BorrState) borrowed more than the average (Gross Approval) in that state? Table(s) needed: Borrower table. Output: 1) determine what is Avg gross approval by state and 2) count borrowers with gross approval that is > than avg 6. List the top 5 borrowers (BorrName) by borrowed amount (Gross Approval) in each of the 6 states with the largest populations (Population in 2015). Table(s) needed: Borrower table and state table Output: 1) determine 6 states with largest population (state table.population in 2015), 2) count top 5 gross approval by state 7. List the total amount borrowed in each year (Gross Approval) based on loans above the average (Gross Approval) in each state in the 5 states with the largest populations (Population in 2015). Table(s) needed: Borrower table and state table Output: 1) determine 5 states with largest population (state table population in 2015), 2) what is average gross approval in these states, 3) count the loans above the avg, 4) total the loans above the avg Import your tables into Tableau (or R or Python) and produce visualizations to answer the following questions: 8 – 10. Create visualizations in Tableau for the first three (3) queries above. Use the best visualizations you can find.

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services