Use the COUNTIF function in cell I10 to determine the number of students with black hair. Be sure to build a formula that can be reused by copying down.

- Copy your function in cell I10 and paste it down to complete the "Count" column of the "Hair Color Summary" table.

- Use the COUNTIF function in cell I17 to determine the number of students with brown eyes.  Be sure to build a formula that can be reused by copying down.

- Copy your function in cell I17 and paste it down to complete the "Count" column of the "Eye Color Summary" table.

 

The athletic department is sponsoring a free throw contest before tonight's game to give away free t-shirts. They have recorded the hair and eye color of each participant. Each participant shoots ten free throws. The hair and eye color groups with the highest average number of free throws made will get a t-shirt. Complete the summary tables below to determine which groups made the most free throws. Then complete the table to determine which students get a shirt. How many students will get a t-shirt? Student Hair Color 1 Eye Color Free Throws Get Shirt? Green Brown Brown. Brown Blue Blue Blue Blue Brown Blue Brown Brown Green Brown Blue Hazel Boolean Functions IF Function 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Brown Brown Brown Black Brown Black Brown Brown Black Red Brown Black Brown Black Brown Brown 3 4 9 9 1 7 8 7 2 8 9 6 10 8 0 6 Black Brown Red Blond Brown Blue Hazel Green Hair Color Summary Count Sum Lookup Functions Conditional Functions Eye Color Summary Count Sum How many students will get a shirt? B Average Average