Results 1 to 6 of 6

Math Help - need help with excel formula

  1. #1
    Newbie
    Joined
    Aug 2009
    Posts
    1

    need help with excel formula

    hi there,
    I have to create a formula in excel that will list 601 evenly spaced points in between the numbers (-2,10) and i have no clue how to go about this. Thanks for all the help!
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,100
    Thanks
    67
    Quote Originally Posted by mx15 View Post
    hi there,
    I have to create a formula in excel that will list 601 evenly spaced points in between the numbers (-2,10) and i have no clue how to go about this. Thanks for all the help!
    What would be your answer if it was 3 evenly spaced points?
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Super Member
    Joined
    Jan 2009
    Posts
    591
    Quote Originally Posted by mx15 View Post
    hi there,
    I have to create a formula in excel that will list 601 evenly spaced points in between the numbers (-2,10) and i have no clue how to go about this. Thanks for all the help!
    for 1 evenly spaced point between -2 & 10

     \dfrac{10 - (-2)}{2} = 6

    -2, -2+6*1, 10
    or
    -2, 4, 10

    --
    for 2 evenly spaced points

     \dfrac{10 - (-2)}{2+1} = 4

    -2, -2+4*1, -2+4*2, 10
    or
    -2, 2, 6, 10

    --
    for 11 evenly spaced points

     \dfrac{10 - (-2)}{11 +1 } = 1

    -2, -2+1*1, -2+1*2, -2+1*3, ... , 10
    or
    -2, -1, 0, 1, 2, 3, 4, ...


    --
    for 99 evenly spaced points

     \dfrac{10 - (-2)}{99 +1 } = 0.12

    -2, -2+0.12*1, -2+0.12*2, -2+0.12*3, ... , 10
    or
    -2, -1.88, -1.76, -1.64, ...

    --

    There is a pattern.

    For 601 evenly spaced points between -2 and 10, well, that is left as as exercise for the reader.



    Follow Math Help Forum on Facebook and Google+

  4. #4
    Master Of Puppets
    pickslides's Avatar
    Joined
    Sep 2008
    From
    Melbourne
    Posts
    5,236
    Thanks
    28
    put -2 in A1

    put 10 in A603

    put =A1+($A$603-$A$1)/602 in A2 and fill down to A602
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Master Of Puppets
    pickslides's Avatar
    Joined
    Sep 2008
    From
    Melbourne
    Posts
    5,236
    Thanks
    28
    Each cell should grow by 0.0199335548172757
    Follow Math Help Forum on Facebook and Google+

  6. #6
    MHF Contributor
    Joined
    Dec 2007
    From
    Ottawa, Canada
    Posts
    3,100
    Thanks
    67
    Quote Originally Posted by mx15 View Post
    hi there,
    I have to create a formula in excel that will list 601 evenly spaced points in between the numbers (-2,10)
    If you make that 599 instead, you get 12/600 = .02; more manageable...
    Anyhow, my point is: WHY list 599 numbers in between -2 and 12:
    [-2] - 1.98, - 1.96, ...... 11.96, 11.98 [12] ?
    WHAT is the purpose?
    Isn't it enough for you to know that if 2 post holes are dug, ONE post
    in between will create TWO sections? Or n posts will create n+1 sections?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. help in excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: May 26th 2011, 05:29 AM
  2. Replies: 4
    Last Post: May 18th 2009, 11:16 PM
  3. Looking for a Keyword ranking formula on a Data set in excel
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: April 7th 2009, 09:27 AM
  4. excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: January 21st 2008, 05:24 AM
  5. Excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: August 13th 2007, 05:26 PM

Search Tags


/mathhelpforum @mathhelpforum