Question 1. Please use the correct Excel functions to find the minimum, maximum, median, mode, and average
Fantastic news! We've Found the answer you've been seeking!
Question:
Question 1. | |||||||||||
Please use the correct Excel functions to find the minimum, maximum, median, mode, and average of the following data set: | |||||||||||
32 | 1 | 19 | 60 | 43 | 100 | 55 | 80 | 28 | 31 | 30 | 75 |
4 | 50 | 56 | 72 | 17 | 25 | 13 | 84 | 58 | 89 | 79 | 31 |
2 | 27 | 84 | 83 | 69 | 81 | 83 | 32 | 17 | 84 | 58 | 83 |
55 | 16 | 47 | 83 | 81 | 91 | 93 | 57 | 45 | 60 | 22 | 85 |
Minimum: | ? | ||||||||||
Maximum: | ? | ||||||||||
Median: | ? | ||||||||||
Mode: | ? | ||||||||||
Average: | ? | ||||||||||
If the number of classes was 5, what would be the most optimal class width? | ? | ||||||||||
If the number of classes was 10, what would be the most optimal class width then? | ? | ||||||||||
(please don't round your answers, leave them exactly as excel computes them) |
Posted Date: