How to do Pairwise comparison in Excel
 

Is there anyone out there who attempted to do PairWise comparisons in Excel?

Answer: How to do Pairwise comparison in Excel
 

Yes, it is possible to do Pairwise comparisons in Excel. Here are the steps to do it:

1. First, you need to create a table with the items you want to compare. For example, if you want to compare different types of fruits, you can create a table with the names of the fruits in the first column.
   
2. Next, you need to create a matrix with the pairwise comparisons. This matrix will have the same number of rows and columns as the number of items you want to compare. For example, if you have 5 types of fruits, you will need to create a 5x5 matrix.
   
3. In the first row of the matrix, enter the names of the fruits you want to compare. In the first column of the matrix, enter the same names.
   
4. Now, you need to fill in the matrix with the pairwise comparisons. For each cell in the matrix, you need to compare the item in the row with the item in the column and assign a score based on how much better one item is compared to the other. You can use a scale of 1 to 10, where 1 means that the item in the row is much worse than the item in the column, and 10 means that the item in the row is much better than the item in the column.
   
5. Once you have filled in the matrix, you can use Excel's built-in functions to analyze the data. For example, you can use the
   Code:

   ---

   AVERAGE

   ---

   function to calculate the average score for each item, or you can use the
   Code:

   ---

   MAX

   ---

   function to find the item with the highest score.
   
6. You can also use conditional formatting to highlight the cells in the matrix with the highest and lowest scores, making it easier to identify the best and worst items.

Overall, doing pairwise comparisons in Excel is a straightforward process that can be done with a few simple steps. With the right tools and techniques, you can quickly analyze and compare different items to make informed decisions.

How to do Pairwise comparison in Excel
 

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(A1B1,"A is larger","B is larger"))

Then copy down as far as you need.

Hope this helps.

Pete

On Aug 12, 5:04*pm, Phillip wrote:
Is there anyone out there who attempted to do PairWise comparisons in Excel?

How to do Pairwise comparison in 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



"Phillip" wrote in message
...
Is there anyone out there who attempted to do PairWise comparisons in
Excel?