i need help to create some magic from excel.
I am a marketer for a F&B, and right now i am in the mid of trying to generate some precious, juicy information from our customers' purchasing behaviour. I know it might be possible using excel, but I have no idea how to.
The situation goes:
what i ultimately look for, is a big chunk of table that can generate all sort of conclusions base from my raw data. for example:
how many people order a food, AND order a drink.
While how many people order a food, AND not ordering a drink.
If i can see a deeper breakdown like,
food A, 50% of the time customer also buy a drink,
food B, only 10% of the time customer also buy a drink.
that would be great.
My raw data that is available to use:
1. order number
2. order timing
3. type of food ordered
4. quantity of each food ordered