查找一组数字的分布

Question

我有一组数字，想查看点的分布（点落在什么范围内）。有没有好的软件或代码可以做到这一点？ 我只是想看看主要块在什么范围内......

Answer 1

使用内置函数 FREQUENCY

Form excel 帮助：

Calculates how often values occur within a range of values, and then returns a vertical 
array of numbers. For example, use FREQUENCY to count the number of test scores that
fall within ranges of scores. Because FREQUENCY returns an array, it must be entered 
as an array formula.