by Eddie Bole (104 Submissions)
Category: Math/Dates
Compatability: VB 6.0
Difficulty: Intermediate
Originally Published: Mon 8th May 2017
Date Added: Tue 9th February 2021
Rating: (1 Votes)
Program to work out the mean and the range. Uses a listbox (with sort enabled) and integer numbers prepadded with zeros to numerically sort them. Also managed to do some extra filtering of extra spaces and commas to ensure that the sorted integer numbers are neatly aligned. When the mean is exactly a whole number there are no decimals (so the mean of the numbers 4, 5 and 3 would be equal to 4.000 but would be displayed as just 4). A good example of how to find minimum and maximum values using a sorted listbox and arrays (using split and join). Lastly the results can be copied into Word for Windows to produce NUMBERED QUESTION and ANSWER worksheets on Basic Statistics. Lots of little things coming together to produce something useful for teachers and students of maths. Enjoy.
Download Average and Range Calculator / Worksheet Maker (70 KB)