[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
rayev0086
Newbie

Joined: 31 Oct 2007
Posts: 1

 Posted: Wed Oct 31, 2007 2:30 pm    Post subject: Creating specific ranges for charts 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
uros
Super User

Joined: 22 May 2003
Posts: 601
Location: Slovenia

 Posted: Thu Nov 01, 2007 10:48 am    Post subject: 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
jrkrideau
Super User

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

Posted: Fri Nov 02, 2007 6:10 am    Post subject: Re: Creating specific ranges for charts

 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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