Purchase Solution

Assign swimmers

Not what you're looking for?

Ask Custom Question

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.

Attachments
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.