Answer:
AVERAGEIF(Player, "A_Clemente", Hits)
Step-by-step explanation:
The AVERAGEIF function allows users to calcule the mean value of numerical columns while also Given certain constraints within a single function call. The AVERAGEIF takes in 3 arguments.
The first is a column which houses the range of the constraint we would like to apply on our function.
The second argument is the constraint itself which should reside within the values in the range defined in the first argument.
The third argument is the numerical column whose average is calculated based on the defined constraint.
Therefore, in the scenario above, Player is the column containing player names, which it's value will later be used as a constraint
"Clemente_A" the constraint, only values pertaining to Clemente_A will be defined.
Hits, the numeric column whose value is averaged based on the constraint given.