document.write( "Question 352117: Part-time weekly earnings ($) by college students.
\n" ); document.write( "hours worked (x) weekly pay (y)
\n" ); document.write( "10 93
\n" ); document.write( "15 171
\n" ); document.write( "20 204
\n" ); document.write( "20 156
\n" ); document.write( "35 261\r
\n" ); document.write( "\n" ); document.write( "this is the question: a) make an excel scatter plot. what does it suggest about the population correlation between X and Y? b) make an excel worksheet to calculate SSxx,SSyy, and SSxy c) use appendix D to find t.05 for a two-tailored test for zero correlation. d) calculate the t test statistics. can you reject p=0?
\n" ); document.write( "

Algebra.Com's Answer #251593 by Fombitz(32388)\"\" \"About 
You can put this solution on YOUR website!
a)
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "b) From my EXCEL spreadsheet,
\n" ); document.write( "\"xave=20\"
\n" ); document.write( "\"yave=177\"
\n" ); document.write( "\"SSXX=350\"
\n" ); document.write( "\"SSYY=15318\"
\n" ); document.write( "\"SSXY=2130\"
\n" ); document.write( "\"b1=SSXY%2FSSXX=6.036\"
\n" ); document.write( "\"b2=SSXY%2FSSYY=0.139\"
\n" ); document.write( "\"r%5E2=b1%2Ab2=0.846\"
\n" ); document.write( "\"a=yave-b1%2Axave=55.286\"
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "\"highlight%28y=6.036x%2B55.286%29\"
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "Regression line plotted with the data.
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( ".
\n" ); document.write( "
\n" ); document.write( "
\n" );