Question: Python 3. Please use exact layout and wording as shown in the tests at the bottom. Assignment Background percent referring to the people whose income
Assignment Background percent" referring to the people whose income is in the One commonly hears reference to "the one top 1% of incomes. What is the data behind that number and where do others fall? Using the National Average Wage Index (A WI), 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 year2014. txt and year2015 .txt (2015 ?s 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: htts:/www.ssa sovicgi 201 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: ,000.00-9,999.99 13,848,841 36,423,281 23.02549 102,586,913,092 61 7,407.62 Column 0 is bottom of this income range Column 1 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
Get step-by-step solutions from verified subject matter experts
