Please show how to complete c through d using the steps. I think I'm supposed to use =count, but I don't know what's after that. Home Insert Draw Page Layout Formulas Data Review View Tell me t X v Paste Arial 12 vA^ A - v ab Wrap Text v General ^^F Conditional Format Cell Formatting as Table Styles Uv v vAv = += + Merge & Center v 6%$ Inse H7 X v fx B C D E F G H n department survey data 3 Gender Years of Service Graduate Degree? CPA? 4 F 17 N Y 5 F 6 N N 6 M 8 Y Y F 8 Y N 8 M 16 Y Y 9 F 21 N Y 10 M 27 N N 11 F 7 Y Y 12 M 8 N N 13 M 23 N Y 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 5. PivotTables 4. Logical functions 3. Filter 2. Sort Use Excel functions to find: Answer 27 14.1 a. the maximum number of years of service b. the average number of years of service c. the number of employees with a graduate degree d. the number of female employees who have a CPA e. the average number of years of service for male employees 1. Basic Excel functions
Added by Michael H.
Close
Step 1
To find the maximum number of years of service, you can use the MAX function. Show more…
Show all steps
Your feedback will help us improve your experience
David Mccaslin and 97 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then apply Percent Style with zero decimals. Fill the formula down through the range G5:G8. I need help writing the formula for this question. Where do I type everything? Step by step instructions would be helpful as to where to type and what to press/click. Ignore the selected cells in the screenshot, please. Thank you!
Akash M.
Task 1A: Calculate Count (1-3) Step 1: Use the =COUNTIF function in the highlighted Count column below to determine the number of projects 1-3. Step 2: Enter the following cell ranges for Quality (B13:B62), Speed (C13:C62), and Costs (D13:D62). Step 3: Use a Criteria of "1" Step 4: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used. Task 1B: Calculate Count (4-7) Step 5: Use the =COUNTIFS function in the highlighted Count column below to determine the number of projects 4-7. Step 6: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62). Step 7: Use a Criteria of "1" Step 8: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used. Task 1C: Calculate PIP Percentage Step 9: Use the PIP Percentage column to divide each value you generated for the Count column by 50 to determine % of each. Task 1D: Calculate PIP Success Step 10: Use the =COUNTIFS function within the PIP Success column to determine the number of project(s) that the NEWS BOD found successful. Step 11: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62), as well as, Results (H13:H62). Step 12: Then, divide the =COUNTIFS function by 50.
Sri K.
Leadership Training VESTA 6-Part Series INSURANCE GROUP Department First Name Last Name Part 1 Part 2 Part 3 Sales Bob Carver x x x Sales Heidi Lee x x Claims Josie Gates x x x Accounting Wendy Crocker x x Accounting Loretta Johnson x x Sales Walter Rivera x Claims Misty Whitfield x Marketing Matilda Lewis Accounting Elizabeth Hicks x x HR Alvin Rios x HR Brian Gaines x Sales Megan Bosworth Claims Maria Menzies x Claims Michael Russell x Total Paid Total Owed $50.00 $50.00 $75.00 $20.00 $20.00 $20.00 $50.00 $25.00
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD