Assignment has been started i just need you to answer on of the kpi questions not answered in the form of a chart similar to the already created one in the pbix form.

Question 2 Use COUNTIF to answer the following question: How many records meet the following criteria: Day of Month is more than 15. (Format as comma style 0 decimal) Question 3 Use AVERAGEIFto answer the following question: What is the average Eating and Drinking at Airport for records that meet the following criteria?: Gender is…

Please see the attached documents to complete the assignment. Textbook (Not Required but recommended): Cost-Benefit Analysis: Concepts and Practice (4th Edition) by Anthony E. Boardman, David H. Greenberg, Aidan R. Vining, and David L. Weimer, Prentice Hall, Inc., Upper Saddle, NJ, 2011 (ISBN-10: 0137002696). Include additional resources.

Check attachments for instructions for data analysis 3. I have completed data analysis 1 and 2 if you might need what was done you can ask.