Question

LU 1 Copy Bad Check Cell Good Explanatory... Neutral Input Alignment Intern Styles Project 2 - Read-Only - Excel File Home Insert Page Layout Formulas Data Review View Help Search A Xcut Calibri - 12 -A A === - Wrap Test General Normal Paste Format Painter BIUR O -A- S Merge & Center $ - % 9 8 99 Conditional Format as Calculation Formatting Table Clipboard Font Number A1 X Comparing injury rates by high school sport А LD E OG 13 Soccer 1.87 2.59 4.46 14 Basketball 1.48 2.14 3.62 15 Track & Field 0.68 0.97 1.65 16 Lacrosse 2.10 1.40 3.50 17 Football 4.01 4.01 18 no statistics available for girls playing football 17.24 Total injury rate 19 20 1 - Insert a bar graph of the sport injury rates, with the title "Injury Rate per Sport and Gender" 21 This will be a 2 bar chart, one bar for each gender, by sport 22 Be sure to include a legend that indicates which bar is Boys, and which is Girls 23 24 38 39 2 - Which sport has the highest overall injury rate, highest injury rate for boys, highest injury rate for girls: 40 Overall Boys Girls Project 2 Grading →

Answer 1

Solution:

1) Bar graph: Bar graph is way of representing the categorical data in the graphical form. In bar graph we draw rectangular bars such that the height of the each bar is the proportional to the value it represents.

The bar graph for the sport injury rates is as follows:

X Book1 Exce FILE НОМE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW XLSTAT Cut A A Calibri 11 'Wrap Text General CCopy Paste в I U Merge & Center Format Painter Clipboard Font Alignment Number Т30 A В C D Injury rate per 1000 athlete exposures Sport 1 Girls Total 2 Вoys 3 Soccer 1.87 2.59 4.46 4 Basketball 2.14 1.48 3.62 5 Track & Field 0.68 0.97 1.65 6 Lacrosse 2.1 1.4 3.5 7 Football 4.01 4.01 9 1) Injury rate per Sport and Gender 10 4.5 11 4 12 3.5 13 14 3 ddabl 15 2.5 16 2. 17 1.5 18 1 19 0.5 20 0 21 Soccer Basketball Track & Field Lacrosse Football 22 Boys Gir ls 23 T L en

2) The sports "Soccer" has the overall highest injury rate with total injury rate of 4.46.

The sports "Football" has the highest injury rate for boys with the boy's injury rate of 4.01.

The sports "Soccer" has the highest injury rate for girls with the girl's injury rate of 2.59.