Hi there! I have a few questions pertaining to a single dataset that looks like below.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order Date[/TD]
[TD]Brand[/TD]
[TD]Product ID[/TD]
[TD]Customer ID[/TD]
[TD]Supermarket[/TD]
[TD]Sales Volume[/TD]
[TD]Sales Value ($)[/TD]
[/TR]
[TR]
[TD]01/09/2016[/TD]
[TD]Company A[/TD]
[TD]3431[/TD]
[TD]345452[/TD]
[TD]Supermarket B[/TD]
[TD]5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]02/09/2016[/TD]
[TD]Company A[/TD]
[TD]3524[/TD]
[TD]243784[/TD]
[TD]Supermarket B[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]02/09/2016[/TD]
[TD]Company B[/TD]
[TD]3122[/TD]
[TD]345452[/TD]
[TD]Supermarket A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
What formulas should i use to answer the following questions:
1. Average number of orders per customer during [insert month and year e.g. January 2016] at [insert supermarket e.g. Supermarket B]
2. Average number of days between orders of a customer
4. Average number of products per order
Note: I don't intend to use pivot tables and try to manipulate the data as little as possible. Thanks for the help guys and gals!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order Date[/TD]
[TD]Brand[/TD]
[TD]Product ID[/TD]
[TD]Customer ID[/TD]
[TD]Supermarket[/TD]
[TD]Sales Volume[/TD]
[TD]Sales Value ($)[/TD]
[/TR]
[TR]
[TD]01/09/2016[/TD]
[TD]Company A[/TD]
[TD]3431[/TD]
[TD]345452[/TD]
[TD]Supermarket B[/TD]
[TD]5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]02/09/2016[/TD]
[TD]Company A[/TD]
[TD]3524[/TD]
[TD]243784[/TD]
[TD]Supermarket B[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]02/09/2016[/TD]
[TD]Company B[/TD]
[TD]3122[/TD]
[TD]345452[/TD]
[TD]Supermarket A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
What formulas should i use to answer the following questions:
1. Average number of orders per customer during [insert month and year e.g. January 2016] at [insert supermarket e.g. Supermarket B]
2. Average number of days between orders of a customer
4. Average number of products per order
Note: I don't intend to use pivot tables and try to manipulate the data as little as possible. Thanks for the help guys and gals!