Question

- Use the COUNTIF function in cell I10 to determine the number of students with black hair. Be sure to build a formula 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 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 glve 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 calor 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? 2 3 4 5 6 7 Student Hair Color 8 Eve Color Free Throws Get Shirt? 

Answer 1

COUNTIF function in excel is used to count the number of cells with a specified criteria. In the given screenshot it is used to count the student with specified hair color and eye color respectively.

Function to count the total hair color.

=COUNTIF(C:C,$H10)

fix COUNTIF(C:C,$H10) 10 J D E F K L 1 2 3 6 7 Hair Color Eye Color Free Thro Get Shirt? Hair Color Summary 8 9 Brown Count Sum Average Green 3 10 Brown 11 Brown 12 Black 13 Brown 4 Black Brown 2 Brown Brown 9 6 Red Brown 9 0 Blond Blue 1 14 DIack 7 Ln O

Function to calculate Eye color of student

=COUNTIF(D:D,$H17)

fix COUNTIF(D:D,$H17) 117 A D F G H K 1 2 4 5 6 7 Hair Color Eye Color Free Thro Get Shirt? Hair Color Summary Student 8 Sum Average 1 Brown Green 3 Count Black 10 2 Brown Brown 4 2 Brown 11 3 Brown Brown 9 6 Red 12 4 Black Brown Blond Blue 13 5 Brown 1 0 6 Black Blue 14 7 Eye Color Summary Sum 7 Brown Blue 15 9 Blue 16 8 Brown 7 Count Average Brown 17 Blue 18 Hazel 19 20 Green 1 21