Tom and Helen each studied chimpanzees from two different regions in Africa The weights (kg) of 16 chimps studied by Tom 63, 45, 35, 45, 72, 39, 56, 47, 58, 60, 38, 40, 67, 61, 55, 42. The weights (kg) of 22 chimps studied by Helen 55, 63, 35, 56, 49, 51, 52, 40, 74, 70, 43, 65, 72, 65, 38, 41, 49, 60, 63, 58, 38, 58. 1 mark a) Enter Helen's data into an Excel spreadsheet b) Create a Pivot table for Helen's set of data i) Group the data into bins of 5 kg's ii) Give the Tables appropriate headings 4 marks c) Construct a Histogram of Helen's set of data i) Display the Frequency for each weight interval on the y-axis ii) Set a bin width of 5kgs iii) Give the plot a Title iv) Label both Axes. 6 marks d) Discuss the distribution in the weights of Helen's group of chimpanzees referring to the centre, spread, shape and any outliers in the data e) For Helen's chimpanzee group, set up a table in your Excel spreadsheet to determine the following Numeric Summary for the weight data. Round all values to 1dp Statistic Value Mean Standard Deviation Minimum Lower Quartile Median Upper Quartile Maximum g) Construct a box plot of weight data from Helen's group of Chimpanzees. i) Give the plot a Title ii) Label the vertical Axis 3 marks h) Comment on the distribution of Helen's chimpanzee weight data referring to the Centre, Spread, Shape and any Outliers 4 marks h) Make 4 comments on the similarities and differences of the weight data of chimpanzees studied by Tom and Helen, comparing your graphical displays with the one's below. Frequency of Chimpanzee Weights in Tom's study Distribution of Chimpanzee Weights in Tom's study 2 20 25 50 Ti 14.0 10.5 L, tos, C, Che Weil JO