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
Get step-by-step solutions from verified subject matter experts
