Can Calc create a relative frequency histogram?

Discuss the spreadsheet application
Post Reply
Slonik
Posts: 1
Joined: Tue Jan 15, 2008 5:40 am

Can Calc create a relative frequency histogram?

Post by Slonik »

I just spent 30 minutes looking around Calc to figure out how I can order a list of simple data (just 6 digit numbers) from smallest to largest. The long story is that I need to make a histogram... does Calc do that? Or do I need to mess around with the regular chart wizard and split the data up into frequencies manually?
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can Calc create a relative frequency histogram?

Post by Villeroy »

See help on function FREQUENCY.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Dave
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Can Calc create a relative frequency histogram?

Post by Dave »

Slonik wrote:I just spent 30 minutes looking around Calc to figure out how I can order a list of simple data (just 6 digit numbers) from smallest to largest.
Data/Sort from the menu.

Do you mean Bar graph?

David.
Post Reply