A tool to analyze multidimensional tabular data I have a bunch of data in the following format:

Count|| Fruit  |Fruit Col.|| Veget. |Veg.Col.|| Spice    
---------------------------------------------------------
 123 || Apple  | Red      || Carrot | Orange || Cumin   
  20 || Apple  | Red      || Carrot | Green  || Pepper  
... 20K more combinations...
   1 || Orange | Orange   || Potato | White  || Allspice

This is to be read as follows: Red apples in combination with orange carrots and cumin were encountered 123 times during the experiment.
I need to be able to answer at least following questions about the dataset:


*

*What are the most popular spices for the most popular vegetables among the most popular fruits, (a) with and (b) without the regard for the color of either?

*Which color of potatoes is encountered most often along with the most popular vegetable?

*What is the most popular red fruit that is encountered with green vegetable?
Etc.
"Most popular" here assumes answer like:


*

*5% Apple

*4% Orange

*1% Others


Please suggest a tool which will allow me to analyze my dataset in the way I described above. 
Ideally the tool should not require me to write complicated code to ask the specific question (some coding beforehand is acceptable). A tool that will do what I need without coding would be perfect.
 A: Not to over simplify this but I reckon you could do everything you ask for using MS Excel. The 'SumIfs' feature allows you to count how many times sometime appears given certain criteria. Based on the data shown (and assuming I understand the question correctly), the question is: which spice is most commonly found with the vegetable most commonly found with a given fruit. So if apples are the most common fruit, and carrots are most commonly found with apples then you're asking what spice is found with the combination of apples and carrots.
So using excel you'd probably want to break it into a few steps:
1) Use SUMIF to calculate how many of each fruit is found.
2) Use SUMIFS to calculate how many of each vegetable is found with each fruit (making a table with fruit in rows and veg in columns for example)
3) Finally an even longer SUMIFS formula to find add all the counts for all the spices for each fruit and veg (can't really make a single table for this as it would need to be a 3D array but you could make multiple tables if you require all the data as opposed to selecting the values based on the previous table).
Finally if you want answers in percentages of the total then you can simply SUM the 'count' column, divide all answers by this number and then multiply by 100! This should require no coding at all, just an easy to read layout in excel and 3 or 4 formulas. Please ask if anything here is ambiguous.
SUMIFS: http://office.microsoft.com/en-gb/excel-help/sumifs-function-HA010047504.aspx
