# solved: Use the data in the Excel file below to answer the following…

Use the data in the Excel file below to answer the following…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??Image transcription textA 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… Show more  MathStatistics and Probability MAT 120

Don't use plagiarized sources. Get Your Custom Essay on
solved: Use the data in the Excel file below to answer the following…
Just from \$10/Page

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.