Ask Your Question

Create a frequency chart in libreoffice calc [closed]

asked 2014-04-21 02:58:39 +0100

Twtduck gravatar image

updated 2014-04-21 02:59:18 +0100

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).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 07:02:48.534768

1 Answer

Sort by » oldest newest most voted

answered 2014-04-21 03:43:59 +0100

oweng gravatar image

One way to do this is to use classes in combination with the FREQUENCY() function (help page) 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.

edit flag offensive delete link more

Question Tools



Asked: 2014-04-21 02:58:39 +0100

Seen: 12,165 times

Last updated: Apr 21 '14