Download the attached Excel workbook with squid racing data. It looks like this:
Each squid participates in up to three races. If a squid did not participate in a race, the cell is marked N/A. For example, Xavier was in races 1 and 2, but not race 3.
The number of squid is given in cell(3, 2).
Compute the mean and count for each race, omitting cases where squid did not race. Here is output for the given data:
You can assume that the data is valid, e.g., no negative score.
Upload you workbook. The usual coding standards apply.
(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)