Download a workbook with data on the length of puffins. It looks like this:
("Total obs" means "Total observations.")
Most puffins are between 24 cm and 34 cm in length. Puffins smaller than 24 cm or larger than 34 cm are outliers, possibly mutant puffins with superpowers. For example, the infamous super-villain The Dart was a short puffin. She sank 18 ships in the Atlantic before being taken out by Seal Team 3.
Seal Team 3
Write a VBA program that computes statistics. Here's the output:
Write your program so that it adjusts if the number of rows changes. So your code should work if there are 28 observations, 59 observations, or 1,322 observations.
Assume that all of the data is valid, that is, all lengths are numeric, and greater than zero.
Normal coding standards apply.
Upload your workbook.