document.write( "Question 117448: http://i147.photobucket.com/albums/r317/fizzero/graph.jpg\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "^that is the link to the graph.\r
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "what is the slope and verticle intercept for the line?
\n" ); document.write( "m=? and y-intercept=\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "what is the equation of the line?\r
\n" ); document.write( "\n" ); document.write( "using the least square method what is the correlation coefficient?\r
\n" ); document.write( "\n" ); document.write( "r= ??
\n" ); document.write( "

Algebra.Com's Answer #85457 by Fombitz(32388)\"\" \"About 
You can put this solution on YOUR website!
From your graph, you have 9 (x,y) data pairs.
\n" ); document.write( "First, make a table with the x,y data points.
\n" ); document.write( "Add 5 columns to your table.
\n" ); document.write( "1.\"x%5Bi%5D\"
\n" ); document.write( "2.\"y%5Bi%5D\"
\n" ); document.write( "3.\"%28x%5Bi%5D-x%5Ba%5D%29\"
\n" ); document.write( "4.\"%28y%5Bi%5D-y%5Ba%5D%29\"
\n" ); document.write( "5.\"%28x%5Bi%5D-x%5Ba%5D%29%5E2\"
\n" ); document.write( "6.\"%28y%5Bi%5D-y%5Ba%5D%29%5E2\"
\n" ); document.write( "7.\"%28x%5Bi%5D-x%5Ba%5D%29%28y%5Bi%5D-y%5Ba%5D%29\"
\n" ); document.write( "where \"x%5Ba%5D\" is the average of the x values and \"y%5Ba%5D\" is the vaverage of the y values.
\n" ); document.write( "Calculate the values for i=1 to 9.
\n" ); document.write( "Sum columns 5,6,7.
\n" ); document.write( "You are solving for the regression equation
\n" ); document.write( "\"y=b%5B1%5Dx%2Bb%5B0%5D\"
\n" ); document.write( "where
\n" ); document.write( "
\n" ); document.write( "or
\n" ); document.write( "\"b%5B1%5D=%28Sum_of_column_7%29%2F%28Sum_of_column_5%29\"
\n" ); document.write( "and
\n" ); document.write( "\"b%5B0%5D=y%5Ba%5D-b%5B1%5D%2Ax%5Ba%5D\"
\n" ); document.write( "From this we see that
\n" ); document.write( "\"b%5B1%5D\" is the slope of the regression line.
\n" ); document.write( "\"b%5B0%5D\" is the y-intercept of the regression line.
\n" ); document.write( "\"y=b%5B1%5Dx%2Bb%5B0%5D\" is the equation of the regression line.
\n" ); document.write( "To calculate the \"r%5E2\", you need to calculate two more quanitities, \"sigma%5Bx%5D\" and \"sigma%5By%5D\"
\n" ); document.write( "where
\n" ); document.write( "\"sigma%5Bx%5D=sqrt%28sum%28%28x%5Bi%5D-x%5Ba%5D%29%5E2%29%2FN%29\"
\n" ); document.write( "or
\n" ); document.write( "\"sigma%5Bx%5D=sqrt%28Sum_of_column_5%2FN%29\"
\n" ); document.write( "and
\n" ); document.write( "\"sigma%5By%5D=sqrt%28sum%28%28y%5Bi%5D-y%5Ba%5D%29%5E2%29%2FN%29\"
\n" ); document.write( "or
\n" ); document.write( "\"sigma%5By%5D=sqrt%28Sum_of_column_6%2FN%29\"
\n" ); document.write( "and
\n" ); document.write( "N is the number of data points, 9.\r
\n" ); document.write( "\n" ); document.write( "The coefficient, \"r%5E2\", is then calculated from
\n" ); document.write( "
\n" ); document.write( "\"r%5E2=%28%281%2FN%29%2ASum_of_column_7%2F%28sigma%5Bx%5Dsigma%5By%5D%29%29%5E2\"\r
\n" ); document.write( "\n" ); document.write( "EXCEL is the perfect program to do this kind of work.
\n" ); document.write( "Good luck.
\n" ); document.write( "Post another question if you get stuck.
\n" ); document.write( "
\n" );