Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 20 Dec 2018 05:46:03 +0100Why does Data-Statistics-Sampling not randomly sample?https://ask.libreoffice.org/en/question/176813/why-does-data-statistics-sampling-not-randomly-sample/I created a simple spreadsheet in libreoffice-6.1.4.2 on windows with the following data:
A
Vals
1
2
3
4
I then clicked on Data->Statistics->Sampling, and provided the following input:
Input Range: $Sheet1.$A$2:$A$5
Results to: $B$2
Checked Random
Sample size: 4
I then clicked OK. and got the following result:
A B
Vals Res
1 1
2 2
3 3
4 4
What's the problem? I expected column B to have 4 randomly selected values from column A...decuserThu, 20 Dec 2018 05:46:03 +0100https://ask.libreoffice.org/en/question/176813/