| View previous topic :: View next topic |
| Author |
Message |
Athalon
General User
Joined: 10 Feb 2006
Posts: 40
Location: Michigan, USA
|
 Posted: Sun Jan 07, 2007 10:16 pm Post subject: Break even point |
 |
|
| Hi- How do I figure the halfway point for a row of numbers. Like the numbers in the rows are: 5,11,45,12,98,32,55,75 What is the halfway point? Thanks. |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Mon Jan 08, 2007 1:51 am Post subject: |
|
|
I don't quite follow what you want.
Do you want the arithmetic mean AVERAGE(), or the middle value in order MEDIAN() (I think), or just the 5th number out of 9 ignoring the actual size of the numbers, or something else? |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Mon Jan 08, 2007 1:51 am Post subject: |
|
|
Use Insert >Function List or the Function Wizard to get lists of functions. I think the one you are looking for is AVERAGE or MEDIAN.
_________________
search forum by month |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Tue Jan 09, 2007 8:07 am Post subject: Re: Break even point |
|
|
| Athalon wrote: | | Hi- How do I figure the halfway point for a row of numbers. Like the numbers in the rows are: 5,11,45,12,98,32,55,75 What is the halfway point? Thanks. |
Depend. As mentioned above there is Median or you could use Count()/2 if you want the number of items in the list divided by 2 which will give you 1/2 the N of the list.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
