document.write( "Question 1045769: Consider the following set of x and y values.\r
\n" ); document.write( "\n" ); document.write( "X Y
\n" ); document.write( "2 5
\n" ); document.write( "6 9
\n" ); document.write( "11 15
\n" ); document.write( "13 18
\n" ); document.write( "16 22\r
\n" ); document.write( "\n" ); document.write( "5.1. Draw a scatter diagram depicting the data.
\n" ); document.write( "5.2. Calculate Pearson’s correlation coefficient.
\n" ); document.write( "5.3. Determine the linear regression equation.
\n" ); document.write( "

Algebra.Com's Answer #661297 by ewatrrr(24785)\"\" \"About 
You can put this solution on YOUR website!
X Y
\n" ); document.write( "2 5
\n" ); document.write( "6 9
\n" ); document.write( "11 15
\n" ); document.write( "13 18
\n" ); document.write( "16 22
\n" ); document.write( "This can easily be done in Excel
\n" ); document.write( "Make table,
\n" ); document.write( "\"go to Insert drop down)\" select: scatter plot and then go to layout... bo choose trendline (check boxes for equation display)\r
\n" ); document.write( "\n" ); document.write( "
\n" ); document.write( "
\n" );