Is there anyone out there who attempted to do PairWise comparisons in Excel?
P Phillip Aug 12, 2008 #1 Is there anyone out there who attempted to do PairWise comparisons in Excel?
P Pete_UK Aug 12, 2008 #2 Do you mean to compare A1 with B1, then A2 with B2 etc? If so, put this formula in C1: =IF(A1=B1,"equal",IF(A1>B1,"A is larger","B is larger")) Then copy down as far as you need. Hope this helps. Pete
Do you mean to compare A1 with B1, then A2 with B2 etc? If so, put this formula in C1: =IF(A1=B1,"equal",IF(A1>B1,"A is larger","B is larger")) Then copy down as far as you need. Hope this helps. Pete
M Mike Middleton Aug 12, 2008 #3 Phillip - One kind of "PairWise comparisons" is a statistical inference hypothesis test. Excel's Analysis ToolPak has a "t-Test: Paired Two Sample for Means" feature. The Analysis ToolPak is an add-in provided on the Office/Excel installation CD. In Excel 97-2003, choose Tools | Data Analysis | ... In Excel 2008, choose Data | Data Analysis | ... If you are referring to some other kind of "PairWise comparisons," please provide more details and version of Excel. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel
Phillip - One kind of "PairWise comparisons" is a statistical inference hypothesis test. Excel's Analysis ToolPak has a "t-Test: Paired Two Sample for Means" feature. The Analysis ToolPak is an add-in provided on the Office/Excel installation CD. In Excel 97-2003, choose Tools | Data Analysis | ... In Excel 2008, choose Data | Data Analysis | ... If you are referring to some other kind of "PairWise comparisons," please provide more details and version of Excel. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel
