Please use the data in the photos below to answer the following questions, thank you very much!
1. Determine the average customer order amount.
2. Which sales region has the highest average customer order amount? The lowest?
3A. Determine the customer ID number and average order amount for the three customers with the highest average order amount.
3B. Determine the customer ID number and average order amount for the three customers with the lowest average order amount.
4A. Determine the customer ID number and number of orders for the two customers with the highest number of orders.
4B. Determine the customer ID number and number of orders for the two customers with the lowest number of orders.
Data Table
CustomerID
OrderID
Region
OrderDate
Amount
ShipDate
17
98
East
11/25/22
$39.32
11/28/22
25
99
West
11/25/22
$43.05
11/27/22
9
100
East
11/26/22
$39.89
11/28/22
36
101
Central
11/27/22
$49.66
12/04/22
13
102
East
11/27/22
$29.23
12/02/22
9
103
East
11/27/22
$17.33
12/02/22
2
104
East
11/27/22
$28.64
12/01/22
29
105
West
11/27/22
$52.68
12/01/22
31
106
Central
11/28/22
$67.94
12/02/22
26
107
West
11/28/22
$74.55
12/02/22
9
108
East
11/28/22
$39.62
12/01/22
25
109
West
11/29/22
$47.60
12/03/22
15
110
East
11/29/22
$3.00
12/03/22
33
111
Central
11/29/22
$82.59
12/02/22
38
112
Central
11/29/22
$90.53
12/02/22
4
113
East
11/30/22
$28.01
12/04/22
3
114
East
11/30/22
$59.73
12/04/22
24
115
West
11/30/22
$31.58
12/03/22
3
116
East
11/30/22
$37.74
12/03/22
Leave a Reply