the above chart is what I have already done below is the complete…
Question Answered step-by-step the above chart is what I have already done below is the complete… Image transcription textQ23 JX A B C D E F G H I J K L M N O P Q 1 Business Analyst Table Summary Title Java- Name V Gende AgeYrs Java Python C# R PHP Script Ruby Count Total count of woman N W Bhua, Li M 21 IN Y N N N N Totalcount of man < << Kadafi, Kim M 22 N Z N Average age of women Kidd, Laura F 23 < < &... Show more... Show more the above chart is what I have already done below is the complete question from class I already filled in the data in the above chart I just don't understand what the I suppose to put after countif( averageif and medianCreate a Summary title and row headings in cell N1. Merge and center N1:Q1N2Total count of womanN3Total count of manN4Average age of womenN5Average age of menN6Median age of all consultantsN7Average years of experienceN8 Total years of Java experience (all consultants) Use the COUNTIF function for males and femalesUse the AVERAGEIF function the average agesUse the MEDIAN function to find the median age of all consultants Engineering & Technology Computer Science GNBS MISC Share QuestionEmailCopy link Comments (0)
