03 4 Points In the file FatalWorklnjurie52019.xlsx, select tab titled, Fatal Injuries by Event. There are a few ways to represent this data. One way is to make a pie chart of Fatal Occupational Injuries by Event or Exposure in 2019. 03.1 2 Points Create a pie chart of the 2019 data (columns A and H). To include the percentage data labels choose layout 6. (Note: if you are preparing a document to be printed on a black and white printer, it is recommended that you also change the colors of your graph to a high contrast gray scale color scheme). File Home Insert Page Layout Formulas Data Review View Developer Help Acrobat Chart Design = [Ll-It E . C , g: . '9 .' @ E [ill EH] Add Chart Quick Change ' y. . I; ' _. ' ; Switch Row/ Select Change Move Element V Layout V Colors v Column Data Chart Type Chart Chart l.' E. (9 Chan Styles Data Type location A B k C . D E F G l H I I 1 Fatal I :or Exposure, 2010, 2013. 2014, 2015. 2016, 2018 '2019 27 3 _ Event .: 2010 2013 2014 2015 2016 2018 2019 4 iI II 5 _Transportation incidents 1857 1865 1984 2054 2083 2080 2122 6 Contact with objects and equipment 738 721 715 722 761 786 732 7_ Falls. slips, and trips 646 724 818 800 849 791 880 8 7 Violence and other injuries by persons or animals 832 773 765 703 866 828 841 9 _ Exposure to harmful substances and environments 414 335 390 424 518 621 642 10 Fires and explosions 191 149 137 121 88 11.5 99 11 iNot Classified I 12 18 12 12 25 29- 17" 12__Total 4690 4585 4821 ($336 5190 5.250 5.333 O '3. Chart Ti The data labels should show at least one decimal place. Right click on one of the data labels. Chart Title 0% 12% idents Series 1 Data Liv Fill Outline its and equipment Delete 16% 2: Reset to Match Style hjuries by persons or A Font.. substances and Change Chart Type. Select Data... O 16% 3-D Rotation... 14% Format Data Series...Then in the right-hand-side menu, choose Format Data Labels. Choose Number and Percentage (see below). Q R S T U Format Data Labels Label Options V Text Options Label Options Label Contains Value From Cells Series Name Category Name Value Percentage Show Leader Lines O Legend key Chart Title Separator Reset Label TextMake sure that you can see all the categories in your legend. You might need to drag the corner of your graph to make it bigger to show all categories in the legend. Also, make sure you have a title, axis labels, and the source added to your graph. Attach your effective chart here by selecting your chart in Excel, right click on it and choose Save as Picture. Attach the saved picture in the field below. (You can also simply take a screenshot if that is easier.) 03.2 2 Points Write 12 sentences carefully describing the graph. What do you want your audience to know about the data you graphed? Enter your answer here Q4 5 Points In the file FatalWorklnjuries2019.xlsx, select tab titled, Fatal Injuries by Gender. 04.1 4 Points Create 2 effective pie charts: one of employment by gender for 2019, and the other of fatalities by gender for 2019. Attach both here by selecting each chart in Excel, rightclicking on it, and choosing Save as Picture. Attach the saved picture in the field below. (You can also simply take a screenshot if that is easier.) E Please select file(s) Select file(s) |% Please select fi|e(s) Select file(s) Save Answer 04.2 1 Points Looking at the fatalities pie chart, which of the following conclusions is correct (choose one)? 1. 92% of all men who are employed suffer a fatal injury. 2. 8% of all women suffer a fatal injury. 3. 8% of all fatal work injuries are suffered by women. Enter your answer here Save Answer 04.3 2 Points Write 12 sentences carefully describing the two graphs. What can you conclude about employment and fatalities by gender? Enter your answer here 4 Points In the file FatalWorklnjurie52019.xlsx, select tab titled, Fatal Injuries by Age. 05.1 2 Points Make an effective column graph to represent the number of fatal work injuries for each age group in both 2012 and 2019. To make sure that each series is labeled, select the data in cells A3 through G3, then hold down CTRL and select the labels and data for 2012 and 2019 (cells A4 through G4, and A11 through G11). Choose layout 9 to include the title, x and y axis labels and the legend. Attach your effective chart here by selecting your chart in Excel, rightclicking on it and chooseing Save as Picture. Attach the saved picture in the field below. (You can also simply take a screenshot if that is easier.) Q Please select filels) Select file(s) Save Answer 05.2 2 Points What age group had the highest number of fatalities in 2019? Which group had the lowest number of fatalities in 2019'? Which age group had the largest increase in the number of fatalities from 2012 to 2019? Are there any groups that experienced a drop in numbers from 2012 to 2019, if yes which groups? Enter your answer here