Hello,
I'm trying to find out information about the SSMEDIAN statistical
function in Gnumeric, and how it differs from MEDIAN.
I have read the description of the function:
median for grouped data as commonly determined in the social sciences
On Mon, Aug 04, 2014 at 11:37:03AM +0100, Steve Greig wrote:
I have been using gnumeric for year on Windows. I just started using Linux
after a long gap and also on a different distro so I am a bit out of my
depth. One of the most important things for me is to have gnumeric. I can't
see it
On Wed, Jun 10, 2015 at 11:31:32PM +0200, txm wrote:
Hi.
When I download a csv from my bank, the euro amounts are terminated by
some funny binary character. What is it and can gnumeric handle it?
My guess is that this is an encoding mismatch.
What you should see is U+20AC, €. If the CSV
On Sun, Jan 17, 2016 at 10:11:59AM -0700, Kathy Groves wrote:
> =sum(B4:B134)
>
> What is wrong with my formula? I am trying to total several columns
Is this a trick question? Why don't you use the mouse to select several
columns and see what cell references you get?
B4:B134 says to select
On Thu, Nov 03, 2016 at 08:02:20PM -0700, Paul wrote:
> Last year, I decided to try doing my income taxes with Gnumeric. I was
> able to program all computations and successfully complete all the
> forms I had to use.
Which country's income tax are you referring to?
--
Steve
Hello,
I am not one of the official Gnome developers, but I work with a lot of
Open Source software and perhaps my experience will be helpful.
If you are merely using the ssconvert software in your own internal
project, without linking to it in your own code, then you don't need to
do
You can unsubscribe by following the instructions here:
https://mail.gnome.org/mailman/listinfo/gnumeric-list
This link appears on the bottom of every email on this mailing list.
Scroll to the bottom of the page and follow the instructions.
On Fri, Mar 01, 2019 at 08:25:23PM +0300, Артём К.
Here is a summary of the results from rounddown. Cells are set to
display 17 decimal places.
input 0.24997
digits rounddown expected
1 0.20001 0.20001
2 0.25000 0.23999
3
Hi,
Do you prefer to be called "nullzwei" or "b"?
I think that your issue is that you believe that roundup and rounddown
do not behave correctly, if that correct?
You have the value:
0.24997
and rounddown(0.24997, 16) returns 0.25 exactly, which is
larger than the
On Sun, May 23, 2021 at 12:42:29PM -0600, Andreas J. Guelzow wrote:
> Hi,
>
> On 2021-05-22 7:26 p.m., Steven D'Aprano wrote:
> >
> >input0.24997
>
> You are playing at the edge of the maximum mantissa length. Did you ever
> try using that
Hi B,
I don't understand your comments here. For example, you say:
> i'm quite sure that 'crossover' between roundup and rounddown can be
> avoided and that 0,30004 can be rounded to 16-digit 0,3
> with IEEE 754 rounding mode 'ties to even'.
I don't understand what you mean by
On Wed, Jul 07, 2021 at 06:01:26PM +0200, newbie nullzwei wrote:
>regarding the 4 being rounded up ... the standard rounding process in
>gnumeric has no access to the digit '4', instead in the process of
>rounding to 16 digits the '4' in 17th place becomes powered up to a ',5'
>
On Wed, Jul 07, 2021 at 06:16:46PM -0400, Morten Welinder wrote:
> Gnumeric's rounding here is indeed done with
>
> round_to_int(x * 10^d) / 10^d
>
> except that round_to_int deliberately misrounds 0.5-1ulp to 1. That's
> not important here.
Thank you Morten for introducing some reality
On Wed, Jul 07, 2021 at 11:35:53AM -0700, John Denker via gnumeric-list wrote:
> This has nothing to do with excel.
> It has nothing to do with gnumeric.
> It's not a bug in the code.
It is a bug in Gnumeric's rounding. "Floating point is inexact" is not
an excuse to sweep incorrect rounding
On Mon, Jul 05, 2021 at 08:23:02PM +0200, newbie nullzwei via gnumeric-list
wrote:
>> I don't understand what you mean by "crossover",
>
>=rounddown(0,24997;16) -> 0,25000, and
>=roundup(0,24997;16) -> 0,249972244, the
>
Hi B,
You should read these:
https://floating-point-gui.de/
https://www.volkerschatz.com/science/float.html
https://randomascii.wordpress.com/category/floating-point/
https://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html
There's a lot of information to digest, but until you
On Thu, Mar 10, 2022 at 12:53:58PM +0100, newbie nullzwei via gnumeric-list
wrote:
>and doesn't stop when gitlab proposes a 'GDK' on a 404 page.
>
>https://gitlab.com/gitlab-org/gitlab-development-kit/blob/master/README.md
Where did this URL come from?
If you go to the GDK repo here:
On Wed, Feb 02, 2022 at 07:00:45PM +0100, newbie nullzwei via gnumeric-list
wrote:
>1. could someone please check if it is correct that statfuns.xls in cell
>F22 calculates
>15.0750001 as average of 33.9; 23.3; -1.3 and 4.4?
I don't have access to the spreadsheet just now,
On Sun, May 29, 2022 at 11:14:02AM +0200, newbie nullzwei via gnumeric-list
wrote:
>the result of sin(x) for x = pi() in gnumeric is 1.2246467991473532E-16,
>and thus somewhat off from the correct value '0'.
That is incorrect.
sin(π) = 0 but pi != π, it is (approximately)
On Sat, May 28, 2022 at 12:43:45AM -0700, John Denker via gnumeric-list wrote:
> In any serious application it would be better to use tanpi(0.5)
> which produces #NUM! which is IMHO the right answer. Note that
> cospi(0.5) is exactly zero, as it should be.
Can you point me at the source code for
On Thu, Oct 20, 2022 at 02:02:43PM -0400, Morten Welinder via gnumeric-list
wrote:
> For Gnumeric specifically, that means use the "gnumeric" tag on the
> discourse server: https://discourse.gnome.org/tag/gnumeric
> I would personally have preferred to keep the mailing list, but since
> I am not
21 matches
Mail list logo