90.2K

Verified Solution

Link Copied!

(a)	Make an Excel worksheet to calculate SSxx,SSyy, and SSxy.(Leave no cells blank - be certain to enter \"0\" whereverrequired. Negative values should be indicated by a minus sign.Round your answers to 2 decimal places.)
   Â	 Â

Part-Time Weekly Earnings ($) by CollegeStudents
Hours Worked (X)	Weekly Pay (Y)	(xi−x⎯⎯)2(xi−x¯)2	(yi−y⎯⎯)2(yi−y¯)2	(xi−x⎯⎯)(yi−y⎯⎯)(xi−x¯) (yi−y¯)
10	93	?	       ?	       ?
15	171	          ?	       ?	          ?
20	204	       ?	       ?	          ?
20	156	       ?	       ?	       ?
35	261	       ?	       ?	       ?
		     Â	     Â	     Â
             x⎯⎯x¯ Â	           y⎯⎯y¯ Â	         ssxxssxx	         ssyyssyy	              ssxyssxy
?	?	?	?	?

    

(b)	Use the formulas to calculate the slope and intercept.(Round your answers to 3 decimal places.)

  b1	   ?
  b0	   ?

  

(c)

Use your estimated slope and intercept to make a worksheet tocalculate SSE, SSR, and SST.(Leave no cells blank - be certain toenter \"0\" wherever required. Negative values should be indicated bya minus sign. Do not round intermediate calculations, but finalanswers should be rounded to 3 decimal places.)

  

Hours Worked (xi)	Weekly Pay (yi)	Estimated Pay    (yˆi)(y^i) Â	yi−yiˆyi−yi^	(yi−yˆi)2(yi−y^i)2	(yˆi−y⎯⎯)2(y^i−y¯)2	(yi−y⎯⎯)2(yi−y¯)2
10	93	   ?	   ?	   ?	   ?	   ?
15	171	   ?	   ?	   ?	      ?	   ?
20	204	   ?	   ?	? Â	   ?	   ?
20	156	   ?	   ?	? Â	   ?	? Â
35	261	   ?	   ?	   ?	   ?	   ?

   

  Â
    x⎯⎯x¯	   ?
    y⎯⎯y¯	   ?
  SSE	   ?
  SSR	   ?
  SST	   ?

  

(d)	Calculate the R2. (Round youranswer to 4 decimal places.)

  

  R2

     ?