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.

J11 A B C F G H | M N O P C 1 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? Hair Color Summary 9 Brown Green Count Sum Average Black 10 Brown Brown Brown 11 Brown Brown 12 Black 4 Brown Rec Blond 13 Brown Blue Black Blue 14 15 Blue Eye Color Summary Brown 16 Blue Brown Count Sum Average Black Brown Blue 17 9 Brown 18 10 Red Blue Hazel 19 Brown Brown Green Black Brown 20 14 Brown Green 10 13 Black How many students will get a shirt? 2 Hazel 24 16 Brown Boolean Functions IF Function Lookup Functions Conditional Functions 4 Reaty 10005

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

Answer 1

The parts which needs to be solved as per the question requirements are given as follows:

- The cell I10 of the hair color summary table can be filled with the following formula as follows:

I10 =COUNTIF($C$9:$C$308, H10)

Copy the part of the above formula which is highlighted as bold and paste it into the cell I10. Press enter to see the results:

X for =COUNTIF($C$9:$C$308, H10) C D E F G H I J K L 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? Hair Color Summary Count Sum 52 Average Black Brown Red Blond Eye Color Summary Count Sum Average Brown Blue 11 Hazel Green Student Hair Color Eye Color Free Throws Get Shirt? Brown Green 2 Brown Brown Brown Brown Black Brown Brown Blue Black Blue Brown Blue Brown Blue Black Brown 10 Red Blue Brown Brown 12 Black Brown 13 Brown Green 14 Black Brown 15 Brown Blue Brown Hazel Black Brown 18 Black Blue Brown Blue 20 Blond Blue Black Brown Brown Brown Blond Blue Red Hazel Blond Blue How many students will get a shirt? 19 HUU

- The column Count of the hair color summary table can be filled by copying the formula of cell I10 and paste it down to the complete column (Count). The result of this table is shown as follows:

110 * for -COUNTIF($C$9:$C$308, H10) D E F A B C G H KL 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? Average Black Brown Red Blond Hair Color Summary Count Sum 52 146 32 70 NOONNO Eye Color Summary Count Sum Average Brown Blue Hazel Green Student Hair Color Eye Color Free Throws Get Shirt? 1 Brown Green 2 Brown Brown 4 Brown Brown Black Brown Brown Blue Black Blue 7 Brown Blue Brown Blue Black Brown Red Blue Brown Brown Black Brown Brown Green 14 Black Brown 15 Brown Blue 16 Brown Hazel 17 Black Brown Black Blue 19 Brown Blue Blond Blue Black Brown Brown Brown Blond Blue Red Hazel Blond Blue How many students will get a shirt? 20 VN100

- The cell I17 of the eye color summary table can be filled with the following formula as follows:

I17 =COUNTIF($D$9:$D$308, H17)

Copy the part of the above formula which is highlighted as bold and paste it into the cell I17. Press enter to see the results:

X fx =COUNTIF($D$9:$D$308, H17) B C D E F G H I J 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? Hair Color Summary Count Sum Average Uw Black Brown Red Blond 146 32 70 Eye Color Summary Count Sum 101 Average Brown Blue Hazel Green Student Hair Color Eye Color Free Throws Get Shirt? 1 Brown Green 2 Brown Brown Brown Brown Black Brown Brown Blue Black Blue 7 Brown Blue Brown Blue 9 Black Brown 10 Red Blue Brown Brown 12 Black Brown Brown Green 14 Black Brown Brown Blue Brown Hazel Black Brown Black Blue Brown Blue Blond Blue Black Brown Brown Brown Blond Blue 24 Red Hazel 25 Blond Blue m + c 3 HS có EN co gi ca côn to + + c có NỮ + H ) How many students will get a shirt? HI 20 21 22

- The column Count of the eye color summary table can be filled by copying the formula of cell I17 and paste it down to the complete column (Count). The result of this table is shown as follows:

117 =COUNTIF($D$9:$D$308, H17) D E F G H I J K L 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? Average Student Hair Color Eye Color Free Throws Get Shirt? Brown Green 2 Brown Brown Brown Brown Hair Color Summary Count Sum 52 146 Black Brown Black Brown Red Brown Blue Blond Eye Color Summary Count Sum Average 101 104 8 9 10 11 12 13 14 15 Brown Blue Hazel Green 49 How many students will get a shirt? Black Brown Brown Black Red Brown Black Brown Black Brown Brown Black Black Brown Blond Black Brown Blond Red Blond Blue Blue Blue Brown Blue Brown Brown Green Brown Blue Hazel Brown Blue Blue Blue Brown Brown Blue Hazel Blue 20 23 24 25

The following parts of the solution are given to fill the tables completely given in the question.

The cell J10 of the hair color summary table can be filled with the following formula as follows:

J10 =SUMIF($C$9:$C$308, H10, $E$9:$E$308)

Copy the part of the above formula which is highlighted as bold and paste it into the cell J10. Press enter to see the results:

J10 for SUMIF($C$9:$C$308, H10, $E$9:$E$308) E F G A B C D H J K L 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? Average Student Hair Color Eye Color Free Throws Get Shirt? Brown Green Brown Brown Brown Brown Black Brown Hair Color Summary Count Sum 52 288 146 Black Brown Red Blond Brown Blue 8 Average Eye Color Summary Count Sum 101 104 9 10 11 12 13 Brown Blue Hazel Green 49 Blue Blue Blue Brown Blue Brown Brown Green Brown Blue Hazel Brown Blue Blue 14 How many students will get a shirt? Black Brown Brown Brown Black Red Brown Black Brown Black Brown Brown Black Black Brown Blond Black Brown Blond Red Blond 15 Blue Brown Brown Blue Hazel Blue

The column Sum of the hair color summary table can be filled by copying the formula of cell J10 and paste it down to the complete column (Sum). The result of this table is shown as follows:

J10 for SUMIF($C$9:$C$308, H10, $E$9:$E$308) E F G A B C D H J K L 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? Average Student Hair Color Eye Color Free Throws Get Shirt? Brown Green Brown Brown Brown Brown Black Brown Black Brown Red Blond Hair Color Summary Count Sum 52 288 146 754 208 340 Brown Blue 8 Average Eye Color Summary Count Sum 101 104 9 10 11 12 13 Brown Blue Hazel Green 49 14 How many students will get a shirt? 15 Black Brown Brown Brown Black Red Brown Black Brown Black Brown Brown Black Black Brown Blond Black Brown Blond Red Blond Blue Blue Blue Brown Blue Brown Brown Green Brown Blue Hazel Brown Blue Blue Blue Brown Brown Blue Hazel Blue ONNIO1910010101 +1 +0100NINI

The cell J17 of the eye color summary table can be filled with the following formula as follows:

J17 =SUMIF($D$9:$D$308, H17, $E$9:$E$308)

Copy the part of the above formula which is highlighted as bold and paste it into the cell J17. Press enter to see the results:

J17 1 x fc =SUMIF($D$9:$D$308, H17, $E$9:$E$308) A B C D E F G H | | | 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? Average Student Hair Color Eye Color Free Throws Get Shirt? Brown Green Brown Brown Brown Brown Black Brown Black Brown Red Blond Hair Color Summary Count Sum 52 288 146 754 208 340 Brown Blue 7 Black Brown Brown Black Red Blue Blue Blue Brown Blue Average Eye Color Summary Count Sum 101 104 1547 10 Brown Blue Hazel Green 11 49 46 12 13 How many students will get a shirt? 14 15 Brown Black Brown Black Brown Brown Black Black Brown Blond Black Brown Blond Red Blond Brown Brown Green Brown Blue Hazel Brown Blue Blue Blue Brown Brown Blue Hazel Blue

The column Sum of the eye color summary table can be filled by copying the formula of cell J17 and paste it down to the complete column (Sum). The result of this table is shown as follows:

J17 x fc - A =SUMIF($D$9:$D$308, H17, $E$9:$E$308) D E F G B C H KL 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? 3 Average 288 Black Brown Red Blond Hair Color Summary Count Sum 52 146 754 32 208 340 ... 70 Average Eye Color Summary Count Sum 101 547 104 Brown 514 Blue Hazel 49 276 Green 253 Student Hair Color Eye Color Free Throws Get Shirt? Brown Green 2 Brown Brown 4 Brown Brown 4 Black Brown Brown Blue Black Blue Brown Blue Brown Blue Black Brown 10 Red Blue 11 Brown Brown 12 Black Brown 13 Brown Green 14 Black Brown 15 Brown Blue Brown Hazel 17 Black Brown Black Blue Brown Blue Blond Blue Black Brown Brown Brown Blond Blue Red Hazel 25 Blond Blue How many students will get a shirt? 26 24

The cell K10 of the hair color summary table can be filled with the following formula as follows:

K10 =AVERAGEIF($C$9:$C$308, H10, $E$9:$E$308)

Copy the part of the above formula which is highlighted as bold and paste it into the cell K10. Press enter to see the results:

K10 - X Foc AVERAGEIF($C$9:$C$308, H10, $E$9:$E$308) A B C D E F G H J K 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? Average 5.54 Black Brown Red Blond Hair Color Summary Count Sum 52 288 146 754 32 208 340 70 NOONNO Eye Color Summary Count Sum 547 Average Brown 101 104 514 Blue Hazel Green 49 276 46 253 Student Hair Color Eye Color Free Throws Get Shirt? 1 Brown Green 2 Brown Brown 4 Brown Brown Black Brown Brown Blue Black Blue 7 Brown Blue Brown Blue Black Brown Red Blue Brown Brown Black Brown Brown Green 14 Black Brown 15 Brown Blue 16 Brown Hazel 17 Black Brown Black Blue 19 Brown Blue Blond Blue Black Brown Brown Brown Blond Blue Red Hazel Blond Blue How many students will get a shirt?

The column Average of the hair color summary table can be filled by copying the formula of cell K10 and paste it down to the complete column (Average). The result of this table is shown as follows:

K10 - x x =AVERAGEIF($C$9:$C$308, H10, $E$9:$E$308) в C D E F G H I J KL 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? Hair Color Summary Count Sum 288 146 Average 5.54 5.16 6.50 Black Brown Red Blond 754 208 340 14.86 Blue Average 101 Brown Blue Eye Color Summary Count Sum 547 104 514 49 276 46 253 Hazel Green Student Hair Color Eye Color Free Throws Get Shirt? Brown Green Brown Brown Brown Brown Black Brown Brown Blue Black Blue 8 Brown Blue 9 Black Brown 10 Red Blue 11 Brown Brown Black Brown Brown Green Black Brown Brown Blue Brown Hazel Black Brown Black Blue Brown Blue Blond Blue Black Brown Brown Brown blond Blue Red Hazel Blond Blue 0 0 HN có N có co o p q = 0 có NF + How many students will get a shirt?

The cell K17 of the eye color summary table can be filled with the following formula as follows:

K17 =AVERAGEIF($D$9:$D$308, H17, $E$9:$E$308)

Copy the part of the above formula which is highlighted as bold and paste it into the cell K17. Press enter to see the results:

K17 X for AVERAGEIF($D$9:$D$308, H17, $E$9:$E$308) B C D E G H к 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? Black Brown Red Blond Hair Color Summary Count Sum 52 288 146 754 208 70 340 Average 5.54 5.16 6.50 4.86 7 Average 5.42 Brown Eye Color Summary Count Sum 101 547 104 514 49 276 46 253 Blue 11 Hazel Green Student Hair Color Eye Color Free Throws Get Shirt? Brown Green 2 Brown Brown 4 Brown Brown Black Brown Brown Blue Black Blue Brown Blue Brown Blue Black Brown 10 Red Blue Brown Brown Black Brown Brown Green Black Brown 15 Brown Blue 16 Brown Hazel 17 Black Brown 18 Black Blue 19 Brown Blue 20 Blond Blue Black Brown Brown Brown Blond Blue Red Hazel Blond Blue 13 14 How many students will get a shirt?

The column Average of the eye color summary table can be filled by copying the formula of cell K17 and paste it down to the complete column (Average). The result of this table is shown as follows:

K17 - X f V C =AVERAGEIF($D$9:$D$308, H17, $E$9:$E$308) E F G H. A B D J K L 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 Eye Color Free Throws Get Shirt? Brown Green Brown Brown Brown Brown Black Brown Black Brown Red Blond Hair Color Summary Count Sum 52 288 146 754 208 340 Average 5.54 5.16 6.50 4.86 Brown Blue 8 Eye Color Summary Count Sum 101 547 104 9 10 11 12 13 Brown Blue Hazel Green Average 5.42 4.94 5.63 5.50 49 276 253 Blue Blue Blue Brown Blue Brown Brown Green Brown Blue Hazel Brown Blue Blue 14 How many students will get a shirt? Black Brown Brown Brown Black Red Brown Black Brown Black Brown Brown Black Black Brown Blond Black Brown Blond Red Blond 15 Blue Brown Brown Blue Hazel Blue

The cell F9 can be filled with the following formula as follows:

F9 =OR(C9 = "Red", D9 = "Hazel")

Copy the part of the above formula which is highlighted as bold and paste it into the cell F9. Press enter to see the results:

- x fc =OR(C9 = "Red", D9 = "Hazel") E F A B C D G H J K L 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? Black Hair Color Summary Count Sum 52 288 146 754 208 340 Brown Red Blond Average 5.54 5.16 6.50 4.86 Brown 10 Eye Color Summary Count Sum 101 547 104 514 49 276 253 MOOINONNOOOO1910010101000 Student Hair Color Eye Color Free Throws Get Shirt? 1 Brown Green FALSE 2 Brown Brown Brown Brown Black Brown 5 Brown Blue Black Blue 7 Brown Blue 8 Brown Blue 9 Black Brown Red Blue 11 Brown Brown Black Brown Brown Green 14 Black Brown 15 Brown Blue 16 Brown Hazel Black Brown 18 Black Blue Brown Blue Blond Blue Black Brown Brown Brown Blond Blue Red Hazel Blue Average 5.42 4.94 5.63 5.50 Hazel Green How many students will get a shirt? Blond Blue

The highest average in the table hair color summary is 6.50 of the red color hair students and the highest average in the table eye color summary is 5.63 of the hazel color eye students.

The cell F9 (Get Shirt?) will be true if the cell C9 (Hair Color) is Red or cell D9 (Eye Color) is Hazel, otherwise it will be false.

The column Get Shirt? of the table 1 can be filled by copying the formula of cell F9 and paste it down to the complete column (Get Shirt?). The result of this table is shown as follows:

- x fc =OR(C9 = "Red", D9 = "Hazel") E F в C D G H I J 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? Black Brown Red Blond 146 Hair Color Summary Count Sum 288 754 208 340 Average 5.54 5.16 6.50 4.86 Blue Eye Color Summary Count Sum H 101 547 Brown Blue 104 49 46 Hazel Green Average 5.42 4.94 5.63 5.50 514 276 253 Student Hair Color Eye Color Free Throws Get Shirt Brown Green FALSE Brown Brown FALSE Brown Brown FALSE Black Brown FALSE Brown Blue FALSE Black FALSE Brown Blue FALSE 8 Brown Blue FALSE 9 Black Brown FALSE 10 Red Blue TRUE Brown Brown FALSE Black Brown FALSE Brown Green FALSE Black Brown FALSE Brown Blue FALSE Brown Hazel TRUE Black Brown FALSE Black Blue FALSE Brown Blue FALSE Blond Blue FALSE Black Brown FALSE Brown Brown FALSE Blond Blue FALSE Red Hazel TRUE Blond Blue FALSE How many students will get a shirt? aalaala a

The cell K22 (How many students will get a shirt?) can be filled with the following formula as follows:

K22 =COUNTIF($F$9:$F$308, TRUE)

Copy the part of the above formula which is highlighted as bold and paste it into the cell K22. Press enter to see the results:

K22 X for =COUNTIF($F$9:$F$308, TRUE) A B C D E F G H I J K 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? Hair Color Summary Count Sum 52 288 146 moHNINN Black Brown Red Blond 754 208 340 Average 5.54 5.16 6.50 4.86 101 Brown Blue Eye Color Summary Count Sum 547 104 514 49 276 46 253 Average 5.42 4.94 5.63 5.50 Hazel Green Student Hair Color Eye Color Free Throws Get Shirt? i Brown Green FALSE Brown Brown FALSE Brown Brown FALSE Black Brown FALSE Brown Blue FALSE Black Blue FALSE Brown Blue FALSE 8 Brown Blue FALSE 9 Black Brown FALSE 10 Red Blue TRUE 11 Brown Brown FALSE Black Brown FALSE Brown Green FALSE Black Brown FALSE Brown Blue FALSE 16 Brown Hazel TRUE Black Brown FALSE Black Blue FALSE Brown Blue FALSE Blond Blue FALSE Black Brown FALSE Brown Brown FALSE Blond Blue FALSE Red Hazel TRUE Blond Blue FALSE 14 How many students will get a shirt? | 76 19100101011000NIN

Count the number of students whose value in the column Get Shirt? is TRUE. The result of this formula will be the number of students getting a shirt.