question archive a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy

a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy

Subject:MathPrice:2.85 Bought3

a)

Make an Excel worksheet to calculate SSxxSSyy, and SSxy(Leave no cells blank - be certain to enter "0" wherever required.)

      
    

    

Part-Time Weekly Earnings ($) by College Students
Hours Worked (X) Weekly Pay (Y) formula31_4.mml formula32_4.mml formula33_4.mml
10              93                              
15              171                                
20              204                               
20              156                              
35              261                              
 
                                            
 
formula34_3.mml                formula35_3.mml            formula36.mml        formula37.mml        formula38.mml       
         
 

    

(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 to calculate SSESSR, and SST(Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Do not round intermediate calcuations, but final answers should be rounded to 3 decimal places.)

  

Hours Worked
(xi)
Weekly Pay
(yi)
Estimated Pay
formula229.mml
formula230_3.mml formula231_4.mml formula232_4.mml formula233_4.mml
10 93               
15 171                
20 204               
20 156               
35 261               
 

   

     
  formula234_3.mml   
  formula235_3.mml   
  SSE   
  SSR   
  SST   
 

  

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

  

  R2    

rev: 07_15_2014_QC_49920

check my workreferencesebook & resources

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE