The Problem: You are tasked with analyzing whether Blacks, and Hispanics have increased the number of assets held from 2004 to 2016.

The Problem: 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 for 2004 and 2016 along with the Unemployment rate by race for the years of 2004 and 2016. (This data can be found on the following website – 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 to 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

1. Define Growth rate? How do you calculate the Growth rate?

2. Define Unemployment Rate? How do you calculate the Unemployment Rate?

3. What is the formula for finding the percentage change?

4. Research – What are Certificate Deposits? What are Retirement Accounts?

Part 2

1. Download the student version of Tableau https://www.tableau.com/academic/students

2. Watch the Getting Started Tableau Video at https://www.tableau.com/learn/training

3. 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

4. Compare families holding Certificate Deposit accounts from 2004 to 2016 by race

5. Next Compare and contrast families with retirement accounts by race and then by education for 2004 and 2016 show through Tableau visualization and a brief narrative the answers to the following questions

a. Did retirement accounts, stock increase, Certificate Deposits increase or decrease for certain groups by race from 2004 to 16 ? (you must first calculate the percentage change in in assets from 2004 to 2016 in excel then import your table to Tableau) Display visually and write a brief narrative of the results and what do you think is occurring?

b. Display visually the breakdown of financial assets (iesaving accounts, retirement accounts, stock increase, Certificate Deposits) held by Blacks, Hispanics and Whites in 2004 and 2016 along

c. Display visually the 2004 to 2016 percentage change of the same financial assets held by Blacks, Hispanics and Whites

d. Write a brief narrative comparing your results

e. Besides the Macroeconomic factors, can you think of other factors that may have played a role into why Certificate Deposits and Retirement Accounts vary by race?

6. 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…

7. 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 program