Description
Problem Statement
You are tasked with analyzing whether Blacks and Hispanics have increased the number of assets held from 2004 to 2016.
Part 1
- - Before analyzing the data please briefly explain the Real Gross Domestic Product growth rates from 2004 to 2016 along with the Unemployment rate by race from 2004 to 2016. This data can be found on https://fred.stlouisfed.org (please note that you will have to edit the Real GDP graph and change your measurement from Billions of dollars to percentage change).
- - Next identify on a graph and explain in writing the economic recessions that occurred between 2004 and 2016. Be sure to explain why the recession occurred and how the economy was impacted. The FRED graphs are expected to be incorporated in your report.Preliminary Questions to answer before writing narrative
- Define Growth rate? How do you calculate the Growth rate?
- Define Unemployment Rate? How do you calculate the Unemployment Rate?
- What is the formula for finding the percentage change?
- Research - What are Certificate Deposits? What are Retirement Accounts?
Part 2
- Define Growth rate? How do you calculate the Growth rate? Download the student version of Tableau https://www.tableau.com/academic/students
- Watch the Getting Started Tableau Video at https://www.tableau.com/learn/training
- Input the Survey of Consumer Finance Excel file Data into Tableau (See attachment labeled: scf 04 and 16 race data.xlsx. This file contains the percent of families holding various financial assets by race in 2004 and 2016).
- Compare families holding Certificate Deposit accounts in 2004 and 2016 by race.
- Next Compare and contrast families with retirement accounts and stocks by race in 2004 and 2016. Display results using Tableau visualization and a brief narrative to the answer to the following questions.
a. Display visually the breakdown of financial assets held by Blacks in 2004 and 2016.
- Display visually the breakdown of financial assets held by Whites in 2004 and 2016.
- Write a brief narrative comparing your results.
- Did retirement accounts, stocks, Certificate Deposits increase or decrease from 2014 to 2016? Display visually and write a brief narrative of the results.
- Besides the Macroeconomic factors, can you think of other factors that may have played a role into why Certificate Deposits, Stocks and Retirement Accounts vary by race?
- After analyzing the data, what other questions remain with you that could warrant further exploration of the data or gathering additional variables from the Survey of Consumer Finance Database? To answer this question, it would be helpful to visit the Survey of Consumer Finance’s Website at https://www.federalreserve.gov/econres/scfindex.ht...
- All visualizations should be presented using Tableau visualizations, be sure to allocate enough time to download the program and learn the basics of the Tableau before completing the assignment.
8. Your final written report, It must be written using the APA style (https://apastyle.apa.org/index) must be at most 4 pages excluding title page, appendix (tables and graphs) and references.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Money, Banking, and the Financial System
Students Name
Outline
Part 1: Simple GDP growth rate analysis
I.
II.
III.
IV.
V.
VI.
VII.
Real gross domestic product growth rate
a. Real Gross Domestic Product (GDP) growth rates have been fluctuating from
2004 to 2016.
Unemployment rate
a. unemployment rate for black
b. Unemployment rate for the whites
Economic recession
a. Economic recession occurred in 2008 when the real GDP growth rate was -8.4%.
Growth rate
Unemployment rate
Percentage change
Research
a. Certificate of deposit
b. Retirement accounts
Part II: Data Visualization
a. Growth rate
b. Families holding certificate of deposits
c. Families with retirement accounts and stock
I.
Financial assets
a. Financial assets held by the black
b. Financial assets held by the whites
II.
Accounts
a. Retirement accounts
b. Stocks
c. Certificate of deposits.
References
Running Head: MONEY, BANKING AND FINANCIAL SYSTEM
MONEY, BANKING, AND FINANCIAL SYSTEM
Student’s Name
Institution affiliation
Date
1
2
MONEY, BANKING, AND FINANCIAL SYSTEM
Part 1: Simple GDP growth rate analysis
The real GDP growth rate
Real Gross Domestic Product (GDP) growth rates have been fluctuating from 2004 to
2016. The growth rate was 2.2% at the start of 2014, and it went up to 4.5% in 2005. The rate
fluctuated at a decreasing rate from 2005 until late 2008 and 2009, where the growth rate was
negative. It was the most enormous economic downtime between 2004 and 2016. In early 2014
the growth rate went down...