We want to find out the personnel who are in top 20% (indicated by Tops!) and lowest
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
To determine the personnel who are in the top 20 an... View the full answer
Related Book For
Mathematical Statistics with Applications in R
ISBN: 978-0124171138
2nd edition
Authors: Chris P. Tsokos, K.M. Ramachandran
Posted Date:
Students also viewed these mathematics questions
-
You and a business partner opened a fitness gym three years ago. Your partner oversees managing the operations of the gym, ensuring the right equipment is on hand, maintenance is conducted, and the...
-
In this mini-case, you will determine overall materiality as well as tolerable misstatement amounts for balance sheet accounts of EarthWear Clothiers, Inc. Most auditing firms use a simple approach...
-
Develop an Excel model for Robert's Chiropractic Clinic - use the scenario provided below. Robert Berns runs a Chiropractic Clinic in Belle Jardin in St. Louis. His annual fixed operating costs are...
-
On July 1, 2021, Katrina purchased tax-exempt bonds (face value of $75,000) for $82,000. The bonds mature in five years, and the annual interest rate is 3%. a. How much interest income and/or...
-
Approximate the solution to the wave equation 2u / t2 2u / x2 = 0, 0 < x < 1, 0 < t; u(0, t) = u(1, t) = 0, 0 < t, u(x, 0) = sin 2x, 0 x 1, u / t (x, 0) = 2 sin 2x, 0 x 1, using Algorithm 12.4...
-
Randall and Dianne Wall live in St. Louis, Missouri. Randall and Dianne are each 30 years old, neither smokes, and they have no children or other dependents Randall is attending law school full time...
-
The effluent from a reactor contains a mixture of various chlorinated derivatives of the hydrocarbon \(\mathrm{RH}_{3}\), together with the hydrocarbon itself and \(\mathrm{HCl}\). Based on the...
-
The 21st Century Studios is about to begin the production of its most important (and most expensive) movie of the year. The movies producer, Dusty Hoffmer, has decided to use PERT/CPM to help plan...
-
Following are preacquisition financial balances for Padre Company and Sol Company as of December 31. Also included are fair values for Sol Company accounts. Cash Padre Company Book Values 12/31 Sol...
-
Southwick Company uses normal costing in its job- costing system. Partially completed T- accounts and additional information for Southwick for 2012 are as follows: Required Additional information...
-
If there is coverage a of 400,000 and a replacement value of 100,000 what does this mean for a homeowners insurance policy, the value of the house is now up to 800,000
-
Delete 55, 38 and 35 from following BST. (35 20 22) 25 41 38 (30 36 SO 46 60 SS
-
1. The remaining lifetime of an individual in years is discrete uniform with a = 1 and b = 50. If an insurance product offers k if the individual dies in discrete year k (e.g., if they die in the...
-
1. Calculate the holding period return for the following two investments: Purchase Price (begining of the Stocks 5,000 Bonds 2,00 Annual Dividend 250 Annual Interest Income 200 Sale Price (end of the...
-
In a study of Van der Waals forces between particles and surfaces, Electric double layer forces, DLVO forces, Polymer-mediated steric forces, and Depletion forces: 1. Derive an expression for the...
-
Your friend has been investing $4000 in stock at the end of every year for the past 8 years. If the account is currently worth $45,000, what was their annual return on this investment?
-
What minimum number of 60 W lightbulbs must be connected in parallel to a single 180 V household circuit to trip a 36.0 A circuit breaker? lightbulbs Need Help? Read It Submit Answer
-
Evenflow Power Co. is considering a new project that is a little riskier than the current operations of the company. Thus, management has decided to add an additional 1.5% to the company's overall...
-
Suppose a dating service wants to schedule dates for four women, Anna, Carol, Judy, and Nancy, with Ed, John, Marcus, and Richard on Thursday, Friday, Saturday, and Sunday in such a way that each man...
-
If P (B) > 0, (a) Show that P(A | B) + P(Ac | B) = 1. (b) Show that in general the following two statements are false: (i) P(A | B) + P (A | Bc) = 1, (ii) P(A | B) + P(Ac | Bc) = 1.
-
Let X 1 , . . . ,X n1 be a random sample from an N ( 1 , 2 ) distribution and let Y 1 , . . . ,Y n2 be a random sample from a N ( 2 , 2 ) distribution. Show that the pooled estimator Is unbiased...
-
Why is it important to pay attention to cultural differences when interviewing a client?
-
What does the term "unauthorized practice of law" mean, and how does it limit your relationship with a client?
-
Why is it important to acknowledge how a client is feeling at the initial interview?
Study smarter with the SolutionInn App