Question 1. (30 points). I am interested in knowing how the climate changes in terms of temperature and precipitation. The U.S. climate data site contains climate data for Denton, Texas since 2009. I would like you to do some calculation and comparison between the data in 2010 and 2017 in order to answer the following two research questions: RQ1: Is 2017 significantly different from 2010 on temperature and precipitation in the months January-June? RQ2: Is June 2017 significantly hotter than June 2010?
(1) (10 points). Create two files based on data published at U.S. climate data (http://www.usclimatedata.com/climate/denton/texas/united-states/ustx0353):
➢ File A (should be called 2010-Jan-June.txt, or 2010-Jan-June.csv) contains daily weather data from January 1, 2010 to June 30, 2010; ➢ File B (called 2017-Jan-June.txt, or 2017-Jan-June.csv) contains daily weather data from January 1, 2017 to June 30, 2017;
To find the data, go to “History” tab of the above page, select the right year and month. You will see the data being presented to you
The final format of each result file should look like the following:
<Date-month>, <High>, <Low>, <Precip> 1-Jan,55,33,0.08 2-Jan,55,33,0.12 … 1-June,80,56,0,15 … The delimiter can be comma (,) or whitespace. Make sure you round the numbers for the temperature so there is no decimal points.
(2) (20 points). Write a program to calculate the mean, median, and standard deviation of high temperature, low temperature and precipitation of each file, and output the results in the following format:
Eg: Filename Mean Median Standard deviation
Your filename73.5577 19.394
(path can be included)
And so forth……