blocks|key|2356203|text|计算Openoffice中的标准差：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2356204|将输入的数字放在A1列的单独单元格中，通过A10。|ordered-list-item|2356205|将文本：=stdev放在单元格中。OpenOffice应该弹出一些东西来询问参数是什么。双击弹出窗口中的STDEV并遵循说明，或者当它提示您选择输入时，使用鼠标通过A10选择列A10。|CODE|2356206|当您按enter键时，您将计算出标准偏差。使用OpenOffice函数执行相同的操作以获得平均值：average。|2356207|2356208|2356209|RTFM：|2356210|function|2356211|2356212|entityMap|0|LINK|mutability|MUTABLE|url|http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_AVERAGE_function|1|http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_STDEV_function^0|0|I|0|0|4|6|0|1D|7|0|0|0|0|0|8|0|0|0|8|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|17|8|@]|D|@]|E|$]]|$1|I|3|J|5|H|7|18|8|@$9|19|A|1A|B|K]]|D|@]|E|$]]|$1|L|3|M|5|H|7|1B|8|@$9|1C|A|1D|B|K]]|D|@]|E|$]]|$1|N|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1G|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|1H|8|@]|D|@$9|1I|A|1J|1|1K]]|E|$]]|$1|T|3|S|5|6|7|1L|8|@]|D|@$9|1M|A|1N|1|1O]]|E|$]]|$1|U|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]|12|$5|X|Y|Z|E|$10|13]]]]

Calculate Standard Deviation in Openoffice:

<ol>
<li>Put the input numbers in separate cells of column A1 through A10.</li>
<li>Put the text: <code>=stdev</code> in a cell. OpenOffice should popup something to ask you what the parameters are. Either double click the STDEV in the popup and follow the directions, or when it prompts you to select input, use the mouse to select columns A1 through A10</li>
<li>When you press enter, you will have calculated the standard deviation. Do the same thing to get the mean by using the OpenOffice function: <code>average</code>.</li>
</ol>

RTFM:

<a href="http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_AVERAGE_function" rel="nofollow">http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_AVERAGE_function</a>

<a href="http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_STDEV_function" rel="nofollow">http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_STDEV_function</a>

blocks|key|2152976|text|正在寻找一个类似的问题的解决方案，并通过网站和我自己的修补找到了一个，所以回来分享我学到的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2152977|如果您的列有标题，在我的例子中，Price/Gal可以使用它作为列的名称，这样就可以找到整个列的平均值，而不必定义范围。|offset|length|style|CODE|2152978|所以在我的具体案例中：|2152979|=ROUND(AVERAGE('Price/Gal');3)|code-block|syntax|javascript|2152980|..effectively将标题为"Price/Gal“的整个列的平均值舍入小数点第3位。|2152981|在使用像/+(公式函数)这样的符号的情况下，您必须记住使用撇号，就好像它的标题是pricegal，Calc会在键入公式时修复公式，但是当Price/Gal+Calc被混淆时。我就是这么想出来的。我把它命名为pricegal，然后重新命名它，Price/Gal和Calc也修正了公式。用撇号暗示我做错了什么。|2152982|或者，假设当您选择整行时，在左上角的下拉菜单中，它将读取A1:A1048576等，您也可以重命名该列。虽然我对此有意见，但对我来说似乎很混乱.不过，如果你没有头衔的话，那就是我想的方法了。(这是从其他地方来的，但可能对以后寻找的人有用)|2152983|entityMap^0|0|G|9|0|0|0|0|4|1|14|8|1W|9|2V|8|3C|9|0|S|B|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|11|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@$D|14|E|15|F|G]|$D|16|E|17|F|G]|$D|18|E|19|F|G]|$D|1A|E|1B|F|G]|$D|1C|E|1D|F|G]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1E|8|@$D|1F|E|1G|F|G]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|V|$]]

Was looking for a solution to a similar issue, and found one through a combination of websites and my own tinkering; so came back to share what I learned.

If your column has a title, in my case <code>Price/Gal</code> you can use that as the name of the column so you can find the mean of the whole column, without having to define the range.

so in my specific case:

<pre><code>=ROUND(AVERAGE('Price/Gal');3)
</code></pre>

..effectively rounding the average of the entire column titled "Price/Gal" to the 3rd decimal place.

In situations where you use a symbol like <code>/</code> (a formula function) it is imperative you remember to use the apostrophes, as if it's title is <code>pricegal</code> Calc would fix the formula as you type, but with it as <code>Price/Gal</code> Calc gets confused.. Which is how I figured this out.. I named it <code>pricegal</code> and then just renamed it <code>Price/Gal</code> and Calc fixed the formula as well.. using apostrophes, hinting to me what I did wrong.

Alternatively, supposedly when you select a whole row, in the drop down menu in the upper left corner, which would read <code>A1:A1048576</code> or the like, you can rename the column as well.. though I had issues with this and just seemed messy to me.. though if you don't have a title, that'd be the way to do it I guess. (That one came from elsewhere, but could be useful to whoever looking later)

I have several data columns with 400 to 500 entries in each in a Calc spreadsheet. For each of these columns, I would like simply to be able to find the mean and standard deviation, but don't know how to proceed. 

Can someone please direct me step-by-step on how to do this in simple and not technical language?

Finding the mean and standard deviation of a data column in OpenOffice Calc

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在一个Calc电子表格中有几个数据列，每个列有400到500个条目。对于这些列中的每一列，我只希望能够找到平均值和标准差，但不知道如何继续。有人能一步一步地指导我如何用简单而非技术性的语言来做这件事吗？

问在OpenOffice Calc中求数据列的均值和标准差
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OpenOffice Calc中求数据列的均值和标准差EN