Results 1 to 3 of 3

Thread: R² in gnumeric

  1. #1
    Join Date
    Apr 2006
    Location
    Denmark
    Beans
    36
    Distro
    Ubuntu 6.06

    R² in gnumeric

    Hi

    I've just started using Gnumeric spreadsheet, and like it quite much.
    But when i make a linear regression, the R² seems to be wrong compared to Excel.

    What is wrong ??

  2. #2
    Join Date
    Oct 2005
    Location
    Wyoming, USA
    Beans
    484
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: R² in gnumeric

    Quote Originally Posted by Paradoxx View Post
    Hi

    I've just started using Gnumeric spreadsheet, and like it quite much.
    But when i make a linear regression, the R² seems to be wrong compared to Excel.

    What is wrong ??
    I'd be willing to bet that Excel is what is wrong...
    Read this: http://www.csdassn.org/reportdetail.cfm?ID=508

    If you really need to find out which package is providing the erroneous value, you need to use an actual statistics package (SAS, R, Stata, SPSS, etc.). NEVER assume Excel is correct with statistics.
    This looks nothing like my signature...
    My Page

  3. #3
    Join Date
    Apr 2006
    Location
    Denmark
    Beans
    36
    Distro
    Ubuntu 6.06

    Re: R² in gnumeric

    I think i've figured out what the problem is. I'm trying to find Hubble's constant (the expanding of the universe), and this data's doesn't follow a linear regression very well.
    So Gnumeric skips the worst data, but still get the same eqation.
    So I guess Gnumeric is smarter than Excel

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •