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

openoffice-calc mean standard-deviation
David Laing picture David Laing · Apr 2, 2013 · Viewed 9k times · Source

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?

Answer

Eric Leschinski picture Eric Leschinski · Apr 2, 2013

Calculate Standard Deviation in Openoffice:

  1. Put the input numbers in separate cells of column A1 through A10.

  2. Put the text: =stdev 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

  3. When you press enter, you will have calculated the standard deviation. Do the same thing to get the mean by using the OpenOffice function: average.

RTFM:

http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_AVERAGE_function

http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_STDEV_function

Related questions

How to quote a quote with the CONCATENATE function in OOCalc

In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. So in cell B1 I want to do: =CONCATENATE("\"",A1,"\"") OOCalc does not like this, or without the escaping backslash. Does anyone …

Read More
How to add number of days to a date, consider only business days (i.e. ignore weekends)?

I'm trying to create a formula to calculate the n-th Business Date (only Monday to Friday are business days). For simplicity's sake, holidays are not important; only weekends should be ignored. For example: +------------------------------------------------------------------ | A B C +------------------------------------------------------------------ 1 | Starting Date …

Read More
Join two spreadsheets on a common column in Excel or OpenOffice

I have two CSV files with a common column and I want to "Join" the tables together on the common column. For example: Join 'A' with 'B' equals 'Result'. If a one table has a key value that does not …

Read More