Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 21 Apr 2014 03:43:59 +0200Create a frequency chart in libreoffice calchttps://ask.libreoffice.org/en/question/32975/create-a-frequency-chart-in-libreoffice-calc/I have one column of data and I want to graph how common/frequent each number is in a chart. How do I do this? I have thousands of numbers in the column, so I don't want to have to count them all, even when sorted out (they range from 1-500, and contain almost every number in between).Mon, 21 Apr 2014 02:58:39 +0200https://ask.libreoffice.org/en/question/32975/create-a-frequency-chart-in-libreoffice-calc/Answer by oweng for <p>I have one column of data and I want to graph how common/frequent each number is in a chart. How do I do this? I have thousands of numbers in the column, so I don't want to have to count them all, even when sorted out (they range from 1-500, and contain almost every number in between).</p>
https://ask.libreoffice.org/en/question/32975/create-a-frequency-chart-in-libreoffice-calc/?answer=32981#post-id-32981One way to do this is to use classes in combination with the `FREQUENCY()` function ([help page](https://help.libreoffice.org/Calc/Array_Functions#FREQUENCY)) in array form. Create a row of classes (perhaps integers from 1-500) via a simple click-n-drag or basic addition formula. The function can then be used to determine how many occurrences of each datum fall within each class. There are other methods using VLOOKUP() and MATCH() functions in array form.Mon, 21 Apr 2014 03:43:59 +0200https://ask.libreoffice.org/en/question/32975/create-a-frequency-chart-in-libreoffice-calc/?answer=32981#post-id-32981