Use the data in the Excel file below to answer the following questions.

The EXCEL data file: NYC and Sydney Temperature data [+]. It contains historical data for the annual average temperature records for New York City, USA, and Sydney, Australia. 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. Optionally, You can find the data and the original data sources at Temperature trends.

b) What does the correlation coefficient imply about the trend in temperatures, if any?

c) Find the equation for the least squares regression (LSR) line, y = mx + b. Give your answers to 3 decimal places.

• m =
• b =

e) Based on the equation of LSR line, what is the predicted value for 2013 average temperature in NYC?The predicted annual average temp for NYC in 2013 is degrees fahrenheit

f) Can we use this LSR line equation to predict the Annual Average Temperatures far into the future? Explain.

g) Write a paragraph summarizing your findings. Is there statistically significant evidence of any pattern or trend in temperature over the observation period in NYC?

?

A B D E F Year NYCtemp( F) Year Sydtemp ( F) 1989 53.2 1989 71.8 WO N 1990 56.4 1990 72.1 4 1991 56.4 1991 73 1992 53.1 1992 70.7 6 1993 54.7 1993 72.1 1994 54.4 1994 72.7 8 1995 54.4 1995 71.2 9 1996 53.7 1996 71.8 10 1997 54.3 1997 72.3 11 1998 57.1 1998 72.9 12 1999 56.5 1999 71.8 13 2000 53.8 2000 72.9 14 2001 56.2 2001 73.6 5 2002 56.4 2002 73.6 16 2003 53.4 2003 72.9 17 2004 54.5 2004 74.1 18 2005 55.7 2005 74.1 19 2006 56.8 2006 73.6 20 2007 55 2007 72.9 21 2008 55.3 2008 71.8 22 2009 54 2009 73.2 23 2010 56.7 2010 72.7 24 2011 56.4 2011 72.7 25 2012 57.3 2012 72.9 26 2013 55.5 2013 74.7 27