How do you calculate PERCENTAGES AND AVERAGE SALARY FOR MALE AND FEMALE. PLEASE REFER TO THE PHOTOS BELOW AND PLEASE PROVIE AND SHOW THE FORMULA.

5. Create Executive Summary Create the layout shown below to summarize salary history analysis from the sample dataset file provided in this project. Be sure to match this formatting as much as possible Data Analysis Create a new sheet named Data Analysis. Refer to Figure 1 and replicate this formatting to your Data. Analysis, sheet. Once you have accomplished this, populate the blank cells using appropriate functions. Below are helpful hints to support your effort. To answer the Top 10 Highest Paid Positions section, pivot tables from section 4 of this project are required. Use linked references to populate results for male vs. female. DATA ANALYSIS SALARY COMPARISON REPORT Total number of male employees Total number of female employees Total number of employees SALARY BRACKET COUNT PERCENTAGE SALARY BRACKET MALE FEMALE MALE FEMALE $20,000-$50,000 $50,001 $100,000 $100,001 $200,000 $200,001 $300,000 $300,001-$400,000 AVERAGE SALARY BY OCCUPATION COUNT AVERAGE SALARY FEMALE OCCUPATION MALE FEMALE MALE Stocking Associate Inventory Retrieving Associate Customer Service Representative Category Manager TOP 10 HIGHEST PAID POSITIONS SALARY OCCUPATION MALE FEMALE Sr. VP Sales & Marketing Chief Legal Officer Corporate Legal Sr. VP Operations Chairman Holding General Counsel CFO NA Region VP International VP Marketplace VP Admin Sales and Mictg Sr Dir Corporate Engineer Figure 1- Data Analysis (Executive Summary) Important Note: To receive full credit, Excel functions must be used for each required field in the data analysis. This means that no hard-coded numbers should show in the formula bar Helpful Hints Total number of male employees: =COUNTIF Total number of female employees: -COUNTIF Total number of employees: -SUM Male/Female count: -COUNTIFS e.g., COUNTIFS(range,">X",range,"X",range,"