Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

UB 1

Please thoroughly read instructions provided 

Assignment 1 – Analysis and Report of the Unbanked and Underbanked in the US

Introduction

The Federal Deposit Insurance Corporation (FDIC) conducts frequent surveys to understand the unbanked and underbanked situation in the U.S. In this assignment, we will use the 2023 FDIC National Survey of Unbanked and Underbanked Households. It is the most recent survey conducted by the FDIC focusing on the unbanked and underbanked situation in the U.S.

The data has been cleaned and prepared in Excel format for our analysis. Each row in the spreadsheet contains information collected from one household. There are a total of 29,483 households included in the dataset. It is important to note that not all households carry the same weight in our analysis. Due to the sampling design, each household has a weight, and the weight (as opposed to count) will be used to calculate the proportions and statistics.

To keep the scope of the assignment manageable, not all data from the FDIC survey have been included. The original data, dictionary, and survey questions can be found on the FDIC official website. Survey data from earlier years are also available.

Assignment Questions

What is the proportion of unbanked and underbanked households in the U.S.? (6 points)

How do the unbanked and underbanked situations compare across different states? To answer this question, please create two separate visualizations for: (20 points)
a. The proportion of the unbanked population in different states
b. The proportion of the underbanked population in different states

What proportion of the unbanked individuals were previously banked? (6 points)

What are the main reasons people become or choose to be unbanked? (6 points)

How does the unbanked and underbanked proportion differ for different: (6 points each, total 42 points)
a. Household type
b. Employment status
c. Education
d. Citizenship and place of birth
e. Disability status
f. Income
g. Race/Ethnicity

How do the unbanked, underbanked, and banked differ in their use of the following alternative financial services (AFS)? (6 points each, total 48 points)
a. Nonbank check cashing
b. Nonbank money order
c. Payday loan
d. Pawnshop loan
e. Refund anticipation loan
f. Rent-to-own service
g. Auto title loan
h. Prepaid card

7. How do the unbanked, underbanked, and banked differ in their home ownership? (6 points)

8. In question 6 above, we looked at how each AFS is used. In this question, let’s explore what proportion of unbanked, banked, and underbanked households used at least one of the AFS services. (10 points)

9. What are the takeaway messages from your analyses above? Please describe the current landscape of unbanked and underbanked. (6 points)

Deliverables

There are two deliverables for this assignment:

1. The completed Microsoft Excel spreadsheet (based on the template with finished calculations)
– For each question and sub-question except for questions 2 and 9, please include a pivot table.
– For question 5, you will need one pivot table for each category (e.g., household type, employment status, etc.).
– For question 2, creating one pivot table is sufficient, but you must include two separate visualizations for unbanked and underbanked proportions across different states.
– Question 9 asks for your takeaway messages and does not need to be reflected in your spreadsheet.

2. A professionally organized 3–6 page report that answers the questions above.
– Organize your report as responses to each of the questions.
– Focus on findings and insights; do not include technical details or calculation steps.
– For questions 1–8, include:
• The calculation results (percentages, tables, or visualizations).
• Your interpretation of the results (e.g., whether it is high/low, implications for households, organizations, and governments).
– For question 9, you’ll be graded on the quality of your summary.

Please adhere to the page limit and refrain from including unnecessary details. For example, referencing the percentage value is sufficient — there’s no need to paste entire pivot tables since your Excel file will include them.

File Naming:
• Excel: [FirstName] [LastName] Assignment 1 Analysis.xlsx
• Report (PDF): [FirstName] [LastName] Assignment 1 Report.pdf

Please note that you are required to use Microsoft Excel to complete this assignment. Google Sheets, Apple Numbers, or other spreadsheet applications are not acceptable.

Download the Template

Download the Excel Template: “Assignment 1 FDIC2023 Clean Unbanked Underbanked Banked Template.xlsx” as the basis for your assignment.

Each row in the sheet represents one household. The columns describe household information, including unbanked status, state, family income, etc.

Some columns have empty cells. Empty cells represent missing or non-applicable values (e.g., the “main reason unbanked” field for fully banked participants). Consider and exclude these when appropriate during your analysis.

Instruction and Demonstration Video

Please visit the course website for the Assignment 1 demonstration video. The analysis will primarily use Pivot Tables.

IMPORTANT: Dummy data is used in the demonstration video. Your actual analysis will produce different numbers.

The data provided to you is the real, official FDIC dataset — your conclusions will reflect the most up-to-date understanding of the unbanked and underbanked landscape in the U.S.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Social Science – Sociology Assignment 5

Please see attachment.  Assessment at the adult stage does not contain the challenges of the child and adolescent stages, in which the practitioner may experience communication difficulties with the client or must rely on parents and caregivers for context. This does not mean assessment is easy, however. Social work assessment

Social Science – Sociology Assignment 2

Please see attached file  Social change occurs because a person or group gains the attention and support of decisions makers. Decision makers, often in the form of legislators or political representatives, have access to putting issues and policies on the agenda for the business by the assembly. Being placed on

Social Science – Sociology Assignment 1

Please see attached file Assessment at the adult stage does not contain the challenges of the child and adolescent stages, in which the practitioner may experience communication difficulties with the client or must rely on parents and caregivers for context. This does not mean assessment is easy, however. Social work

Prof Double R

 The Institute for the Future predicted that new vaccines would be developed to treat noninfectious diseases, such as cancer. This prediction can be found in the Programming Immunity: Defense to Offense article. How would you decide whether to be one of the first individuals to try a “new” vaccine? 

Prof Double R

 The concept of value (improved benefits at lower costs) is important to those who finance healthcare, including private employers, the government, and managed care organizations. Value can be increased by improving quality, reducing cost, or both. Should the government be in a central position to issue physician practice guidelines based

Social Science – Sociology Assignment 2

Please see attached file  A primary competency for advocacy is communicating with legislators about the social problems and policies you want to change. This means you will need to be well versed in both the social problems that connect with you and the polices that exist to address them. In

Social Science – Sociology Assignment 1

Please see attached file  Deciding on which assessment tools to use, and when, can feel like a confusing process. For example, should you screen all adolescent clients for substance use regardless of presenting problem? Should you ask about suicide in every session or only when it feels like it could

i need help com 200 wk 9

  In this assignment, you will create and deliver a persuasive speech, about a collaborative tool that can improve remote work communication and teamwork. You will use your speech to present the benefits, features, and advantages of the tool, with the goal of convincing the leadership team to invest in

lorem ipsum

  Week 11 Discussion – Course Takeaway Please respond to the following: Reflect upon three aspects of the course that resonated with you. Describe the manner in which you have grown personally and professionally as a result of completing this course.  HSA510 – Health Economics   This course introduces economic concepts

Week 7

See attached Overview The final project for this course is the creation of a tourism proposal to increase tourism in a selected country. Students will act as consultants working with the Department of Tourism and Heritage Management and will be responsible for explaining the approach they have selected from an

Final Project

See Attached Overview Anthropologists will often conduct research to objectively evaluate cultural practices. Cultural anthropology is the branch of anthropology that deals specifically with human culture. Studying cultural anthropology provides a great amount of insight into other cultures. It can also shed light on and create a deeper understanding and

Social Science – Sociology Assignment 2

Please see attached file For your Social Change Project, due as your Final Assignment in Week 10, you will propose policy alternatives that address the social problem you selected for study in Week 2. Before you search for, select, and review policies that already exist for your social problem—and before you propose

Social Science – Sociology Assignment 1

Please see attachment.  As a social worker, you must be familiar with a range of evidence-based assessment tools to use in practice with many different populations. Some are quite broad, used for screening and initial assessment, while others are more specialized and related to distinct symptoms. Your Assignments in Weeks

Social Science Assignment 6

See attached Overview American civic folklore includes the stories Americans tell to make sense of who they are as a nation—stories that shape shared values, ideals, and sense of belonging. These narratives are not limited to figures like George Washington chopping down the cherry tree or Paul Bunyan and Babe

lorem ipsum

  Week 10 Discussion – Evolving Issues in Health Care Please respond to the following: Use the Internet and Strayer online databases to research the U.S. health care delivery system and the health care system of two other countries in regard to spending per capita and ranking of health care

Worksheet

See Attached ATH 315 Worksheet Analysis: Population Growth and the Problems It Causes Directions Review the Module Six reading and resources and respond to the three questions below. While reviewing the resources, consider the impact of population expansion on the Earth, the environment, and the natural resources available to humans.

Conflict Resolution

   For this assessment, tell a visual and written story, with an audio recording of your voice, that explains how social media can impact conflict involving a public figure. To do this, create a 10–12 slide PowerPoint presentation in which you use text and visuals to support your audio narration

Social Science – Sociology Assignment 1

Please see attached file  Imagine a scenario in which a good friend is going through a tough time. Perhaps they discuss a mental health issue, substance use, or a death in the family. You might, as a friend, respond empathetically by mentioning a similar experience you had and what you