Licker swipes

Challenge
No

Licker is like Tinder, but for goats. Goats don't have fingers, but they have tongues. They lick left to reject a goat, lick right to accept one. Write a program to compute some stats for some Licker data.

Your worksheet starts like this (download it):

Start

It shows how many licks each goat got. So Wava got 38 left licks, and 60 right licks.

Omit records that have invalid data. The numbers of licks must be numeric, zero or more, and less than or equal to 500.

Here's some output for the data set:

Output

Output the total and averages shown, the goats with the most left and right clicks, and record counts.

Upload your solution here, not to Moodle. The usual standards apply.

Attachments