A theory that children wearing superhero costumes are more likely to

harm themselves because of the unrealistic impressions of invincibility that these costumes could

create. Below there is data about the severity of injury (on a scale from 0, no injury, to 100, death) for

children reporting to the emergency center at hospitals and information on which superhero costumes

they were wearing (Spiderman, Superman, Batman)

Problem 2. (60 points) There is a theory that children wearing superhero costumes are more likely to harm themselves because of the unrealistic impressions of invincibility that these costumes could create. Below there is data about the severity of injury (on a scale from 0, no injury, to 100, death) for children reporting to the emergency center at hospitals and information on which superhero costumes they were wearing (Spiderman, Superman, Batman). Severity of Costume Injuries in Children Spiderman Superman Batman 51 58 26 31 32 43 58 85 30 20 66 35 47 58 53 37 52 41 Please complete this problem on sheet 2 of your Excel workbook. 1) Using Microsoft Excel functions (formulas), compute the following descriptive statistics for each group. (30 points total) a) Mean (6 points) b) Sample size (n) for each group (6 points) c) Standard Deviation (6 points) d) Square root of n (6 points) e) Standard error of the mean (SEM) (6 points) 2) Create a fully labeled graph of the descriptive statistics. Choose formatting that is easy to read (i.e., no crazy colors, backgrounds, etc.). (30 points total) a) Create a graph of the group means (determine whether a line graph or bar graph is appropriate) (20 points) b) Label the graph (title and both axes) (5 points) c) Show variability for each group by adding error bars using standard error of the mean (SEM) or standard deviation (5 points)