Answer the following question. Please use excel functions to show your work 1. (5 points) How many unique suppliers are in the dataset? 2. (5 points)What is the most expensive item by cost in the dataset? 3. (5 points) Accounts payable (AP) refer to the obligations incurred by a company during its operations that remain due and must be paid in the short term. What is an average A/P term for all observations in the dataset? 4. (10 points) Airframe fasteners are standard fastening hardware made specifically for use in aircraft construction and repair. How much on average does a company pay for one unit of Airframe fastener? (hint: please use an appropriate central measurement) 5. (10 points) A company considers a supplier "Critical" if the total spend with a supplier exceeds $500,000. Please list all critical suppliers. 6. (10 points) Build a \% cumulative frequency distribution for the "Cost of Order" variable. How often the cost of order exceeds $100,000. Hint: use grouping function as following