View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default multivariate regression

I am trying to teach myself the multivariate regression function in
toolsdata analysisregression. The following dummy variables I made up are
'significant' by the F-test but...what is a layman's explanation for the
Coefficients and Residuals you get? Is there a good Excel page that explains
to 'us' dummies the Summary Output page?

AGE (X1) PACKS/MONTH (X2) LUNG CANCER RISK (Y)
30 25 0.4
40 30 1.2
50 25 1.7
60 37 3.5
70 42 6.7
80 39 9.9

Thanks!!!