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

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!