The following data is for Ann's Veterinary Clinic. It includes the customer number, the type of animal (1 is for dog, 2 is for cat, 3 is for a reptile, 4 is for bird), how they rated their visit (on a 1-20 scale with 20 being worst) and how likely they are to return (on a 1-5 scale). 2 3 2 5 4 4 LO B C D E 1 Customer Number Animal Type Survey Rating Likely to Return? Select 2 19516 2 5 3 3 19050 3 20 1 4 17052 2 1 10037 2 18 4 6 13365 1 16 5 7 10068 3 6 5 8 19198 1 3 9 10149 2 6 4 10 12384 2 7 2 11 117471 2 121 5 12 11956 3 13 2 13 18264 3 8 5 14 18659 2 5 15 WIN A UN 6 4 2. w loo 16 How would we average the variables Survey Rating and Likely to Return if we wanted an equally weighted average? O=AVERAGE(C2:D2) O =(D2+C2-4)/2 =(D2+C2/27/2 =(22+2/42