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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!