question for math wizards

Closed Thread
Results 1 to 23 of 23

Hybrid View

  1. - 7th June 2011, 05:30 #1
    Demon's Avatar
    Demon
    Demon is offline SuperMod
    Join Date
    Jan 2005
    Location
    Montreal, Quebec, Canada
    Posts
    3,172

    Did you find this post helpful? Yes | No

    Default Re: question for math wizards

    Yup, I tried three counts in Open Office Calc using 2 versions of the formula and got identical results:

    ((SQRT(cell))*1563)/1000
    ((SQRT(cell*100))*1563)/10000

    Code:
    1  1.563
2  2.210
3  2.707
    Are those above the expected results?


    Or are these?

    Code:
    1  1.560
2  2.188
3  2.657
    Last edited by Demon; - 7th June 2011 at 05:47. Reason: 'cause I can't write formulas out of Calc properly in my posts yet
  2. - 7th June 2011, 11:47 #2
    aajgss's Avatar
    aajgss
    aajgss is offline Junior Member
    Join Date
    Apr 2011
    Location
    NSW, Australia
    Posts
    39

    Did you find this post helpful? Yes | No

    Default Re: question for math wizards

    Hi Robert,

    I think the difference comes from the multiply by 100. This gives the result of for example 3 counts 17 and not 1.732.
    But as I said one decimal place is close enough for me.

    aajgss
  3. - 9th June 2011, 08:17 #3
    aajgss's Avatar
    aajgss
    aajgss is offline Junior Member
    Join Date
    Apr 2011
    Location
    NSW, Australia
    Posts
    39

    Did you find this post helpful? Yes | No

    Default Re: question for math wizards

    Thanks to all for you help to this stage.

    Now I'm off to create a new thread for the next bit. I have the hardware setup and producing data, just a bit of trouble reading it.

    aajgss
« Previous Thread | Next Thread »

Members who have read this thread : 0

You do not have permission to view the list of names.

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

Forum Rules