Solve Problems Using Averages

Interactive macro-enabled MS-Excel spreadsheet. Contents: Find the overall mean score of pupils (integer) or films (decimal). Find the mass of peas from the largest pods in Mr. Pareto’s garden. Find the weight or height of a player & a sub’ after a mean changes. Find an overall average speed or daily temp given two sets of data. Find the position a sprinter finished given a mean & all other times. Find the median, mode & range of a data set given its mean & ratio. Find the mean reaction time of the right-handed given mean of left. Find two twins’ ages after they & another change a nursery’s mean. Find each gender’s mean mark given a % uplift, a mean & a ratio. Find December’s sales to beat a colleague’s monthly mean by a %. Find the original & new mean if balls are added & a mean changes. Find the median, mode & range of a linear algebraic data set. Find the median, mode & range of a quadratic algebraic data set.