w**g 发帖数: 8 | 1 有如下两列数据:
3 2
2 4
9 6
1 8
6 10
第一列为原始数据, 第二为bin。Excel Analysis tools中Histogram可以用来计算第
一列数据的频率(以第二列为bin). 但是Histogram 不能自动执行。
我的问题是:怎样在第三列用Excel function计算出相应bin的频率。我用如下
function但其结果与Histogram所得结果不一样
A3=(countif($A$1:$A$5,"<"&B2)-countif($A$1:$A$5,"<="&B1))/count($A$1:$A$5)。
不知错在那?或有更好的function? Thanks much! | e********0 发帖数: 12 | 2 On the Tools menu, click Data Analysis.
In the Analysis Tools box, click Histogram, and then click OK.
Under Input in the Input Range box, enter the cell reference for the range
of data you want to analyze.
Under Input in the Bin Range box, enter the cell reference to a range that
contains an optional set of boundary values that define bin ranges.
Note If you omit the bin range, the Histogram tool creates a set of evenly
distributed bins between the data's minimum and maximum values. However,
b |
|