Generate simplified data from RAW data [Closed]

Report
Posts
1
Registration date
Tuesday October 16, 2018
Status
Member
Last seen
October 16, 2018
-
Posts
2621
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 28, 2020
-
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 reply

Posts
2621
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 28, 2020
420
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