Please answer the following questions from the grouped data using Excel.
1) You go to Europe, and you want to present your data in Celsius. Knowing that C = (F - 32) * (5/9), where F is the temperature in Fahrenheit and C is the temperature in Celsius, what is the average daily temperature of your city for your period of analysis, in Celsius? (Try to use Excel to make this computation, although any calculator would work for this question). Present your answer rounded to one decimal place.
2) You go to Europe, and you want to present your data in Celsius. Knowing that C = (F - 32) * (5/9), where F is the temperature in Fahrenheit and C is the temperature in Celsius, what is the standard deviation of the daily temperature of your city for your period of analysis, in Celsius? (Try to use Excel to make this computation, although any calculator would work for this question). Present your answer rounded to two decimal places.