We want to find out the personnel who are in top 20% (indicated by Tops!) and lowest 5% salary range (to be indicated by "Lows", otherwise “Middle” in the column under Top/Low). (Use IF function). It is a statistical function.

 

Transcribed Image Text:

123&ST∞ 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22222222 23 24 25 26 27 28 29 A Emp ID 1011 1012 1041 1054 1055 1075 1152 1153 1167 1168 1169 1290 1299 1300 1301 1310 1311 1329 1330 1331 1333 1334 1426 1516 1517 1529 B C Smith Cane Vuanuo Selznick Cash Last Name First Name Department Gorton Hazel Preston Liza Tercan Robert Smith Howard Albert Maxine Kane Sheryl Henders Mark Plant Allen Berwick Sam Asonte Toni Dorfberg Jeremy Cooper Linda Simpson Sandrae Gokarna Phillip Sindole Randy Ellen Nate Tuome Anna Mary Szcznyck Tadeuz Kaneko Midori D Lampstone Pete Bell Tom Karen Kellerman Tommie Quan E Division Accounting Copier Engineering Printer R and D Printer Art Marketing Art Copier Copier Printer Accounting Printer Accounting Printer Marketing Copier Engineering Fax Engineering Copier Admin. Fax Engineering Copier Accounting Printer Marketing Fax Engineering Fax Marketing Printer Engineering Printer Accounting Copier Engineering Printer Engineering Copier R and D Fax Marketing Fax Accounting Printer Engineering Printer Engineering Printer F Salary $27,597.85 $43,394.15 $28,043.68 $25,176.06 $26,040.56 $23,239.44 $26,646.20 $28,043.68 $31,913.88 $63,035.88 $58,002.05 $26,113.86 $34,854.20 $30,451.68 $27,081.04 $32,410.85 $43,486.95 $55,410,85 $31,539.24 $49,872.15 $59,362.20 $28,043.68 $64,689.00 $28,549.50 $75,589.60 $45,146.68 Start Date 2/3/00 1/26/06 4/16/02 4/16/09 4/8/99 8/7/06 1/21/00 1/13/09 4/18/01 4/10/99 10/13/98 1/3/05 12/21/05 12/13/93 8/6/08 10/4/86 9/26/02 2/22/09 2/14/99 5/11/99 4/16/95 4/8/98 9/8/85 3/6/04 2/26/89 1/28/07 H Birth Date 11/21/64 12/2/84 9/21/65 8/9/87 8/20/67 8/28/79 10/23/71 11/3/63 9/28/70 7/8/70 7/12/78 10/1/66 9/16/85 9/24/65 6/25/61 11/2/65 11/13/54 5/6/64 9/23/68 5/21/64 10/7/65 10/18/65 9/23/58 6/26/63 7/7/63 9/10/71 123&ST∞ 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22222222 23 24 25 26 27 28 29 A Emp ID 1011 1012 1041 1054 1055 1075 1152 1153 1167 1168 1169 1290 1299 1300 1301 1310 1311 1329 1330 1331 1333 1334 1426 1516 1517 1529 B C Smith Cane Vuanuo Selznick Cash Last Name First Name Department Gorton Hazel Preston Liza Tercan Robert Smith Howard Albert Maxine Kane Sheryl Henders Mark Plant Allen Berwick Sam Asonte Toni Dorfberg Jeremy Cooper Linda Simpson Sandrae Gokarna Phillip Sindole Randy Ellen Nate Tuome Anna Mary Szcznyck Tadeuz Kaneko Midori D Lampstone Pete Bell Tom Karen Kellerman Tommie Quan E Division Accounting Copier Engineering Printer R and D Printer Art Marketing Art Copier Copier Printer Accounting Printer Accounting Printer Marketing Copier Engineering Fax Engineering Copier Admin. Fax Engineering Copier Accounting Printer Marketing Fax Engineering Fax Marketing Printer Engineering Printer Accounting Copier Engineering Printer Engineering Copier R and D Fax Marketing Fax Accounting Printer Engineering Printer Engineering Printer F Salary $27,597.85 $43,394.15 $28,043.68 $25,176.06 $26,040.56 $23,239.44 $26,646.20 $28,043.68 $31,913.88 $63,035.88 $58,002.05 $26,113.86 $34,854.20 $30,451.68 $27,081.04 $32,410.85 $43,486.95 $55,410,85 $31,539.24 $49,872.15 $59,362.20 $28,043.68 $64,689.00 $28,549.50 $75,589.60 $45,146.68 Start Date 2/3/00 1/26/06 4/16/02 4/16/09 4/8/99 8/7/06 1/21/00 1/13/09 4/18/01 4/10/99 10/13/98 1/3/05 12/21/05 12/13/93 8/6/08 10/4/86 9/26/02 2/22/09 2/14/99 5/11/99 4/16/95 4/8/98 9/8/85 3/6/04 2/26/89 1/28/07 H Birth Date 11/21/64 12/2/84 9/21/65 8/9/87 8/20/67 8/28/79 10/23/71 11/3/63 9/28/70 7/8/70 7/12/78 10/1/66 9/16/85 9/24/65 6/25/61 11/2/65 11/13/54 5/6/64 9/23/68 5/21/64 10/7/65 10/18/65 9/23/58 6/26/63 7/7/63 9/10/71

Answer rating: 100% (QA)

To determine the personnel who are in the top 20 an... View the full answer