formula for choosing between Mode and Median

Thank you so much for the quick response. That seems to work when the value in the validation cell is median, but when mean is chosen it returns #N/A. here is the formula I used based on your advice.

Formula:

=CHOOSE(MATCH(A11,{"MODE","MEDIAN"},0),MODE(B7:B10),MEDIAN(B7:B10))

Did I do something wrong?