Can Calc create a relative frequency histogram?

Discuss the spreadsheet application

Can Calc create a relative frequency histogram?

Postby Slonik » Tue Jan 15, 2008 5:45 am

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?
Slonik
 
Posts: 1
Joined: Tue Jan 15, 2008 5:40 am

Re: Can Calc create a relative frequency histogram?

Postby Villeroy » Tue Jan 15, 2008 6:16 am

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26852
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can Calc create a relative frequency histogram?

Postby Dave » Tue Jan 15, 2008 6:23 am

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.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 25 guests