Generate simplified data from RAW data

Closed
damonlin Posts 1 Registration date Tuesday October 16, 2018 Status Member Last seen October 16, 2018 - Oct 16, 2018 at 03:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 16, 2018 at 11:41 AM
Hello guys,
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

A thousand thanks in advanced!

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 16, 2018 at 11:41 AM
HI Damonlin,

With the limited amount of data you provided I can only advise you to dive into Pivot Tables. They are meant to analyse data.

To get you started have a look at the following link:
https://exceljet.net/pivot-table-tips

Best regards,
Trowa