Question: The image below is an outline for what the code should look like Assignment Background One commonly hears reference to the one percent referring to

 The image below is an outline for what the code should

look like Assignment Background One commonly hears reference to "the one percent"

referring to the people whose income is in the top 1% of

incomes. What is the data behind that number and where do others

The image below is an outline for what the code should look like

fall? Using the National Average Wage Index (AWI), an index used by

Assignment Background One commonly hears reference to "the one percent" referring to the people whose income is in the top 1% of incomes. What is the data behind that number and where do others fall? Using the National Average Wage Index (AWI), an index used by the Social Security Administration to gauge a individual's earnings for the purpose of calculating their retirement benefit, we can answer such questions In this project, you will process AWI data. Example data for 2014 and 2015 is provided in the files year 2014. txt and year 2015. txt (2015 is the most recent year of complete data-the 2016 data isn't available until October). The data is a table with the first row as the title and the second row defining the data fields, remaining rows are data. Note that the 2014 data is nicely formatted in columns, but the 2015 data is not. The URL for the data is: https://www.ssa.gov/cgi- binetcom p.cgi ear-2015 Here is the second line of data from the file followed by descriptions of the data. Notice that some data are ints and some are floats: 5,000.00 9,999.99 13,848,841 36,423, 261 23.02549 102, 586,913, 092. 61 7, 4 07. Column 0 is bottom of this income range. Column l is the hyphen separating the bottom of the range from the top. Column 2 is the top of this income range. Column 3 is the number of individuals in the income range Column 4 is the cumulative number of individuals in this income range and all lower ranges. Column 5 is the Column 4 value represented as a cumulative percentage of all individuals Column 6 is the combined income of all the individuals in this range of income. Column 7 is the average income of individuals in this range of income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!