Springer_Elizabeth_Homework 7_2.xlsx

Ted for the count colunm by 50 to determine of each

Info icon This preview shows pages 8–17. Sign up to view the full content.

View Full Document Right Arrow Icon
ted for the Count colunm by 50 to determine % of each. determine the number of project(s) that the NEWS BOD found successful. PIP Success o work. Please refer to the COUNTIF Functions owing cell ranges for Quality (B13:B62), Speed o work. Please refer to the COUNTIF Functions lowing cell ranges for Quality (B13:B62), Speed
Image of page 8

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
26.00% 26.00% 22.00% 8.00% 10.00% 14.00% 4.00% rmine the number of "1s" in the Results colunm. s. ect. o work. Please refer to the COUNTIF Functions 1000) (E13:E62), Speed (Reduction in Days) o work. Please refer to the COUNTIF Functions has hindered their ability to remember the percentage that 's confidential criteria shown only as success or failure a:
Image of page 9
an 50%. Is this true? Explain. The BOD is very concerned teria has been provided. Does the new criteria change the eased to 22%. Based on this information, I have positive results in at least two catagories
Image of page 10

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 11
Image of page 12

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 13
COUNTIF Purpose This function will return count ce Syntax =COUNTIF(range, criteria) Quality Speed Costs 1 - 1 - 1 1 - 1 - 1 1 - - - - - 1 1 1 1 1 1 - - - 1 - 1 1 1 COUNTIFS Purpose This function will return the coun Syntax =COUNTIFS(range1, criteria1, r Quality Speed COSTS 1 - 1 - 1 1 - 1 - 1 1 - - - - - 1 1 1 1 1 1 - - - 1 - 1 1 1 Quality Speed Project (Defective Free (Reduction Cost over Out of 1000) in Days 5 years 901 10 $ 140,000.00 920 5 $ 28,000.00 75 22 $ 275,000.00 350 16 $ 55,000.00 250 18 $ 95,000.00 180 3 $ 110,000.00 430 11 $ 250,000.00 640 20 $ 190,000.00 115 11 $ 101,000.00 746 17 $ 72,000.00
Image of page 14

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
ells that meet a single criteria. Examples Range Criteria Count of Quality B8:B17 "1" Count of Speed C8:C17 "1" Although columns B, C, and D are adjacent to one another, the COUNTIF function only performs a COUNT on the range in a single column. nt cells that meet one or more criteria ange2, criteria2,…) Examples Range1 Criteria1 Count of Quality and Speed B25:B34 "1" Count of Quality, Speed, and Costs B25:B34 "1" The COUNTIFS function uses one-to-many range and criteria sets. In this example, two range and criter Examples Range1 Criteria1 Count the number of projects that cost less than $100,000 over 5 years D39:D48 "<100000" Count the number of projects where Quality > 200 Defective Free per 1000, B39:B48 ">200" Speed > 12, Days Reduced, and Costs > $100,000 per 5 years. The COUNTIFS function uses one-to-many range and criteria sets. In this example, three range and crite
Image of page 15
COUNT Function 5 =COUNTIF(B8:B17, "1") 7 =COUNTIF(C8:C17, "1") Range2 Criteria2 Range3 Criteria3 COUNT Function C25:C34 "1" 3 =COUNTIFS(B25:B34, "1", C25:C34, "1") C25:C34 "1" D25:D34 "1" 2 =COUNTIFS(B25:B34, "1", C25:C34, "1", D2 ria sets were used. Range2 Criteria2 Range3 Criteria3 COUNT Function 4 '=COUNTIFS(D39:D48, "<100000") C39:C48 ">12" E25:E34 ">100000" 1 '=COUNTIFS(B39:B48, ">200", C39:C48, "> eria sets were used.
Image of page 16

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
25:D34, "1") >12", D39:D48, ">100000")
Image of page 17
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern