Please show solution in excel solver

79.39% 3. The coach of the women's swim team at State University is preparing for the conference swim meet and must choose the four swimmers she will assign to the 800- meter medley relay team. The medley relay consists of four strokes, namely, backstroke, breaststroke, butterfly, and freestyle. The coach has computed the average times (in minutes) each of her top six swimmers has achieved in each of the four strokes for 200 meters in previous swim meets during the season. a. Determine for the coach the medley relay team and its total expected relay time. b. A new swimmer Tootsie transferred to the school and seemed to be fastest at all four events compared to the current team members. What stroke should she swim for the medley? Tootsie 2.54 2.80 2.80 2.25 Stroke (min.) Swimmer Backstroke Breaststroke Butterfly Freestyle Annie 2.56 3.07 2.90 2.26 Beth 2.63 3.01 3.12 2.35 Carla 2.71 2.95 2.96 2.29 Debbie 2.60 2.87 3.08 2.41 Erin 2.68 2.97 3.16 2.25 2.75 3.10 2.93 2.38 Fay