Create a PivotTable to show the average salary by Region and Job Title Which job in which region has the highest average salary If you were a Registered Nurse, how does the average salary in the South region compare to the other regions LastName FirstName Department Job Title YearHired Region Salary Participates in Retirement Plan Mack Kevin ICU Surgical Tech 2002 North 43,750 Yes Johnson Sue Cardiology Surgical Tech 2010 North 43,945 Yes Lee Kell Cardiology Surgical Tech 2009 West 45,250 Yes Bordeau Katherine ICU Surgical Tech 2010 South 46,561 Yes Young Jeff ICU Surgical Tech 2013 East 47,763 Yes Ball Susan ICU Registered Nurse 2010 East 54,229 No Hill Trevor ICU Registered Nurse 2004 North 56,840 No Scheib Earl ICU Registered Nurse 2010 West 61,639 Yes Garabizien Wendy ICU Registered Nurse 2002 North 62,750 No Blackwell Dean Cardiology Registered Nurse 2009 North 64,047 Yes McKaye Mary ICU Registered Nurse 2002 South 64,750 No Neumann Kenneth Cardiology Registered Nurse 2009 South 66,631 Yes Palermo Tom ICU Registered Nurse 2020 East 67,840 Yes Rais Mary Cardiology Registered Nurse 2001 West 69,750 Yes Weeks Jodie Cardiology Registered Nurse 2015 East 74,302 Yes McKaye Susan ICU Registered Nurse 2012 West 88,229 Yes Jacobson Andrew ICU Physical Therapist 2012 South 68,531 Yes Gao Xiaoming ICU Physical Therapist 2019 West 70,079 No Jacobson Carole ICU Physical Therapist 2010 South 70,531 Yes Smith William ICU Physical Therapist 2006 North 72,079 No Nelsen John Cardiology Physical Therapist 1985 West 79,589 Yes Rothenberger James ICU Physical Therapist 1998 South 86,031 Yes Nelsen Beth Cardiology Physical Therapist 1985 North 86,589 No Chin Ellen Cardiology Physical Therapist 2013 East 98,417 No Smythe Janice ICU Paramedic 2020 North 41,137 No Comensoli Bill Cardiology Paramedic 2017 North 43,875 Yes Garafano Karen Cardiology Paramedic 2021 East 47,250 Yes Comensoli Angela Cardiology Paramedic 2016 West 48,462 Yes Mikkola Claudia Cardiology Paramedic 2014 West 49,531 Yes Halpern Murray Cardiology Paramedic 2009 East 52,250 No Lewis Karl ICU Paramedic 2008 North 52,637 Yes Fitzgerald Edmond ICU Paramedic 2007 East 55,207 No

Question: Create a PivotTable to show the average salary by Region and Job Title. Which job in which region has the highest average salary? If you

Create a PivotTable to show the average salary by Region and Job Title. Which job in which region has the highest average salary? If you were a Registered Nurse, how does the average salary in the South region compare to the other regions?

LastName	FirstName	Department	Job Title	YearHired	Region	Salary	Participates in Retirement Plan
Mack	Kevin	ICU	Surgical Tech	2002	North	43,750	Yes
Johnson	Sue	Cardiology	Surgical Tech	2010	North	43,945	Yes
Lee	Kell	Cardiology	Surgical Tech	2009	West	45,250	Yes
Bordeau	Katherine	ICU	Surgical Tech	2010	South	46,561	Yes
Young	Jeff	ICU	Surgical Tech	2013	East	47,763	Yes
Ball	Susan	ICU	Registered Nurse	2010	East	54,229	No
Hill	Trevor	ICU	Registered Nurse	2004	North	56,840	No
Scheib	Earl	ICU	Registered Nurse	2010	West	61,639	Yes
Garabizien	Wendy	ICU	Registered Nurse	2002	North	62,750	No
Blackwell	Dean	Cardiology	Registered Nurse	2009	North	64,047	Yes
McKaye	Mary	ICU	Registered Nurse	2002	South	64,750	No
Neumann	Kenneth	Cardiology	Registered Nurse	2009	South	66,631	Yes
Palermo	Tom	ICU	Registered Nurse	2020	East	67,840	Yes
Rais	Mary	Cardiology	Registered Nurse	2001	West	69,750	Yes
Weeks	Jodie	Cardiology	Registered Nurse	2015	East	74,302	Yes
McKaye	Susan	ICU	Registered Nurse	2012	West	88,229	Yes
Jacobson	Andrew	ICU	Physical Therapist	2012	South	68,531	Yes
Gao	Xiaoming	ICU	Physical Therapist	2019	West	70,079	No
Jacobson	Carole	ICU	Physical Therapist	2010	South	70,531	Yes
Smith	William	ICU	Physical Therapist	2006	North	72,079	No
Nelsen	John	Cardiology	Physical Therapist	1985	West	79,589	Yes
Rothenberger	James	ICU	Physical Therapist	1998	South	86,031	Yes
Nelsen	Beth	Cardiology	Physical Therapist	1985	North	86,589	No
Chin	Ellen	Cardiology	Physical Therapist	2013	East	98,417	No
Smythe	Janice	ICU	Paramedic	2020	North	41,137	No
Comensoli	Bill	Cardiology	Paramedic	2017	North	43,875	Yes
Garafano	Karen	Cardiology	Paramedic	2021	East	47,250	Yes
Comensoli	Angela	Cardiology	Paramedic	2016	West	48,462	Yes
Mikkola	Claudia	Cardiology	Paramedic	2014	West	49,531	Yes
Halpern	Murray	Cardiology	Paramedic	2009	East	52,250	No
Lewis	Karl	ICU	Paramedic	2008	North	52,637	Yes
Fitzgerald	Edmond	ICU	Paramedic	2007	East	55,207	No

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To solve this problem we will create a PivotTable to display the average salary by Region and Job Title Then well determine which job in which region ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Misfitz Inc. is a small, private company specializing in non-dairy ice cream treats. Aurora and Lokee Pine, a married couple, are the owners of Misfitz and are very hands-on in the running of the...

Use the information on the Employee Data sheet in cells a4:i60 to answer the following three questions. 1. Determine how much the employer will have to contribute to the retirement plan for each...

Create a PivotTable to show the average salary by Region and Job Title. Which job in whith region Employee Data - Questions 1 - 3 Use the information on the Employee Data sheet in cells a 4 :i 6 0 to...

Use the information on the Employee Data sheet in cells a4:i60 to answer the following three questions. Determine how much the employer will have to contribute to the retirement plan for each...

What is the average salary by Gender and Job Title? Do males or females make more money? Is this the same for all Job Titles? Summarize the answers to these questions below your results. (Hint: Using...

Florida Central Hospital System Retirement Plan Employer Contribution Rate 3% LastName FirstName Department Job Title YearHired Gender Salary Participates in Retirement Plan Employer Contribution...

NEED HELP IN EXCEL PLEASE! https://www.dropbox.com/s/wvaz8kc6jhxs6y3/IP_Med_Data.xlsx?dl=0 Scenario You work in the Human Resources Department for Florida Central Hospitals. You've just received some...

With the information I have provided below, can you please provide a concise summary of the RN benefits, pay scale & other relevant requirements on the collective bargaining agreement State of...

can someone help me with this please let me know if you need more info Required information [The following information applies to the questions displayed below.) This Applying Excel worksheet...

Conditional Formatting (a) Create a copy of the Empleyee Salary worksheet and rename the woeksheet as Formatting. (b) Using the Fermatting worksheet, apply a conditional formatting rule to the Net...

I need help with this excel work! I need it in less than an hour please! thank you so much! Wood Hills Animal Clinic August Drug Sales Starting Inventory Drug Advantage Blue Advantage Green Advantage...

Give the implementation of Readers Writer problem using Semaphore.

Davison Industries estimated that it would incur $510,000 in manufacturing overhead in 2017 while working 200,000 direct labor hours. In September 2017, the company actually incurred $50,900 in...

Jamie buys a $ 1 , 0 0 0 bond with a coupon rate of 5 % for $ 8 0 0 . The YTW will be equal to which of the following? A YTM YTD YTL

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".