Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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/07

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting The Ultimate Guide To Accounting For Beginners

Authors: Greg Shields

1st Edition

1546332820, 978-1546332824

More Books

Students also viewed these Accounting questions

Question

What is carpal tunnel syndrome?

Answered: 1 week ago