Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.misc
|
|||
|
|||
A/B split testing question
Greetings!
im trying to do my first A/B test (http://en.wikipedia.org/wiki/A/ B_testing). so far ive only found http://visualwebsiteoptimizer.com/sp...heet-in-excel/ My question is this though - how do i transform that one so it calculates the various ROIs of multiple ad networks, through multiple ad campaigns, through multiple market segments (oversized women in new york, chicago and los angeles), through various times of the day, through various times of the year? Is such a thing even possible? Many thanks! Tony |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.misc
|
|||
|
|||
A/B split testing question
On Mar 24, 10:13*pm, Tony wrote:
Greetings! im trying to do my first A/B test (http://en.wikipedia.org/wiki/A/ B_testing). so far ive only foundhttp://visualwebsiteoptimizer.com/split-testing-blog/ab-testing-signi... My question is this though - how do i transform that one so it calculates the various ROIs of multiple ad networks, through multiple ad campaigns, through multiple market segments (oversized women in new york, chicago and los angeles), through various times of the day, through various times of the year? Is such a thing even possible? Many thanks! Tony You need to calculate or gather the ROIs for various combinations of the independent variable into a single table with each IV occupying a different column. Then use a Pivot Table. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove split a split window? | New Users to Excel | |||
TESTING | Excel Worksheet Functions | |||
Split UPC Question | Excel Discussion (Misc queries) | |||
Testing | Excel Discussion (Misc queries) | |||
Advanced Window Split & Freeze Question | Excel Worksheet Functions |