The table displays data on the average annual global temperatures in degrees Celsius for the years between 1994 and 2014:| Year | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 ||------|-------|-------|-------|-------|-------|-------|-------|-------|-------|-------|-------|| Temperature | 14.23 | 14.35 | 14.22 | 14.42 | 14.54 | 14.36 | 14.33 | 14.45 | 14.51 | 14.52 | 14.48 || Year | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 ||------|-------|-------|-------|-------|-------|-------|-------|-------|-------|-------|| Temperature | 14.55 | 14.50 | 14.49 | 14.41 | 14.50 | 14.56 | 14.43 | 14.48 | 14.52 | 14.59 |**Data Formats:**You can download the data in your preferred format by clicking on the links below:- [CSV](#)- [Excel](#)- [JMP](#)- [Mac-Text](#)- [Minitab](#)- [PC-Text](#)- [R](#)- [SPSS](#)- [TI](#)- [CrunchIt!](#)**Instructions for Analysis:**1. Create a scatterplot using the year as the explanatory variable and temperature as the response variable.2. The least-squares regression line is given by the equation: \[ \text{temperature} = -7.8 + (0.0111 \times \text{year}) \]3. Predict the annual average temperature for 2014 using this line and report your answer in degrees Celsius to two decimal places. **Forecasting Annual Average Temperature****Question 1: Prediction for 2014**What would you predict for the annual average temperature for 2014 based on this line? Report your answer in degrees to two decimal places.**Temperature:**\[ \text{Temperature} = \underline{\hspace{3cm}} \, ^\circ \text{Celsius} \]**Question 2: Regression Prediction**The predicted temperature from the least-squares regression equation for 2014 is:\[ \text{Predicted Temperature:} \, \underline{\hspace{5cm}} \]**Question 3: Correlation and Variation**The correlation between these variables is \( r = 0.675 \). What percentage of the variation in temperature can be explained by the straight-line dependence on the year? Round your answer to the nearest whole percent.**Percentage Explained:**\[ \text{Percentage:} \, \underline{\hspace{2cm}} \, \% \]

The question is about regression Given : To find : 1 ) Scatter plot 2 ) Pred. avg. temperature for the year 2014 3 ) Fill the given blank 4 ) % of variation in temp. explained by year1 ) Using excel i ) Enter the data into columns of excel spreadsheet ii ) Select the data iii ) Go to Insert -- > Charts -- > Scatter 2 ) Given reg. eq. : Temperature = -7.8 + ( 0.0111 * Year ) Plugging year = 2014 in above reg. eq. Temperature = -7.8 + ( 0.0111 * 2014 ) Temperature = 14.5554 Rounding value to 2 dec. place as Temperature = 14.56 Thus, The pred. avg. temperature for the year 2014 is 14.56 degree Celsius 3 ) Actual temp for the yr 2014 = 14.59 The pred. avg. temp. is within 0.05 of the actual temp. 4 ) Given : r = 0.675 R2 = r2 = ( 0.675 )2 = 0.455625 Converting into % as R2 = 45.5625 % Converting % into whole % R2 = 46 % Thus, 46 % Variation in temp. can be explained by the year