Project: Historical Temperature Trends (Hypothesis test) Use the following historical data for the annual average temperature records for New York City, USA to answer the following questions. For each year, the data value is calculated by taking the average of the daily high temperature readings from every day of that year, observed in a specific location, e.g., Central Park for New York and Observatory Hill for Sydney. The data are sorted by year in ascending order. For your convenience, temperatures have been converted to the Fahrenheit scale. You can find the data and the original data sources at https://lagcc- cuny.digication.com/project_data/Temperature_Trends.) For your convenience the EXCEL data files are attached along with the assignment. Q#1) We want to know if the recent temperatures (1989 to 2013) in NYC, has increased compared to temperatures in NYC during 1889 to 1988. We will conduct a hypothesis test to make this decision. Text The average temperature of the NYC for the years between 1889 to 1988 was 52.872 °F. Use t- distribution to conduct the hypothesis test at 5% level of significance to test if the annual average temperature of New York City has increased over the past 25 years. Write your conclusion from the results you obtained. (Hint: Compute the average temperature (x) and the standard deviation (s) from the given data for the last 25 years (1989 - 2013)). Q#2) Repeat the above exercise for Sydney. The average temperature of Sydney for the years between 1889 to 1988 was 70.993 E. Q#3) Does your analysis of the historical temperature data for the two cities, provide evidence for the existence of the increasing temperature trend around the world? Why or why not? Include one graph or chart to support your claim. Based on the analysis of temperature data reflect on whether the Global Warming is occurring? You may search appropriate data bases to support your answer.