| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help - Sum results Pass or Fail | Excel Worksheet Functions | |||
| Creating a pass of fail condition | New Users to Excel | |||
| Graphing Text: Pass or Fail | Charts and Charting in Excel | |||
| Pass or Fail (green or red) criteria for cell? | Excel Discussion (Misc queries) | |||
| pass fail | New Users to Excel | |||
Threaded Mode
