the data is the one of the picture below!

Use the Data Set from the Excel file: Bears (measurements from anesthetized wild bears) to answer the following questions. Show all your work. If you use a calculator or software, attach all graphs and calculations.

1.Find the following statistics values:

a) mean age of the bears;

b) median age of the bears;

c) mode of the ages;

d) range of the ages;

2.Find the standard deviation of the ages. To do that, you can use a graphing calculator or statistical software. Look at the attached file Graphing Calculator guide for instructions. Explain the meaning of the standard deviation in this case.

3.Find the five number summary and draw a box plot for the ages. Analyze the box plot. (symmetry, skewness, variation)

4.Organize the data values (ages) in a binned frequency table using bins with width 20, starting form 0-19, 20-39, and so on. Add columns for the relative and cumulative frequency.

5.Use the frequency table from step 4 to construct a histogram of the data set. Don't forget to label the axis and give a title of the graph.

6.

Based on the histogram from step 5, draw the distribution curve of the data set. Analyze the curve discussing the number of peaks, symmetry, and its variation.

Bears (measurements from anesthetized wild bears) AGE CHEST 19 26 55 45 81 54 115 49 104 35 100 41 56 41 51 49 57 38 70 45 68 44 19 32 37 29 33 39 19 48 32 33 28 23 42 23 34 31 34.5 34 26 48 48 29 9.5 35 44.5 34 39 58 40 58 50 31 23 38 70 55 27 44 44 26 26 30.5 17 28 17 23 24 83 54 18 32.8