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 columnE.
In E2, type equals C2--the number of yes votes--divided by D2--the grand total.
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.