E3 125% E A Collaborate Format Organize View Zoom Add Category Pivot Table Insert Table Chart Text Shape Media Comment Table Cell Text Arrange + Lookup Dataset Performance Data Questions G H J O A B C D Workplace Violence & Performance Year-End Bonus Last Name Facility Sexual Harassment Bonus Rate Pe Employee ID First Name Base Pay Rating Pe Training Completed $56,897.00 EA441 Linkous Kenan San Francisco, CA Ye $65,234.00 EA4412 Suarez Luis Miami, FL No $51,236.00 EA4413 Zuckerman Mandie Barcelona, ES Yes $59,687.00 Table Styles EA4414 Swartout Shayna San Francisco, CA No $54,852.00 EA4415 Ronaldo Cristiano Miami, FL No $45,896.00 EA4416 Tyler Chun Barcelona, ES Yes $49,875.00 Table Options EA4417 Brown Charlie San Francisco, CA Yes Miami, FL No $39,865.00 EA4418 Jensen John Title EA4419 Vasquez Maria Barcelona, ES Yes $35,698.00 San Francisco, CA No $42,519.00 Caption 11 EA4420 Mckay Horace $45,523.00 EA4421 Lafountain Floyd Miami, FL No $48,527.00 EA4422 Ward Shauna Barcelona, ES Yes Headers & Footer EA4423 Connor San Francisco, CA Yes $51,531.00 Johan EA4424 Hernandez Wendy Miami, FL Yes $54,535.00 $57,539.00 EA4425 Bailey Courtney Barcelona, ES Yes $60,543.00 17 EA4426 Morgan Alex San Francisco, CA Yes Miami, FL $63,547.00 EA4427 Brand Rows 60 Chastain Yes $66,551.00 26 00 EA4428 Mess Lione Barcelona, ES Yes Columns 20 EA4429 Hamm Mia San Francisco, CA Yes $69,555.00 $52,369.00 EA4430 Sanchez Pablo Miami, FL Yes Hope Barcelona, No $49,856.00 22 EA4431 Solo $65,269.00 Table Font Size A A 23 EA4432 Johnson Ricky San Francisco, CA Yes EA4433 Mbappe Kylian Miami, FL Yes $67,542.00 24 25 Serena Barcelona, ES Yes $67,953.00 EA4434 Williams $61,593.00 26 EA4435 Brady Tom Miami, FL Yes Table Outline Patrick Barcelona, ES Yes $41,579.00 EA4436 Mahomes O 1 pt 27 $54,235.00 28 EA4437 Biles simone Miami, FL Yes 29 EA4438 Salah Mohamed Barcelona, ES Yes $59,685.00 Outline Table Title 30 EA4439 da Silva Marta Miami, FL Yes $64,239.00 31 Gridlines 32 33 34 35 36 Alternating Row Color O 37 38 39 Row & Column Size 40 Height 45 pt v Fit Fit AVERAGE 0.255 MIN 0 MAX 0.90 COUNTA 13 Width 93 pt SUM 2.55A 125% E Table Comment Add Category Insert Chart Collaborate Format Organize View Pivot Table Text Shape Media Zoom Table Cell Text Arrange + Lookup Dataset Performance Data Questions M N O O G H K nance Base Pay Bonus Rate Year-End Bonus Performance ng Percentile Performance Score Bonus Rate $56,897.00 .0 $65,234.00 0.25 0.010 w 0.50 .025 $51,236.00 0.045 Table Styles $59,687.00 0.75 0.070 $54,852.00 0.90 $45,896.00 $49 , 875.00 Table Options $39,865.00 Title $35 , 698.00 Caption $42,519.00 $45,523.00 $48 ,527.00 Headers & Footer $51,531.0 $54 ,535.00 $57 ,539.00 $60,543.00 $63,547.00 Rows 60 $66,551.00 Columns 5 20 $69,555.00 121 $52 ,369.00 22 $49,856.00 Table Font Size A A 23 $65,269.00 24 $67,542.00 25 $67,953.00 $61,593.00 Table Outline 26 27 $41,579.00 O 1 pt 28 $54,235.00 Outline Table Title 29 $59,685.00 30 $64,239.00 31 Gridlines 32 33 34 35 36 Alternating Row Color 37 38 39 Row & Column : 40 Height 41 Ov Width SUM 2.55 AVERAGE 0.255 MIN 0 MAX 0.90 COUNTA 13A 125% Collaborate Format Organize View Zoom Add Category Pivot Table Insert Table Chart Text Shape Media Comment Sheet + Lookup Dataset Performance Data Questions Sheet Name Performance Performance Data Employee ID Last Name First Name Facility Rating EA4411 San Francisco, CA 3.60 Linkous Kenan EA4412 Suarez Lui Miami, FL 3.80 EA4413 Zuckerman Mandie Barcelona, ES 3.00 Background EA4414 wartout Shayna San Francisco, CA 2.90 EA4415 Ronaldo Cristiano Miami, FL 3.00 EA4416 4.00 Tyler Chun Barcelona, ES Duplicate Sheet EA4417 Brown Charlie San Francisco, CA 2.50 EA4418 Jensen John Miami, FL 4.31 Delete Sheet EA4419 Vasquez Maria Barcelona, ES 3.92 EA4420 Mckay Horace San Francisco, CA 4.30 EA4421 Lafountain Floyd Miami, FL 4.14 EA4422 Ward Shauna Barcelona, ES 4.15 EA4423 Connor Johan San Francisco, CA 4.40 EA4424 Hernandez Wendy Miami, FI 3.90 EA4425 Bailey Courtney Barcelona, ES 3.48 EA4426 Morgan Alex San Francisco, CA 4.00 EA4427 Chastain Brandi Miami, FL 4.71 EA4428 Mess Lionel Barcelona, ES 5.00 EA4429 Hamm Mia San Francisco, CA 3.50 EA4430 Sanchez Pablo Miami, FL 5.00 EA4431 Solo Hope Barcelona, ES 4.70 EA4432 Johnson Ricky San Francisco, CA 3.75 EA4433 Mbappe Kylian Miami, FL 4.25 EA4434 Williams Serena Barcelona, ES 5.00 EA4435 Brady Tom Miami, FL 5.00 EA4436 Mahomes Patrick Barcelona, ES 4.68 EA4437 Biles Simone Miami, FL 4.57 EA4438 Salah Mohamed Barcelona, ES 4.75 EA4439 da Silva Marta Miami, FL 4.78] 125% v bl :1; Q] W LEJ 69 $ @ View Zoom insert Table Chart Text Shape Media Comment Collaborate Formal Organize + Lookup Dataset Performance Data Sheet Sheet Name MGMT 408: Lookup Functions Activity Scenario: You are working on determining how much each employee should receive as a year-end bonus. You've been given the employee records, their performance scores, and the bonus rates for the year-end bonuses. Complete the following steps to ll in the "Lookup Dataset" sheet and answer the questions below. Questions Background 7 Step 1: The rst step is to get the data from the "Performance Data" sheet into the "Lookup Dataset" sheet. There are several ways we can do this, but to help us practice use the Vlookup or Xlookup formulas. Note, if you are unsure how to do this, refer to the Powerpoint slides for an Excel Formulas. Once you've lled in the entire Performance Rating column in the "Lookup Dataset" sheet, move on to step 2. Duplicate Sheet Step 2: Now that you've inserted the performance data, we need to calculate the average performance rating and standard deviation for thejob Delete Sheet performance ratings. For the average performance score and standard deviation, enter a formula below that will calculate each. To do this, you will need to use the =average and = STDEV.S formulas. Average Performance Score Standard Deviation