| Excel加权平均计算函数的创建及使用 |
| |
| 引用本文： | 孙曰昌,李光明,梁太涛. Excel加权平均计算函数的创建及使用[J]. 山东国土资源, 2012, 28(10): 51-53 |
| |
| 作者姓名： | 孙曰昌 李光明 梁太涛 |
| |
| 作者单位： | 中国建筑材料工业地质勘查中心山东总队;山东省地质科学实验研究院;山东省地质科学实验研究院 |
| |
| 摘 要： | 利用Excel宏创建加权平均计算函数WeightedAverage(),说明了创建方法,给出了函数代码,通过品位加权平均计算说明了WeightedAverage()函数的使用。同时,对于分散分布的数据,介绍了使用Excel"自动筛选"功能进行计算的方法。
|
| 关 键 词： | Excel 自定义函数 加权平均计算 |
Creation and Use of Excel weighted Average Calculation Function |
| |
| SUN Yuechang,LI Guangming and LIANG Taitao. Creation and Use of Excel weighted Average Calculation Function[J]. SHANDONG LAND AND RESOURCES, 2012, 28(10): 51-53 |
| |
| Authors: | SUN Yuechang LI Guangming LIANG Taitao |
| |
| Affiliation: | 1.Shandong Brigade of Geological Exploration Center of China Building Materials Industry,Shandong Jinan 250100,China;2.Shandong Institute and Laboratory of Geological Sciences,Shandong Jinan 250013,China) |
| |
| Abstract: | By using excel macro, a weighted average calculated function, that is weightedAverage () has been created, creation method has been introduced, and function code has been given. Through grade weighted average calculation, the use of weighted average () has been introduced. At the same time, the calculated method for scatterring data by using excel "AutoFilter function" has been introduced as well. |
| |
| Keywords: | Excel custom functions weighted average calculation |
| 本文献已被 CNKI 等数据库收录！ |
| 点击此处可从《山东国土资源》浏览原始摘要信息 |
|
点击此处可从《山东国土资源》下载免费的PDF全文 |
|
