Skip to content

7. Analyze the Results of your A|B Test

Playback Speed:
Transcript

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

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

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

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.

To start, label the columns.

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.

Select “data” and “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 report editor, select “Add field” and the poster name column.

Then add a column for each vote.

Select “add field” under columns in the report 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, select “summarize by” and “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 total votes to determine which poster performed best.

Do this in column E.

In E2, type equals C2 -- the number of yes votes -- divided by D2--the total number of votes for that poster.

Press enter.

Then click the cell handle and apply the formula to cells E3 and E4.

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 of 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 “counta” Finally, find the percentage of yes votes for each poster to determine the best performing poster.

Next
Instructions
  1. Label your columns.
  2. Add a pivot table.
  3. Select the poster name as the row and "vote" as the column
  4. Add vote values, and summarize by "counta"
  5. Finally, find the percentage of yes votes for each poster to determine the best performing poster.