Stats for price data

Download this workbook. It has data on prices for a product. It looks like this:


The number of data items is given in cell B7.

Add code that computes the average, highest value, and lowest value of the data set. Make sure the program works when the amount of data changes.

Validate n, the number of data items. If the user enters a value less than 2, show this:


Upload your file.

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)

Referenced in: