|
|

楼主 |
发表于 2011-8-24 14:39
|
显示全部楼层
天量、地量估算方式
天量:(FINDHIGH(AMOUNT,1,240,1)+FINDHIGH(AMOUNT,1,240,2)+FINDHIGH(AMOUNT,1,240,3)+FINDHIGH(AMOUNT,1,240,4)+FINDHIGH(AMOUNT,1,240,5)+FINDHIGH(AMOUNT,1,240,6)+FINDHIGH(AMOUNT,1,240,7)+FINDHIGH(AMOUNT,1,240,8)+FINDHIGH(AMOUNT,1,240,9)+FINDHIGH(AMOUNT,1,240,10)+FINDHIGH(AMOUNT,1,240,11)+FINDHIGH(AMOUNT,1,240,12)+FINDHIGH(AMOUNT,1,240,13)+FINDHIGH(AMOUNT,1,240,14)+FINDHIGH(AMOUNT,1,240,15)+FINDHIGH(AMOUNT,1,240,16)+FINDHIGH(AMOUNT,1,240,17)+FINDHIGH(AMOUNT,1,240,18)+FINDHIGH(AMOUNT,1,240,19)+FINDHIGH(AMOUNT,1,240,20)+FINDHIGH(AMOUNT,1,240,21)+FINDHIGH(AMOUNT,1,240,22)+FINDHIGH(AMOUNT,1,240,23)+FINDHIGH(AMOUNT,1,240,24))/24/100000000;
地量: (FINDLOW(AMOUNT,1,240,1)+FINDLOW(AMOUNT,1,240,2)+FINDLOW(AMOUNT,1,240,3)+FINDLOW(AMOUNT,1,240,4)+FINDLOW(AMOUNT,1,240,5)+FINDLOW(AMOUNT,1,240,6)+FINDLOW(AMOUNT,1,240,7)+FINDLOW(AMOUNT,1,240,8)+FINDLOW(AMOUNT,1,240,9)+FINDLOW(AMOUNT,1,240,10)+FINDLOW(AMOUNT,1,240,11)+FINDLOW(AMOUNT,1,240,12)+FINDLOW(AMOUNT,1,240,13)+FINDLOW(AMOUNT,1,240,14)+FINDLOW(AMOUNT,1,240,15)+FINDLOW(AMOUNT,1,240,16)+FINDLOW(AMOUNT,1,240,17)+FINDLOW(AMOUNT,1,240,18)+FINDLOW(AMOUNT,1,240,19)+FINDLOW(AMOUNT,1,240,20)+FINDLOW(AMOUNT,1,240,21)+FINDLOW(AMOUNT,1,240,22)+FINDLOW(AMOUNT,1,240,23)+FINDLOW(AMOUNT,1,240,24))/24/100000000;
分别选取最大(小)的10%数据平均值
如果要是懒省事儿的人
其实可以采用中位数来替代效果也差不多 |
|
|