MBA
Springer_Elizabeth_Homework 7_2.xlsx

# Ted for the count colunm by 50 to determine of each

• Homework Help
• 17
• 100% (1) 1 out of 1 people found this document helpful

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

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

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

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:
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

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

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

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

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

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
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.

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

25:D34, "1") >12", D39:D48, ">100000")
This is the end of the preview. Sign up to access the rest of the document.
• Spring '13
• AnBotao

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern