Task+6

As the Olympics go on there will be a daily medal tally. This task involves two parts and will require you to rename the "Sheet 1" tab at the bottom to "Australian Medals" (right click and select Rename) and "Sheet 2" to Medal Tally.

1. Set up the Australian medal tally so you can put in the medals won each day and it will total the columns. This will allow you to follow our progress. I have only put in a few dates. You have to include every date from July 28th to August 12th! 2. On sheet two, create a table showing the medal count for the top 10 nations. You need to identify the mean, median, mode and range for each column.
 * Date || Gold || Silver || Bronze ||
 * July 28th || 2 || 3 || 1 ||
 * July 29th || 1 || 2 || 2 ||
 * July 30th || 10 || 1 || 1 ||
 * July 31st || 1 || 2 || 3 ||
 * August 1st ||  ||   ||   ||
 * TOTAL || 14 || 8 || 7 ||
 * || Gold || Silver || Bronze ||
 * USA || 12 || 13 || 10 ||
 * Australia || 11 || 12 || 20 ||
 * China || 10 || 10 || 10 ||
 * Great Britain || 11 || 2 || 3 ||
 * France ||  ||   ||   ||
 * TOTAL ||  ||   ||   ||
 * MEAN ||  ||   ||   ||
 * MEDIAN ||  ||   ||   ||
 * MODE ||  ||   ||   ||
 * RANGE ||  ||   ||   ||

MEAN - The average - add and divide (/) by 10 MEDIAN - The middle score (write it down the bottom but fill the cell with colour too) MODE - Which score is the most common? (write it down the bottom but fill the cell with colour too) RANGE - the lowest score subtracted from the ighest score. Reminder it will be somethig like =b3-g3.