Atlas $3\mathrm{.}0$

$2\mathrm{.}11$ Use the AVERAGEIF

$2\mathrm{.}12$ Copy your function in cell

$2\mathrm{.}13$ Use the OR function in

cell F$3)$ to determine if Student $1$

gets a T$-$shirt. Students with "Red"

as a hair color had the highest

average number of free throws

made on the "Hair Color Summary"

table and students with Eye Color

as "Hazel" had the highest average

number of free throws made on the

"Eye Color Summary" table.

a$.$ Students get a T$-$shirt if their

Hair Color is "Red" or their Eye

Color is "Hazel".