1. There are 14 columns of data, including 3 columns with a calculation.
2. There are 514 rows of data in the workplace safety report table.
3. Each row shows the following fields:
4. 
   
5. Date: Date of safety incident
6. Injury Location: location on the body where the injury occurred
7. Gender: employee gender
8. Age Group: employee age group (18-24, 25-34, 35-49, 50+)
9. Incident Type: Type of safety incident, e.g. Burn, Fall, Vehicle
10. Days Lost: number of days employee off work
11. Plant: manufacturing location where the incident occurred
12. Report Type: Type of safety report filed - First Aid, Lost Time, Medical Claim, Near Miss
13. Shift: work shift when the incident occurred - Afternoon, Day, Night
14. Department: work department where the incident occurred
15. Incident Cost: total cost of safety incident
16. WkDay: 3-letter code for day of the week (calculation, based on Date)
17. Month: month number (calculation, based on Date)
18. Year: year number (calculation, based on Date)
19. Question:
20. 
    
21. Using the data from the attached Excel file, you must calculate the following tests:
22. 
    
23. a. Mean, mode, and median (select three variables of your choice)
24. 
    
25. b. Variance and Standard Deviation (select three variables of your choice)
26. 
    
27. c. Three graphical presentations of the data of your choice.