How do these two values come out of this set of figures 1 15 4 27 91 17 =96\87
(15+1)-(27+17)/4+91=96
91-〔(15*1)-(27+17)/4〕=87
How to find the difference between the maximum value and the minimum value in a column of data in excel
Suppose the object is A1: a10
=MAX(A1:A10)-MIN(A1:A10)
RELATED INFORMATIONS
- 1. The minimum value of a group of data is 150 and the maximum value is 172. If the group distance is 4, how many groups can be divided when drawing the frequency distribution histogram?
- 2. A set of numerical laws are calculated as follows: 5,6,1,11,7,5,9, What's after 9, please?
- 3. A sample with 40 data is statistically divided into 6 groups. If the frequency of a group is 0.15, then the frequency of the group is______ .
- 4. What is frequency and frequency in junior high school mathematics? This is a multiple-choice question: divide a sample into 8 groups, the frequency of each group is 8,5,4,3,4,6,5,3 respectively, then the frequency of the fourth group is () A. The data of 0.08 b.0.16 c.0.5 D. is insufficient and cannot be calculated
- 5. Excel calculates the maximum and minimum values in a column, which are expressed in red and green, and calculates the average value of the number except the maximum and minimum values There is a group of numbers from A1 to a10. Among these numbers, if it is the largest, red will be displayed, if it is the smallest, green will be displayed, and the average value of A1 to A10 will be displayed on a11. However, the average value is the average value after removing the maximum value and the minimum value. That is: add the other 8 numbers and divide by 8 Is it impossible? Wodaxiaopengyo: please explain the meaning of "= $A1" in "= $A1 = max ($a $1: $a $10)", because I can get the correct result only by inputting "= max ($a $1: $a $10)" In addition, the formula behind you is really wonderful. I use the following formula: obviously not as good as yours =(SUM(A1:A10)-MAX(A1:A10)-MIN(A1:A10))/(COUNT(A1:A10)-2) Thirdly, after entering the above formula, if you use Ctrl + Shift + enter to end, a synthesis bracket will appear, but the result will not be affected,
- 6. 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!
- 7. Among the 30 data, the minimum value is 31 and the maximum value is 98. If the group distance is 8, these data can be divided into two groups______ Group
- 8. Regroup the numbers in the sequence {3 ^ n}, {3}, {3 ^ 2,3 ^ 3}, {3 ^ 4,3 ^ 5,3 ^ 6} Find the sum SN of N numbers in the nth group
- 9. How to add the numbers of the series together to form a total in excel?
- 10. What is the reason for using group median to represent the general level of variable value in group interval sequence?
- 11. How does excel calculate cumulative frequency and cumulative frequency? &Who knows how to use Excel to calculate [cumulative frequency] and [cumulative frequency]
- 12. Given that the opposite number of a is 1 and 3 / 2, and the opposite number of B is - 2 and 2 / 1, find the value of the algebraic formula a-2b / A + 3B
- 13. 12 of a number is 90 more than 13. This number is______ .
- 14. 3 and 4 / 5-2.7 = 1 / 5 of the number a is equal to 1 / 6 of the number already counted, the number a is 90, and the number already counted is () One ninth of an eight kilogram is as heavy as one eighth of a nine kilogram () right or wrong
- 15. Use the numbers 0,1,2,3,4,5 to form a number without repetition 1: How many 6 digits can be made up 2: How many natural numbers larger than 300000 can be formed 3: How many four digits can be made up that are multiples of 25 We need to calculate the process
- 16. Use numbers 0, 1, 2, 3 and 4 to form numbers without repeating numbers. (1) how many five digit numbers can be formed? (2) how many odd five digit numbers can be formed? (3) how many positive integers can be formed?
- 17. The four numbers 1, 2, 3 and 4 can be used to form many four digit numbers without repetition. What is the sum of all these four digit numbers? Write the formula (preferably comprehensive), the answer, fast! Kneel down for the answer!
- 18. Adding a percent sign to a number reduces it by 9.9%, which turns out to be ()
- 19. A number will be increased by 19.8 after the percentage sign is removed?
- 20. If you add a percentage sign to a number, the number will be reduced by 29.7______ .