Thread: New Tool Album
View Single Post
Neel's Avatar Neel
06-06-2011, 01:18 PM
Reply With Quote

Quote:
Originally Posted by crincled View Post
edit: tell me more about your multiplication table...
I'm currently working on a project which generates a price sensitive forecast for a major cruise line company. For my portion of the project, we wanted to pick 5 different key variables, segment the data by every combination of those variables (all of them, all combinations of 4 of them, etc.), and see how the results turned out for each one. I accomplished this by loading all of the possible segmentation levels into a table in oracle which our statistical package then interpreted (replacing variables with nulls, thus making segmentation by said variables irrelevant).

To construct the table, I first created a row where all were marked as "Y." The only ones I toggle are in the middle (switch from white to green). I then copied that one row and swapped the first cell that I want toggled (making it white). I then copied both of those rows, pasted them back, and swapped the second column for that new block (switching it to white). I repeated this process for each variable I wanted swapped, doubling the size of the table each time. The result is a cool fractal-ish ("ish" might not be necessary if this is actually considered a fractal) table that includes every possible combination of my variables in a format that I can use and with very little work required on my part.

Here is a pic:

For fun, I also tried it with three possible states for each variable (1,2,3 rather than Y/N) and used conditional formatting to assign colors based on the color of each cell (same thing that I did here, but with an additional color). It also looked pretty sweet.

Last edited by Neel; 06-06-2011 at 01:20 PM..
Old 06-06-2011, 01:18 PM   #311
Just chillin
 
Neel's Avatar
 
Join Date: Apr 2006
Location: Atlanta
Posts: 1,540
Bincount™: 16
Re: New Tool Album

Quote:
Originally Posted by crincled View Post
edit: tell me more about your multiplication table...
I'm currently working on a project which generates a price sensitive forecast for a major cruise line company. For my portion of the project, we wanted to pick 5 different key variables, segment the data by every combination of those variables (all of them, all combinations of 4 of them, etc.), and see how the results turned out for each one. I accomplished this by loading all of the possible segmentation levels into a table in oracle which our statistical package then interpreted (replacing variables with nulls, thus making segmentation by said variables irrelevant).

To construct the table, I first created a row where all were marked as "Y." The only ones I toggle are in the middle (switch from white to green). I then copied that one row and swapped the first cell that I want toggled (making it white). I then copied both of those rows, pasted them back, and swapped the second column for that new block (switching it to white). I repeated this process for each variable I wanted swapped, doubling the size of the table each time. The result is a cool fractal-ish ("ish" might not be necessary if this is actually considered a fractal) table that includes every possible combination of my variables in a format that I can use and with very little work required on my part.

Here is a pic:

For fun, I also tried it with three possible states for each variable (1,2,3 rather than Y/N) and used conditional formatting to assign colors based on the color of each cell (same thing that I did here, but with an additional color). It also looked pretty sweet.

Last edited by Neel; 06-06-2011 at 01:20 PM..
OFFLINE |   Reply With Quote