Question: Any excel sheet works perfectly fine (google,Microsoft, etc) Problem 2. (60 points) There is a theory that children wearing superhero costumes are more likely to

Any excel sheet works perfectly fine (google,Microsoft, etc)

Any excel sheet works perfectly fine (google,Microsoft, etc) Problem 2. (60 points)

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!