D

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:

Marks outliers in yellow.

Computes statistics.

Heres part of the output:

Round the average to one decimal place.

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 worksheet.

USE VISUAL BASICS

1 Name 2 Roderick 3 Junie 4 Bea 5 Rodney 6 Weldon 7 Del 8 Charissa 9 Enid 10 Gail 11 Carole 12 Marey 13 Beulah 14 Merrill 15 Talitha 16 Marissa Length (cm) 26 26 29 24 34 32 28 22 31 33 32 26 Run counts In range Outliers: Total obs: Statistics (For in-range data only) Total: Count: Average: Smallest: Largest