Results 1 to 3 of 3

Math Help - [Req] Curve Fitting Using Excel (explained better with attachment)

  1. #1
    Newbie
    Joined
    Dec 2007
    Posts
    3

    [Req] Curve Fitting Using Excel (explained better with attachment)

    Hi All,

    Apologies for a duplication of thread as I needed to explain my query better by use of an attachment.

    In the attachment, you値l see a stock痴 price over 3 consecutive days in yellow (C5:E5). In grey (C9:E9) you値l see formulae for an equation of a curve. In light orange (C7:E7), you値l see the difference between the above 2 mentioned lines. In blue (K7), you値l see a formula, based on the orange figures, that can only be zero if all the orange figures are zero. Select box K7, go to Tools, Solver, Set target cell to K7, Equal to Value of 0, By Changing Cells O1:O2. Then hit Solve. This produces a curve that visually looks like a perfect fit (see graph), however the values of A and B produced (in O1:O2) do not look meaningful, as solver always produces a small negative term for A and a value approximately =1 for B, no matter what values of the share price I put in.

    Ultimately what I知 trying to do is to calculate a speed at which the stock price is turning over the 3 days. My understanding is that I can do this by curve fitting, calculating meaningful A and B values and then differentiating the curve twice (in short, finding 2A).

    Can anyone tell me how to calculate a meaningful speed/rate of turning, either by the above methodology or an alternative one (preferably using excel)

    I hope this is clearer than the original explanation. Thanks In Advance for all Responses
    Attached Files Attached Files
    Last edited by FrCrilly; December 28th 2007 at 10:06 AM. Reason: Problem attaching document
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Eater of Worlds
    galactus's Avatar
    Joined
    Jul 2006
    From
    Chaneysville, PA
    Posts
    3,001
    Thanks
    1
    An Excel file is more than likely too big. I may be able to help with your Excel issue if you outline it.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by FrCrilly View Post
    Hi All,

    Apologies for a duplication of thread as I needed to explain my query better by use of an attachment.

    In the attachment, you値l see a stock痴 price over 3 consecutive days in yellow (C5:E5). In grey (C9:E9) you値l see formulae for an equation of a curve. In light orange (C7:E7), you値l see the difference between the above 2 mentioned lines. In blue (K7), you値l see a formula, based on the orange figures, that can only be zero if all the orange figures are zero. Select box K7, go to Tools, Solver, Set target cell to K7, Equal to Value of 0, By Changing Cells O1:O2. Then hit Solve. This produces a curve that visually looks like a perfect fit (see graph), however the values of A and B produced (in O1:O2) do not look meaningful, as solver always produces a small negative term for A and a value approximately =1 for B, no matter what values of the share price I put in.

    Ultimately what I知 trying to do is to calculate a speed at which the stock price is turning over the 3 days. My understanding is that I can do this by curve fitting, calculating meaningful A and B values and then differentiating the curve twice (in short, finding 2A).

    Can anyone tell me how to calculate a meaningful speed/rate of turning, either by the above methodology or an alternative one (preferably using excel)

    I hope this is clearer than the original explanation. Thanks In Advance for all Responses

    It might help if we could open and read the attachment.

    RonL
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Fitting curve Excel (XLfit)
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: January 26th 2011, 05:13 PM
  2. Curve Fitting
    Posted in the Advanced Algebra Forum
    Replies: 11
    Last Post: November 23rd 2010, 04:55 PM
  3. Curve Fitting
    Posted in the Calculus Forum
    Replies: 8
    Last Post: September 15th 2010, 03:09 PM
  4. Curve Fitting 2
    Posted in the Calculus Forum
    Replies: 8
    Last Post: September 15th 2010, 07:38 AM
  5. [Req] Curve Fitting using Excel
    Posted in the Business Math Forum
    Replies: 4
    Last Post: December 26th 2007, 01:44 PM

Search Tags


/mathhelpforum @mathhelpforum