View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim J. Jim J. is offline
external usenet poster
 
Posts: 11
Default Statistical Analysis: Pass/Fail Correlation

I have an Excel spreadsheet (.xlsx) that I want to use to determine
correlation. There are 30 columns and 690 rows (1 row of €œLabels€, and 689
rows of data). The 2nd column is Pass (€œ1€) or Fail (€œ0€) data. My goal is
to determine what factors most strongly influence the part to Pass, and which
most strongly influence the part to Fail.
I am no wizard at statistical analysis, so I would appreciate any help I can
get. I can make the spreadsheet available to you so you can play with it.
There is no proprietary data in the spreadsheet (everything has been coded
with a numerical value). My email is
Thanks in advance!