Taste test stats


Some goats have taken a taste test, saying how much they like three different leafs. Write a VBA program to compute some basic statistics on the data, using a For loop. Download a start worksheet that has the data.

It starts like this:


The clicks the button, and your code runs. For the data you're given, it shows:


Write the code so that the number of records could change, as more data is gathered. That is, don't hard-wire your code so that it only works for 50 goats. So, if data for 20 more goats was added, your program would accept record numbers up to 70, without any of your code changing.

Upload your workbook. The usual coding standards apply.

Where referenced