Directions: This assignment has 10 questions worth 1 point each. When finished, save each spreadsheet to a disk saved under the number of the problem.
For each of the problems, design an Excel spreadsheet that will find the mean, median, mode, and range for a given data set.
Each spreadsheet should have the following format.
1. In cell A1, write and center the word data.
2. In cells A2 A# input and center the data.
3. Sort the data so that it goes from the smallest number to the largest number.
4. In cell B1, write and center the word mean.
5. In cell B2, write and equation to find the mean of the given data.
6. In cell C1, write and center the word median.
7. In cell C2, input the median.
8. In cell D1, write and center the word mode.
9. In cell D2, input the mode.
10. In cell E1, write and center the word range.
11. In cell E2, input an equation to find the range of the data.
Homework Problems 1-10
A2#1) 18, 15, 12, 14, 16
A2#2) 2, 5, 2, 8, 4, 3, 7, 6
A2#3) 12, 29, 14, 8, 36, 26, 15
A2#4) 5, 9, 8, 10, 7, 3
A2#5) 5, 2, 6, 8, 2, 3, 1
A2#6) 10, 20, 30, 20, 50, 60, 30, 10, 80, 10
A2#7) 11, 12, 16, 18, 14, 11, 19, 16, 12, 18
A2#8) 1, 2, 3, 4, 5, 6, 8, 4, 5, 2, 1, 6, 7
A2#9) 100, 200, 150, 600, 350, 200, 150, 200, 150, 900, 800, 500, 400, 150
A2#10) 90, 50, 80, 7, 11, 12, 65, 63, 2, 8, 11, 68, 68, 9, 78, 51, 21, 37, 19