xls, 30.5 KB
Generates a list of 25 random numbers less than 100, then sorts them numerically (leaving original order for comparison) automatically calculates mode, median and mean, with a graph of the three results. Make sure you enable macros then press the top button to set up the needed addins and to undo them when finished press the bottom button. (The buttons just ensure that the iterations are set correctly). No I didn't know what that meant until I made this spread sheet either :)
Creative Commons "Sharealike"




9 years ago

A different way of showing mode, median and mean averages using a random number generator. Useful for upper KS2.

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.