OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Creating specific ranges for charts

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
rayev0086
Newbie
Newbie


Joined: 31 Oct 2007
Posts: 1

PostPosted: Wed Oct 31, 2007 2:30 pm    Post subject: Creating specific ranges for charts Reply with quote

I'm trying to make a bar graph chart for 80 data points that range from 1.5 to 2.9. The thing is, I need to make about 10 bars with ranges of .15 each time. Meaning: (1.5-1.64) ,(1.65-1.79) etc. I've been looking around online at tutorials, but I have absolutely no idea how to do this.

I need to turn in this data by tomorrow morning... someone please help me!

Thanks,
Evan
Back to top
View user's profile Send private message
uros
Super User
Super User


Joined: 22 May 2003
Posts: 601
Location: Slovenia

PostPosted: Thu Nov 01, 2007 10:48 am    Post subject: Reply with quote

Hi Evan!

I assume that your data are in column A (A1 to A80).

Next I assume, that you have to represent the number of data in every 0.15 range. If so, read on.
Put value 1.50 in C1.
Put formula
    =C1 + 0.15
in C2 and copy it down to C10.
Put
    =C1+ 0.14
in D1 and copy formula down to D10.
Use commas instead of dots if your language requires it...

Put
    =TEXT(C1;"#.#0") & " - " & TEXT(D1;"#.#0")
in E1 and copy it down to E10. It will be used for X axis of chart. Again use commas in TEXT functions if needed.

Put
    =COUNTIF(A$1:A$80;">="&C1)-COUNTIF(A$1:A$80;">"&D1)
in F1 and copy it down to F10.

Insert chart for range E1:F10...

I'm sure there is some easier solution too, but this will do the job!
Uros
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Fri Nov 02, 2007 6:10 am    Post subject: Re: Creating specific ranges for charts Reply with quote

rayev0086 wrote:
I'm trying to make a bar graph chart for 80 data points that range from 1.5 to 2.9. The thing is, I need to make about 10 bars with ranges of .15 each time. Meaning: (1.5-1.64) ,(1.65-1.79) etc. I've been looking around online at tutorials, but I have absolutely no idea how to do this.

I need to turn in this data by tomorrow morning... someone please help me!

Thanks,
Evan


This is probably too late to help but I have a question for you: Are you sure that you want a barchart? As I read your post it sounds more like you want a histrogram Statistics Canada Histogram

If so you might want to look into the Stat add-on described below or have a look at a statistics package ( see list of sources below)
Calc Add-on for Calc
http://www.ooomacros.org/user.php
OOo Statistics
Author: David Hitchcock
This is a suite of macros to perform basic statistical analysis within OpenOffice. These macros give OpenOffice Calc the functionality which Analysis ToolPak gives Microsoft Excel, and many of these routines are unavailable in Excel.
OOoStat routines are dialog-driven and can be installed in their own menu.
There are three modules of user-called macros:
* Basic Statistics: 1-way ANOVA, Kruskall-Wallis test, t-test, 2-way ANOVA, chi-square contingency table test, Wilcoxon sign-rank test, Correlation, Rank Correlation, Simple Regression, Multiple Regression.
* Multivariate Statistics: Principal Components Analysis, Correspondence Analysis, Multidimensional Scaling, MANOVA, Canonical Discriminant Analysis.
* Applications: Histogram, Text-to-Columns, Latin Square generation, Patterned data
These files are released under the GNU General Public License (GPL)
Latest release: Version 0.4 (February 11, 2005)


Siites for some dedictated statistiscs/graphing packages
(Free or shareware in most or all cases)
http://www.r-project.org/
http://www.epidata.dk/
http://gsociology.icaap.org/methods/soft.html
http://freestatistics.altervista.org/stat.php
http://www.psychnet-uk.com/experimental_design/software_packages.htm
http://data.fas.harvard.edu/micah_altman/socsci.shtml
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group