Question: 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
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.\table[[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]]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
