X (Ver. BB) Test File v Search NH X AutoSave ( Off A Nidal Hafta File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share G A " ab General iConditional Formatting Insert Arial 10 A =1 AY O $ ~ % " Format as Table Delete ~ Sort & Find & Analyze Sensitivity Paste 308 Cell Styles * Format Filter * Selectv Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity U17 vi X fx R S T U V W B C H K P D E F G J M N 0 Q Pullman BB 2019-2021 Sales Force Analysis AWN- Employee Hire Seniority as of Sick 2019 2020 Change Items Base Total Total Work Performance 2020 2021 Merit 202 2021 Bonus 4 Name Date 1/Jan/23 Days Units Sold Units Sold In Units Prepared Pay Pay Benefits Allow ance Award Compensation Units Rating Compensation Days 5 Harco, Jim 12-Feb-06 4,600 4,810 4,210 Grand, Sally 4-Jan-17 3,150 3.455 5,250 How arty. Bill 29-Jul-00 2.250 2,154 3.675 8 Hiram, Walker 15-Nov-11 4,420 4,750 3,995 Dusty, Steve 11-Sep-13 3,560 3,130 4,560 Total Items Prepared for the company is: Total of 2019 Units Sold that are more than 4,000: Merit Bonus Average 2020 Units Sold for the entire department is: Number of employees with an improvement in Units Sold: Rating Increase Days 0.5% Lowest 2020 units sold: 0.8% Highest 2019 units sold: 2nd Highest Total Benefits: 4th Lowest 2021Units: 20 Median 2021 Compensation: % of employees without an improvement in Units Sold: 5.0% Average 2020 Units of people with Performance Award: | 7.0% 9.0% How many 2020 units does Jim Harco have to sell to get $90,005 in 2021 Compensation? 26 (Do not change the original data) 27 Assignment Sheet + + 74% Ready Accessibility: Good to go 10:05 AM 42 F LOOCHE X ENG Q. Search O O US 2/22/2023 Cloudy