It's Zane's birthday! His goaty friends are planning a big party, with lots of botanicals. They've gone out over the island, with three little plastic baggies each. They've collected Zane's fave botanicals:
- Wacky weed (WW)
- Crazy cloves (CC)
- Odd oregano (OO)
Write a program to work out how much they've collected, and who has collected the most and least. You can download a starting workbook. It looks like this to start:
Enrique collected 15.8 grams of WW, 26.5 grams of CC, and 18.1 grams of OO. His total pick was the sum of the three.
Compute the totals and averages for all three types. Also work out the goat with the highest and lowest picks. Show their names, and their pick weight.
Also output the record counts shown.
Validate the data before processing it. Each weight should be a number from 0 to 5 kilos. (We use the metric system, because we're civilized.) As usual, if any field in a record is invalid, the entire record is invalid.
Make sure your program will still work as the amount of data changes. Do NOT type the number of rows into your code.
Here's some output.
Upload your solution here, not to Moodle. The usual standards apply.