Part 1: Use Excel Spreadsheet to solve this part (submit a soft copy of the excel file with all your calculation in it): 1. Two groups of students were asked to analyze a sample of bottled water for chloride concentration. Each group repeated the measurement 6 times, and their readings are shown below: (10 Marks) Group 1 Group 2 12.1 10.7 11.9 11.9 10.9 11.9 11.1 12.4 10.5 11.9 10.9 11.8 If the actual concentration of chloride was reported on the bottle to be 12 mg/l calculate the following for each set a) the mean b) the range. c) the standard deviation. d) Which of the two groups has better accuracy and which has better precision? Why