Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using criteria range: What is the VARIANCE of the salary of Copier division personnel who have been with company for at least 10 years but
Using criteria range: What is the VARIANCE of the salary of Copier division personnel who have been with company for at least 10 years but less than 15 years?
Please just provide the formula necessary for solving the question. I don't need the actual answer.
A B D E F G H Emp ID 1011 1012 1041 Start Date 2/3/00 1/26/06 4/16/02 Birth Date 11/21/64 12/2/84 1054 1055 1075 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 4/16/09 4/8/99 8/7/06 1/21/00 Art 9/21/65 8/9/87 8/20/67 8/28/79 10/23/71 11/3/63 9/28/70 1152 1153 1167 1168 1169 Last Name First Name Department Division Gorton Hazel Accounting Copier Preston Liza Engineering Printer Tercan Robert Rand D Printer Smith Howard Art Copier Albert Maxine Marketing Copier Kane Sheryl Printer Henders Mark Accounting Printer Plant Allen Accounting Printer Berwick Sam Marketing Copier Asonte Toni Engineering Fax Dorfberg Jeremy Engineering Copier Cooper Linda Admin. Fax Simpson Sandrac Engineering Copier Gokarna Phillip Accounting Printer Sindole Randy Marketing Fax Smith Ellen Engineering Fax Cane Nate Marketing Printer Vuanuo Tuome Engineering Printer Selznick Anna Accounting Copier Cash Mary Engineering Printer Szcznyck Tadeuz Engineering Copier Kaneko Midori R and D Fax Lampstone Pete Marketing Fax Bell Tom Accounting Printer Quan Karen Engineering Printer Kellerman Tommie Engineering Printer 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 1/13/09 4/18/01 4/10/99 10/13/98 1/3/05 12/21/05 12/13/93 8/6/08 1290 1299 1300 1301 1310 7/8/70 7/12/78 10/1/66 9/16/85 9/24/65 6/25/61 11/2/65 1311 1329 1330 1331 10/4/86 9/26/02 2/22/09 2/14/99 5/11/99 11/13/54 5/6/64 9/23/68 17 18 19 20 21 22 23 24 25 26 27 28 29 1333 1334 1426 1516 1517 1529 4/16/95 4/8/98 9/8/85 3/6/04 5/21/64 10/7/65 10/18/65 9/23/58 6/26/63 7/7/63 9/10/71 2/26/89 1/28/07Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started