# Homework #7 -- due 5 December, 1996

You can do this homework in any Windows or Unix spreadsheet program. I suggest you use Quattro Pro. It's installed on almost all PC's on the UNCA campus.

## The problem

In this assignment you will design a spreadsheet for a competition. The competition involves

• five competitors
• six judges
• three judged events

For every event, each judge assigns every competitor a rating from 0.0 to 10.0. Assume the scores are given to an "accuracy" of one-tenth. A competitor's score on a particular event is obtained by taking the six ratings of the judges, discarding the highest and lowest ratings, and then adding the remaining four.

For example, if the six scores are 9.8, 9.7, 9.9, 5.3, 7.1, and 9.5, the high and low scores (9.9 and 5.3) are thrown away, and the remaining four are summed to give a total of 9.8+9.7+7.1+9.5, or 36.1.

The competitor's final score is obtained by computing a weighted sum of his/her scores on the three events. The events are weighted so that the second and third events count twice as much as the first. So, if the competitors scores were 36.1, 38.7, and 35.5, his/her final score would be 36.1+2*38.7+2*35.5, or 184.5.