1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

I Approximating and regression method

  1. Apr 7, 2016 #1
    Hi guys,

    I did a few sets of test in determining the natural frequency of a crane lifting loads. From that, I tried to find two constant from its initial function.


    a is the stiffness of the pole that was holding the crane
    b is the weight of the crane
    x is the weight of the load

    The tests were completed by using three different loads on three different position. I plotted the graph as below.


    From the obtained graph and the initial function, I tried to determine the value of constant A and B. By calculating manually, the value of A and B are not constant but it supposed to be constant. I tried using MATHCAD to find the value of the constants by using nonlinear regression method but I am not convince that is a right solution. Any of you know any mathematical approximation method that I can use?
  2. jcsd
  3. Apr 8, 2016 #2


    User Avatar
    Science Advisor

    Excel does linear regression directly. If you want it mathematically, you must calculate:
    1. [itex]s_{1}=\sum x_{j} [/itex]
    2. [itex]s_{2}=\sum x_{j}^{2} [/itex]
    3. [itex]t_{1}=\sum y_{j} [/itex]
    4. [itex]t_{2}=\sum y_{j}^{2}[/itex]
    5. [itex]v_{1}=\sum x_{j}\cdot y_{j} [/itex]
    Assuming that you have n points, you then calculate [itex]a=\frac{t_{1}\cdot s_{2}-s_{1}\cdot v_{1}}{n\cdot s_{2}-s_{1}^{2}} [/itex] and [itex] b=\frac{n\cdot v_{1}-s_{1}\cdot t_{1}}{n\cdot s_{2}-s_{1}^{2}}[/itex]. The regression line is then given by [itex] y=a\cdot x + b[/itex].
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted