A health scientist in Maryville wants to quantify the relationship between water temperature and Giardia concentration. {Giardia is a parasite that makes people sick.) They visit a random sample of 14 homes in Maryville, and in each home they measure the temperature of a water sample and measure the amount of Giardia Present. The data is captured in the table below. NB In this question, if you use Excel functions you should list the functions you used. If you use an analysis tool add-in you should cut and paste the output into your answer, and if you use and "old school" approach you should quotethe relevant formulae. Sample T, Temperature in G, {Giardia Celsius} concentration '000 per litre) 1 55.2 2.47 2 45.9 2.69 3 37.3 2.51 4 11.2 3.62 5 32.6 2.12 6 12.9 2.39 7 23.4 2.53 8 22.1 1.90 9 27.9 1.89 10 8.8 1.76 11 21.6 2.11 12 11.9 1.94 13 52.0 3.06 14 31.9 2.65 a. [3 marks] Determine the mean, median and standard deviation of Giardia concentration for this sample. b. [2 marks] Determine the Ordinary Least Squares regression line that uses temperature to explain or predict Giardia concentration. c. [1 mark] Interpret the slope coefficient. d. [2 marks] Determine and interpret the standard error ofthe estimate. e. [2 marks] Determine and interpret the coefficient of determination f. [2 marks] Use your regression equation to predict the Giardia concentration ifthe water temperature is 60 Celsius and explain why this might be problematic