Is there a 'Sampling' equivalent function (that is present in Excel) in Calc?
I would select a random subset of cells from a big set.
Asked
Active
Viewed 300 times
-1
Community
- 1
- 1
PenguinEngineer
- 295
- 1
- 8
- 30
2 Answers
0
Go to Data -> Statistics -> Sampling.
Documentation is at: https://help.libreoffice.org/Calc/Data_Statistics_in_Calc#Sampling
Jim K
- 12,824
- 2
- 22
- 51
-
It's not present in OpenOffice Calc 4.1.3 . It is an extension? – PenguinEngineer Nov 02 '16 at 16:20
-
It's part of Calc. Can you use LibreOffice? If not, then try Data -> Subtotals, and under "Use functions" select one of the "Sample" functions. Or try Data -> Consolidate with a "Sample" function. Caveat: I have not tested either of these. – Jim K Nov 02 '16 at 19:57
-
What do you mean with "Sample" function? There's not any function related to sampling, just Average, Var, etc – PenguinEngineer Nov 04 '16 at 09:08
-
Well, I have not tested them, but it says "Var (Sample)" and "StDev (Sample)." Anyway it looks like LibreOffice can do what you need. – Jim K Nov 04 '16 at 14:09
-
It seems that with OpenOffice it doesn't work...but it definetely works with LibreOffice – PenguinEngineer Nov 04 '16 at 15:22
-1
You can use the Analysis ToolPak and Analysis ToolPak VBA add-ins which have a sample method. Here's how you can set it up
you could then use it similar to below, however you may want to record a macro or review the function in object explorer to understand the parameters
[atpvbaen.xls].Sample "Input range", "Output range", "R", "Sample size, e.g. 100"
