How to get the maximum and minimum values in the worksheet I need to take a maximum and minimum value in the data of a worksheet to facilitate ordering! Excuse me, what formula do I need to use to complete it! Or there is a better way! There is no chart! The manager asked me to make a table to count the quantity of this item in a week, and then take the value to facilitate daily ordering, so that I would not say that it would lead to a large inventory! Please teach me, or have some good ideas to tell me!

How to get the maximum and minimum values in the worksheet I need to take a maximum and minimum value in the data of a worksheet to facilitate ordering! Excuse me, what formula do I need to use to complete it! Or there is a better way! There is no chart! The manager asked me to make a table to count the quantity of this item in a week, and then take the value to facilitate daily ordering, so that I would not say that it would lead to a large inventory! Please teach me, or have some good ideas to tell me!

According to your description, a simple table is made. Do you see it like this? The manufacturer's price inventory is a 15.2 300 B 15.1 1500 C 15.3 21 d 15.7 95 e 15 125 J 15.5 100. Select the manufacturer according to the maximum price, add a D column, D1 = A1, first select the maximum value, B10 = max (B2: B7) to query the matching

When drawing frequency histogram, the difference between the maximum value and the minimum value is 21cm. If the group distance is 4cm, how many groups should be divided?

The step of making histogram is to determine the number of groups first and then the group distance
However, if you ask this question, you can also calculate it according to the formula:
H = R / K, where: H group distance; R range; K group number
According to the above formula: k = R / h = 21 / 4 = 5.25
Conclusion: the number of groups is 5

When drawing the frequency distribution histogram, the difference between the maximum value and the minimum value is 25cm. If the group distance is 4cm, the best score is ()
A. 4 groups B. 5 groups C. 6 groups D. 7 groups

In the sample data, the difference between the maximum value and the minimum value is 25cm, and the known group distance is 4cm. Then, because 254 = 614, it can be divided into 7 groups