Formula or Algorithm? find "average" shopping cart of 10 different items being sold
Hi all!
I am trying to figure out the "average" shopping cart of 10 different items I sell. I can get info for around 100 shoppers, so I am trying to figure out how create a profile of my "typical shopper" who completes a transaction.
The shoppers each have made a purchase of some quantity of each of the 10 items I offer.
So for example, a shopper might have purchased 3 t-shirts, 2 books, and 5 pins, and none of the other 7 items.
I know I can look at my records and see the average number of each item that was purchased across all 100 shoppers and see what inventory was sold. But that doesn't tell me what the average shopping cart looked like. Right?
So for example, let's say I sold 50 books, 20 "combo sets", and 30 tote bags from the 100 shoppers. It doesn't make sense to me to take the individual average of each item, because people don't usually buy these particular items together (2 books and a totebag are included in the combo.)
Also, it doesn't make sense to me to say that out of 100 shoppers, my average shopper buys .5 books, .2 combo sets, and .3 tote bags. That's not a real purchase...
I'm trying to find out what combination of items and what quantity the shopper has in the cart when they make their purchase so I can say something like, "my typical shopper who makes a purchase is going to have 3 t-shirts and 2 pins in their cart."
Is there a way for me to calculate this with a formula on my spreadsheet or do I have to use some kind of algorithm?
Thanks!
Hi all!
I am trying to figure out the "average" shopping cart of 10 different items I sell. I can get info for around 100 shoppers, so I am trying to figure out how create a profile of my "typical shopper" who completes a transaction.
The shoppers each have made a purchase of some quantity of each of the 10 items I offer.
So for example, a shopper might have purchased 3 t-shirts, 2 books, and 5 pins, and none of the other 7 items.
I know I can look at my records and see the average number of each item that was purchased across all 100 shoppers and see what inventory was sold. But that doesn't tell me what the average shopping cart looked like. Right?
So for example, let's say I sold 50 books, 20 "combo sets", and 30 tote bags from the 100 shoppers. It doesn't make sense to me to take the individual average of each item, because people don't usually buy these particular items together (2 books and a totebag are included in the combo.)
Also, it doesn't make sense to me to say that out of 100 shoppers, my average shopper buys .5 books, .2 combo sets, and .3 tote bags. That's not a real purchase...
I'm trying to find out what combination of items and what quantity the shopper has in the cart when they make their purchase so I can say something like, "my typical shopper who makes a purchase is going to have 3 t-shirts and 2 pins in their cart."
Is there a way for me to calculate this with a formula on my spreadsheet or do I have to use some kind of algorithm?
Thanks!