Hello, I am looking to see if someone can help to an Excel Independent Project.

Please see files attached.

EXCEL INDEPENDENT PROJECT B INSTRUCTIONS This project is not found in your book. Use what you have learned so far in the course and apply critical thinking skills to stretch the limits of your knowledge. Read the assignment instructions carefully below or from Excel_Independent_Project_B_Instructions.pdf . Compare your results to the grading rubric before submitting. Open the IPB_Faculty_Data.xlsx file attached below. Save the file as Lastname_Firstname_IPB_Faculty_Data.xlsx. You work in the Human Resources Department for Laurel College. You've just received some data about Faculty members and have been given the task of analyzing this data. (Note: Because I have to see your results for each question for grading purposes, the data has been duplicated on three separate sheets one for each question. In real life, you would only keep data in one list.) Format and prepare all sheets for printing as you will be distributing copies to your management team. Format the sheets using any theme, colors, font or table style you like as long as the results are professional looking. Make sure all data is set to print in an easily readable format. Set print titles where needed so all data on each page is clearly identified. Manipulate the data on each sheet to show your results for the three questions below. 1. What is the average salary by Gender and Rank? Do males or females make more money? Is this the same for all ranks? Summarize the answers to these questions below your results. 2. Prepare a report showing the records and total number of faculty in the Finance and Accounting Departments who have worked here 10 years or more. Sort the list by Rank in order of seniority* (Full Prof, Instructor, Associate, Assistant) and then by Year Hired in Ascending (smallest to largest) order. Do not display (hide) the Salary column as this information is confidential. *Use custom sort. See page 287. 3. Determine how much the employer will have to contribute to the retirement plan for each department. Add conditional formatting to highlight the top 5 salaries. Highlight the lowest 5 salaries using a different formatting style. (Hints: Add a field to the right in column i that calculates the Employers Contribution Amount to the Retirement Fund. If employees said Yes to participation, multiply the Salary times the Employers Contribution percentage shown. The contribution is zero for employees who said No to participation. Once you have calculated the contribution amounts, then find the totals for each department.) Grading Rubric: Your work will be graded on the following scale: Description Points All sheets are formatted professionally. Numbers are right aligned and formatted with appropriate number style. Borders, colors, fonts etc. are used appropriately so data is clear and easy to read. 5 All sheets are set to print. Headers with name, filename and sheet name are included on all sheets. 5 Question 1: Average Salary is shown by Gender and by Rank. Results will update if data is sorted or edited. 20 Results are summarized to answer questions. 5 Question 2: Only Finance and Accounting faculty are shown. 5 Records are sorted by seniority (Full Prof, Instructor, Associate, Assistant) and by Year Hired. 10 Only employees who were hired 10 or more years are shown. 10 Salary column is hidden. 5 Total number of faculty is shown. 5 Question 3: Column added to calculate employers required contribution to retirement plan. 10 Totals are shown by department for contributions. 10 Conditional formatting is added to show 5 highest salaries. 5 Conditional formatting is added to show 5 highest salaries. 5 Total Points 100 After completing the assignments, attach the Lastname_Firstname_IPB_Faculty_Data .xlsx and submit for grading. Laurel College Faculty List LastName Anderson Ball Ball Blackwell Bordeau Bressette Chin Chin Coats Coats Comensoli Comensoli Doepke Downs Fitzgerald Gao Garabizien Garafano Halpern Halpern Hill Jackson Jackson Jacobson Jacobson Johnson Lee Lewis Lu Mack McKaye McKaye Mikkola Nelsen Nelsen Nelson Neumann Orr Palermo Palermo Parker Parker Rais Rais Rothenberger Scheib Smith Smith Smythe Stewart True Weaver Weaver Weeks Wolter Young FirstName Kristen Robin Susan Dean Katherine Cheryl Ellen Roger Bill William Angela Bill Cheryl Clifton Edmond Xiaoming Wendy Karen Murray Sheryl Trevor Carole Mary Andrew Carole Sue Kell Karl Jim Kevin Mary Susan Claudia Beth John Dale Kenneth Ellen Sheryl Tom Mathew Tom Mary Wendy James Earl Alicia William Janice Mark David Robert Roger Jodie Christine Jeff Department Accounting Accounting Management Finance Management Accounting Finance Accounting Accounting Accounting Finance Finance Accounting Accounting Management Management Management Finance Finance Accounting Management Accounting Accounting Management Management Finance Finance Management Accounting Management Management Management Finance Finance Finance Accounting Finance Accounting Accounting Management Accounting Accounting Finance Accounting Management Management Accounting Management Management Accounting Accounting Accounting Accounting Finance Accounting Management Rank Assistant Instructor Instructor Instructor Assistant Instructor Full Prof Full Prof Assistant Assistant Associate Associate Full Prof Associate Associate Full Prof Instructor Associate Associate Full Prof Instructor Instructor Instructor Full Prof Full Prof Assistant Assistant Associate Instructor Assistant Instructor Instructor Associate Full Prof Full Prof Full Prof Instructor Full Prof Associate Instructor Full Prof Instructor Instructor Full Prof Full Prof Instructor Full Prof Full Prof Associate Assistant Full Prof Full Prof Associate Instructor Associate Assistant YearHired Gender 2013 F 2004 F 2010 F 2000 M 1994 F 1995 F 2013 M 2011 M 1998 M 2013 M 2008 F 2005 F 1986 F 1990 M 2010 M 1990 M 2002 F 1987 F 2009 M 2013 M 1999 M 2006 F 2000 F 2012 M 2010 M 2010 F 2002 M 1987 M 2011 M 1997 M 2002 F 1997 F 1984 F 1985 F 1985 F 1996 M 2009 M 2005 F 2008 F 2013 M 1982 M 2010 F 2001 F 2004 M 1998 M 1997 M 1997 F 2006 M 2007 F 2007 M 1994 M 1984 M 1996 F 1996 F 1991 F 1998 M Salary 47,405 39,973 38,229 42,047 46,561 40,832 61,417 63,531 49,621 49,621 48,462 48,462 56,355 51,137 53,007 60,079 32,750 50,250 50,250 63,531 39,840 38,031 38,031 60,531 60,531 50,000 45,250 52,637 43,131 46,750 32,750 38,229 60,531 56,589 56,589 58,828 39,631 100,000 49,867 39,840 62,142 39,973 31,250 60,025 66,031 41,639 54,205 60,079 51,137 51,866 57,431 60,025 49,867 37,302 49,168 47,763 Laurel College Faculty List LastName Anderson Ball Ball Blackwell Bordeau Bressette Chin Chin Coats Coats Comensoli Comensoli Doepke Downs Fitzgerald Gao Garabizien Garafano Halpern Halpern Hill Jackson Jackson Jacobson Jacobson Johnson Lee Lewis Lu Mack McKaye McKaye Mikkola Nelsen Nelsen Nelson Neumann Orr Palermo Palermo Parker Parker Rais Rais Rothenberger Scheib Smith Smith Smythe Stewart True Weaver Weaver Weeks Wolter Young FirstName Kristen Robin Susan Dean Katherine Cheryl Ellen Roger Bill William Angela Bill Cheryl Clifton Edmond Xiaoming Wendy Karen Murray Sheryl Trevor Carole Mary Andrew Carole Sue Kell Karl Jim Kevin Mary Susan Claudia Beth John Dale Kenneth Ellen Sheryl Tom Mathew Tom Mary Wendy James Earl Alicia William Janice Mark David Robert Roger Jodie Christine Jeff Department Accounting Accounting Management Finance Management Accounting Finance Accounting Accounting Accounting Finance Finance Accounting Accounting Management Management Management Finance Finance Accounting Management Accounting Accounting Management Management Finance Finance Management Accounting Management Management Management Finance Finance Finance Accounting Finance Accounting Accounting Management Accounting Accounting Finance Accounting Management Management Accounting Management Management Accounting Accounting Accounting Accounting Finance Accounting Management Rank Assistant Instructor Instructor Instructor Assistant Instructor Full Prof Full Prof Assistant Assistant Associate Associate Full Prof Associate Associate Full Prof Instructor Associate Associate Full Prof Instructor Instructor Instructor Full Prof Full Prof Assistant Assistant Associate Instructor Assistant Instructor Instructor Associate Full Prof Full Prof Full Prof Instructor Full Prof Associate Instructor Full Prof Instructor Instructor Full Prof Full Prof Instructor Full Prof Full Prof Associate Assistant Full Prof Full Prof Associate Instructor Associate Assistant YearHired Gender 2013 F 2004 F 2010 F 2000 M 1994 F 1995 F 2013 M 2011 M 1998 M 2013 M 2008 F 2005 F 1986 F 1990 M 2010 M 1990 M 2002 F 1987 F 2009 M 2013 M 1999 M 2006 F 2000 F 2012 M 2010 M 2010 F 2002 M 1987 M 2011 M 1997 M 2002 F 1997 F 1984 F 1985 F 1985 F 1996 M 2009 M 2005 F 2008 F 2013 M 1982 M 2010 F 2001 F 2004 M 1998 M 1997 M 1997 F 2006 M 2007 F 2007 M 1994 M 1984 M 1996 F 1996 F 1991 F 1998 M Salary 47,405 39,973 38,229 42,047 46,561 40,832 61,417 63,531 49,621 49,621 48,462 48,462 56,355 51,137 53,007 60,079 32,750 50,250 50,250 63,531 39,840 38,031 38,031 60,531 60,531 50,000 45,250 52,637 43,131 46,750 32,750 38,229 60,531 56,589 56,589 58,828 39,631 100,000 49,867 39,840 62,142 39,973 31,250 60,025 66,031 41,639 54,205 60,079 51,137 51,866 57,431 60,025 49,867 37,302 49,168 47,763 Laurel College Faculty List Retirement Plan Employer Contribution Rate LastName Anderson Ball Ball Blackwell Bordeau Bressette Chin Chin Coats Coats Comensoli Comensoli Doepke Downs Fitzgerald Gao Garabizien Garafano Halpern Halpern Hill Jackson Jackson Jacobson Jacobson Johnson Lee Lewis Lu Mack McKaye McKaye Mikkola Nelsen Nelsen Nelson Neumann Orr Palermo Palermo Parker Parker Rais Rais Rothenberger Scheib Smith Smith Smythe Stewart True Weaver Weaver Weeks Wolter Young FirstName Kristen Robin Susan Dean Katherine Cheryl Ellen Roger Bill William Angela Bill Cheryl Clifton Edmond Xiaoming Wendy Karen Murray Sheryl Trevor Carole Mary Andrew Carole Sue Kell Karl Jim Kevin Mary Susan Claudia Beth John Dale Kenneth Ellen Sheryl Tom Mathew Tom Mary Wendy James Earl Alicia William Janice Mark David Robert Roger Jodie Christine Jeff Department Accounting Accounting Management Finance Management Accounting Finance Accounting Accounting Accounting Finance Finance Accounting Accounting Management Management Management Finance Finance Accounting Management Accounting Accounting Management Management Finance Finance Management Accounting Management Management Management Finance Finance Finance Accounting Finance Accounting Accounting Management Accounting Accounting Finance Accounting Management Management Accounting Management Management Accounting Accounting Accounting Accounting Finance Accounting Management Rank Assistant Instructor Instructor Instructor Assistant Instructor Full Prof Full Prof Assistant Assistant Associate Associate Full Prof Associate Associate Full Prof Instructor Associate Associate Full Prof Instructor Instructor Instructor Full Prof Full Prof Assistant Assistant Associate Instructor Assistant Instructor Instructor Associate Full Prof Full Prof Full Prof Instructor Full Prof Associate Instructor Full Prof Instructor Instructor Full Prof Full Prof Instructor Full Prof Full Prof Associate Assistant Full Prof Full Prof Associate Instructor Associate Assistant YearHired Gender 2013 F 2004 F 2010 F 2000 M 1994 F 1995 F 2013 M 2011 M 1998 M 2013 M 2008 F 2005 F 1986 F 1990 M 2010 M 1990 M 2002 F 1987 F 2009 M 2013 M 1999 M 2006 F 2000 F 2012 M 2010 M 2010 F 2002 M 1987 M 2011 M 1997 M 2002 F 1997 F 1984 F 1985 F 1985 F 1996 M 2009 M 2005 F 2008 F 2013 M 1982 M 2010 F 2001 F 2004 M 1998 M 1997 M 1997 F 2006 M 2007 F 2007 M 1994 M 1984 M 1996 F 1996 F 1991 F 1998 M Participates in Salary Retirement Plan 47,405 Yes 39,973 No 38,229 Yes 42,047 Yes 46,561 Yes 40,832 Yes 61,417 No 63,531 No 49,621 Yes 49,621 Yes 48,462 Yes 48,462 Yes 56,355 Yes 51,137 Yes 53,007 No 60,079 No 32,750 No 50,250 Yes 50,250 No 63,531 Yes 39,840 No 38,031 No 38,031 Yes 60,531 Yes 60,531 Yes 50,000 Yes 45,250 Yes 52,637 Yes 43,131 Yes 46,750 Yes 32,750 No 38,229 Yes 60,531 Yes 56,589 No 56,589 Yes 58,828 Yes 39,631 Yes 100,000 Yes 49,867 Yes 39,840 Yes 62,142 Yes 39,973 Yes 31,250 Yes 60,025 Yes 66,031 Yes 41,639 Yes 54,205 Yes 60,079 No 51,137 No 51,866 Yes 57,431 No 60,025 Yes 49,867 No 37,302 Yes 49,168 Yes 47,763 Yes 3%