You've collected job satisfaction data using $5$ questions, each scored on a $5$ point scale. You are asked to report about overall job satisfaction $($mean of the $5$ values$)$ for each department. F$2-$ F$60$ contains the average values from questions $1-5.$ G$2-$ G$60$ contains the location for each employee. You are first requesting the average for the location Hayward, CA $($which is located in cell K$2).$

Which of the following formulas will provide the average job satisfaction rating for employee at the Hayward, CA location?

Which formula would be most appropriate.

You've collected job satisfaction data using $5$ questions, each scored on a $5$ point scale. You are asked to report about overall job satisfaction $($mean of the $5$ values$)$ for each department. F$2-$ F$60$ contains the average values from questions $1-5.$ G$2-$ G$60$ contains the location for each employee. You are first requesting the average for the location Hayward, CA $($which is located in cell K$2).$

Which of the following formulas will provide the average job satisfaction rating for employee at the Hayward, CA location?

Which formula would be most appropriate.

None of these are correct

$=$AverageIF$($$G$$2$:$G$$60,$ "Hayward, CA$",$ K$2)$

$=$Average$($$F$$2$:$F$$60,$ Hayward, CA$,$ $G$$2$:$G$$60)$

$=$AverageIF$($$G$$2$:$G$$60,$ "Hayward, CA$",$ $F$$2$:$F$$60)$