02 8 Points Open the file FatalWorklnjurie32019.xlsx and select the tab titled Fatal Work Injuries by Year, which contains the number of fatal work injuries and employment from 1992 through 2019. We are going to make a chart of this data and discuss the graph. Q2.1 2 Points Make an XY scatterplot of the fatal work injuries data and be sure to choose the following graph type: Scatter with Straight Lines and Markers. AutoSave . Off FatalWorkInjuries2019 - File Home Insert Page Layo Formulas Data Review View Developer Help LO Tables Illustrations Add- Recommended Maps PivotChart ins v Charts Scatter A5 V fx 1992 A B E 1 Number of Fatal Work Injuries, 1992 - 2019 2 Bubble 3 Year Fatal Work Injuries Number of Peo02.2 2 Points Write 12 sentences carefully describing the graph. What do you want your audience to know about the data you graphed? 02.3 2 Points Change the scale on the yaxis (right click on the y-axis and choose Format Axis...) Start with a minimum of 4400 (change the number from 0 to 4400) and end with a maximum of 7000 (no change needed). Select 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.) 02.4 2 Points Is the graph you created in Question 2.1 better than the graph created in Question 23, or is the graph in Question 2.3 better? Which graph is correct? When would you choose to adjust the scale? Provide written support for your answer. 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.) 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 AutoSave OFF WHYG... FatalWorkInjuries20 Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 10 VA A Wrap Text v General paste B IUV MVA E EE Merge & Center $ ~ % " A1 X fx Number of Fatal Work Injuries, 1992 - 2019 A B C D E F G H 1 J K Number of Fatal Work Injuries, 1992 - 2019 Year Fatal Work Injuries Number of People Employed 1992 6,217 192,805,333 1993 6,331 194,837,583 1994 6,632 196,814,500 1995 6,275 198,584,083 1996 6,202 200,590,583 1997 5,238 203,133,250 1998 6,055 205,220,083 1999 6,054 207,752,917 2000 5,920 212,576,750 2001 5,915 215,092,500 2002 5,534 17,569,583 2003 5,575 21,167,917 2004 5,764 223,356,833 2005 5,734 226,082,583 2006 5,840 228,814,667 2007 5,657 231,867,000 2008 5,214 233,788,000 2009 4,551 235,801,000 2010 4,690 237,829,333 2011 4,693 239,617,500 2012 4,628 243,284,33 2013 4,585 245,679,333 2014 4,821 247,946,583 2015 4 ,836 250,800,583 2016 5,190 253,537,500 2017 5,147 255,079,000 2018 5 ,250 257,790,667 2019 5,333 259,175,000 Source: Bureau of Labor and Statistics http://www.bls.gov/cps/cpsatabs.htm Check boxes for total employed population, take average for each year ICar fatalities an to hitthe. /hummus hle anulcharte/cancue of fatal accunational.iniurineumber of fatal work injuries hu.amnlouen ctatuc calf amnloved_ware.calar htm Fatal Work Injuries by Year Fatal Injuries by Event Fatal Injuries by Gender Fatal Injuries by Age +A B C D E F G H Fatal Occupational Injuires by Event or Exposure, 2010, 2013, 2014, 2015, 2016, 2018 ,2019 W Event 2010 2013 2014 2015 2016 2018 2019 4 UT 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 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 115 99 11 Not Classified 12 18 12 12 25 29 17 12 Total 4690 4585 4821 4836 5190 5,250 5,333 13 14 15 Source: Bureau of Labor and Statistics 16 17 https://www.bls.gov/iif/oshcfoil.htm#2019 18 http://www.bls.gov/cps/cpsatabs.htm 19 20 21A B C D E F G H Employment and Fatality Profiles by Gender of Worker, 2019 Employment Fatalities 2019 Men 83,460,000 4,896 Women 74,078,000 437 Total 157,538,000 5,333 Source: Bureau of Labor and Statistics https://www.bls.govews.release/cfoi.t01.htm http://www.bls.gov/cps/cpsatabs.htmWorker Fatalities by Age Group, 2012-2019 W N under 25 years 25-34 years 35-44 years 45-54 years 55-64 years 4 2012 65 years and over 375 736 829 1,161 936 2013 588 350 777 853 1,115 933 2014 557 356 753 860 1,161 1,007 2015 684 403 758 864 1,130 1,031 650 2016 383 834 979 1,145 1,160 688 2017 377 872 907 1,059 1,155 10 2018 775 360 946 966 1,114 1,104 11 2019 759 409 866 967 1,082 1,212 12 793 13 Source: Bureau of Labor and Statistics 15 16 17 http://www.bls.gov/iif/ 18 http://www.bls.gov/cps/cpsatabs.htm 19 20