Hi I need help with this problem if possible explain how to get the solution step by step on Excel as well in reference to the $55,231 is the total of column 16 and next to it are its percentages,

G B D E F G H I 1 Q5 (1 bonus point): Create a Pareto chart for Expenditures in 2016 Your chart should contain the same content and format as the sample picture shown on the right L M N O NOTICE: This is only a sample picture, you need to create a chart to get poir 2016 Household Expenditure 34% 16% 100% 14% Expenditure $20,000 $16,000 $12,000 $8,000 $4,000 $ hr Household Expenditures 5 2011 2012 2013 2014 2015 2016 % 5 Housing $16,803 $16,887 $17,148 $17,798 $18,409 $18,886 - Transportation $ 8,293 $ 8,998 $ 9,004 $ 9,073 $ 9,503 $ 9,049 Food and $ 6,914 $ 7,050 $ 7,047 $ 7,222 $ 7,538 $ 7,687 B beverages Personal insurance and $ 5,424 $ 5,591 $ 5,528 $ 5,726 $ 6,349 $ 6,831 pensions 0 Healthcare $ 3,313 $ 3,556 $ 3,631 $ 4,290 $ 4,342 $ 4,612 1 Entertainment $ 2,572 $ 2,605 $ 2,482 $ 2,728 $ 2,842 $ 2,913 2 Others $ 1,875 $ 1,898 $ 1,685 $ 1,849 $ 2,017 $ 2,121 Apparel and 3 services $ 1,740 $ 1,736 $ 1,604 $ 1,786 $ 1,846 $ 1,803 4 Education $ 1,051 $ 1,207 $ 1,138 $ 1,236 $ 1,315 $ 1,329 5 6 $55,231 7 80% 60% 40% 20% 0% Cumulative % 12% 8% 5% 4% Housing Transportation Food and... Personal... Healthcare Others Entertainment Apparel and... Education 1 Expenditure Percentage 3% 2% 100%