Analyze the Results of Your A/B Test

Watch this video, then gather your group around one computer to complete the steps described.

Only one person in your group will do the analysis described in this video.

In this video, you'll analyze the data from your A-B test to determine which poster to use in your group's pitch proposal.

To do this, you'll use a pivot table to count and summarize the votes.

Pivot tables are a quick way to summarize data.

In this case, your pivot table will count how many "yes" and "no" votes each poster received.

Before you start, check your spreadsheet to be sure at least 15 people voted on your posters.

To start, label the columns in your spreadsheet.

Insert a row at the top of the spreadsheet, and name each column.

Then, select the data to use in the pivot table.

Click, hold, and drag to select all of the cells with data.

Then, insert a pivot table.

This creates a table in a new sheet.

Next, select the data to include in the table.

In order to count the total votes for each poster, each row should contain a poster name.

Under rows in the editor, select "Add" and the poster name column.

Then add a column for each vote.

Select "Add" under columns in the editor.

Then select the name of your vote column.

Now that the table is organized, add values to include in the table.

Under the values menu, select add field.

This table should count the number of votes for each item, so select "Vote." Then, summarize by count-A, which counts the number of cells with a value.

Great, now you have a table of "yes" and "no" votes for each poster.

Because the posters are shown randomly, each poster may have a different total number of "yes" and "no" votes.

If this is the case, you'll need to find the percentage of "yes" votes to determine which poster performed best.

Do this in Column E.

Type "equals-- the number of "yes" votes-- divided by the grand total." Press Enter.

Then, drag the cell handle down to copy the formula to the rest of the cells.

Change the Number Format to view these values as a percent.

Now, you can see the percent of "yes" votes that each poster received.

The poster that received the highest percentage "yes" votes is the poster that performed the best.

This is the poster that you'll use in your final proposal.

Now it's your turn: Label your columns.

Add a pivot table.

Select the "Poster Name" as the row and "Vote" as the column.

Add vote values, and summarize by Count-A.

Finally, find the percentage of "yes" votes for each poster to determine the best performing poster.