Assign swimmers
Not what you're looking for?
See attachment
Background:
Coach needs to assign his team to a two hundred yard medley (four swimmers, each team swims fifty yards of one of the 4 types of strokes) Problem being that there's no clear way to assign each athlete each of the four strokes. Five quickest swimmers and their best speed(in seconds)they have achieved in each of the strokes for fifty yards are as follows:
Backstroke Breaststroke Butterfly Freestyle
Cole 37.7 43.4 33.3 29.2
Craig 32.9 33.1 28.5 29.6
Don 33.8 42.2 30.4 28.5
Tim 37 34.7 30.4 28.5
Kris 35.4 41.8 33.6 31.1
Goal is to assign the swimmers to make the quickest relay team
I need the spreadsheet ( in the excel format) and what the solver results are.
Purchase this Solution
Solution Summary
This provides an example of determining the quickest relay team given times.
Solution Preview
Hello
I have attached the solution .
Hi, I have reviewed my solution. ...
Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.