研究设计与统计

订阅

MedSci主页 / 所有栏目 / 研究设计与统计

附表１ Excel 统计函数一览表

2012-04-16 生物谷 生物谷

附表表１１EExxcceell统统计计函函数数一一览
关注

附表１ Excel 统计函数一览表 函数名称函数功能 AVEDEV 返回一组数据与其均值的绝对偏差的平均值，用于评 测这组数据的离散度。 AVERAGE 返回指定序列算术平均值。 AVERAGEA 计算参数清单中数值的算数平均值。不仅数字，而且 文本和逻辑值（如TRUE 和FALSE）也将计算在内。 BETADIST 返回Beta 分布累积函数的函数值。Beta 分布累积

附表１ Excel 统计函数一览表

函数名称函数功能

AVEDEV 返回一组数据与其均值的绝对偏差的平均值，用于评

测这组数据的离散度。

AVERAGE 返回指定序列算术平均值。

AVERAGEA 计算参数清单中数值的算数平均值。不仅数字，而且

文本和逻辑值（如TRUE 和FALSE）也将计算在内。

BETADIST 返回Beta 分布累积函数的函数值。Beta 分布累积

本文系梅斯医学（MedSci）原创编译整理，转载需授权！-->

版权声明：
本网站所有内容来源注明为“梅斯医学”或“MedSci原创”的文字、图片和音视频资料，版权均属于梅斯医学所有。非经授权，任何媒体、网站或个人不得转载，授权转载时须注明来源为“梅斯医学”。其它来源的文章系转载文章，或“梅斯号”自媒体发布的文章，仅系出于传递更多信息之目的，本站仅负责审核内容合规，其内容不代表本站立场，本站不负责内容的准确性和版权。如果存在侵权、或不希望被转载的媒体或个人可与我们联系，我们将立即进行删除处理。
在此留言
评论区 (3)
#插入话题
  1. [GetPortalCommentsPageByObjectIdResponse(id=5663, encodeId=5fc4566371, content=很好！, beContent=null, objectType=article, channel=null, level=null, likeNumber=90, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=5cc278205, createdName=haiqilu, createdTime=Sat Apr 20 22:05:00 CST 2013, time=2013-04-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1958710, encodeId=83f91958e10ed, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=20, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Tue Sep 11 23:52:00 CST 2012, time=2012-09-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971000, encodeId=718d19e100091, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Wed Dec 19 15:52:00 CST 2012, time=2012-12-19, status=1, ipAttribution=)]
    2013-04-20 haiqilu

    很好！

    0

  2. [GetPortalCommentsPageByObjectIdResponse(id=5663, encodeId=5fc4566371, content=很好！, beContent=null, objectType=article, channel=null, level=null, likeNumber=90, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=5cc278205, createdName=haiqilu, createdTime=Sat Apr 20 22:05:00 CST 2013, time=2013-04-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1958710, encodeId=83f91958e10ed, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=20, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Tue Sep 11 23:52:00 CST 2012, time=2012-09-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971000, encodeId=718d19e100091, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Wed Dec 19 15:52:00 CST 2012, time=2012-12-19, status=1, ipAttribution=)]
    2012-09-11 维他命

    #CEL#

    0

  3. [GetPortalCommentsPageByObjectIdResponse(id=5663, encodeId=5fc4566371, content=很好！, beContent=null, objectType=article, channel=null, level=null, likeNumber=90, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=5cc278205, createdName=haiqilu, createdTime=Sat Apr 20 22:05:00 CST 2013, time=2013-04-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1958710, encodeId=83f91958e10ed, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=20, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Tue Sep 11 23:52:00 CST 2012, time=2012-09-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971000, encodeId=718d19e100091, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Wed Dec 19 15:52:00 CST 2012, time=2012-12-19, status=1, ipAttribution=)]
    2012-12-19 fzwish20000

    #Excel#

    0