Numerical (Second) Derivative of Time Series DataFirst and second order derivatives are often used in chromatography to detect hidden peaks. The time series data consists of Instrumental Response vs. Time at very short time intervals (250 Hz). I wanted to calculate the second derivative of the data numerically in Excel. The simple option is that we calculate the first derivative and then calculate the first derivative of the first derivative to get the second derivative. The other option is to use the direct approach using central difference formula for the second derivative. The question is about the denominator of the second derivative from the central difference formula. It should the square of the time interval. This is my understanding and it is consistent dimensionally for example distance x (m) becomes acceleration (m/s2) as the second derivative of x.A reviewer wrote a rather denigrating comment saying that there is a lack of understanding of the second derivative "definition" where the authors assert that the definition of a second derivative requires division by the square of the time interval. This reference to the square of a time interval suggests a worrying lack of understanding of the nature of the derivative d 2 d t 2 as an operator and not as an algebraic variable. Do mathematicians agree with the above comment? Can we interpret d 2 d t 2 as if it is repeating the d operator twice divided by time interval squared? Thanks.

Question

Numerical (Second) Derivative of Time Series DataFirst and second order derivatives are often used in chromatography to detect hidden peaks. The time series data consists of Instrumental Response vs. Time at very short time intervals (250 Hz). I wanted to calculate the second derivative of the data numerically in Excel. The simple option is that we calculate the first derivative and then calculate the first derivative of the first derivative to get the second derivative. The other option is to use the direct approach using central difference formula for the second derivative. The question is about the denominator of the second derivative from the central difference formula. It should the square of the time interval. This is my understanding and it is consistent dimensionally for example distance x (m) becomes acceleration (m/s2) as the second derivative of x.A reviewer wrote a rather denigrating comment saying that there is a lack of understanding of the second derivative &quot;definition&quot; where the authors assert that the definition of a second derivative requires division by the square of the time interval. This reference to the square of a time interval suggests a worrying lack of understanding of the nature of the derivative             d      2              d              t        2             as an operator and not as an algebraic variable. Do mathematicians agree with the above comment? Can we interpret             d      2              d              t        2             as if it is repeating the d operator twice divided by time interval squared? Thanks.

pyphekam · Accepted Answer

For a series of discrete values       x    2   at regular intervals of time h, the central derivate at       x    i   is                    x        ˙              i    =                    x                  i          +          1                    −              x                  i          −          1                            2      h      This is preferable because                     x                  i          +          1                    −              x        i              h   the average slope of the following interval and not exactly at the point i.To get the second derivative apply the above to the first derivative                                                        x              ¨                                i                                    =                                                                              x                  ˙                                                            i                +                1                                      −                                                            x                  ˙                                                            i                −                1                                                          2            h                                                            =                                                                              x                                      i                    +                    2                                                  −                                  x                                      i                                                                              2                h                                      −                                                            x                                      i                                                  −                                  x                                      i                    −                    2                                                                              2                h                                                          2            h                                                            =                                            x                              i                +                2                                      +                          x                              i                −                2                                      −            2                          x              i                                            4                                      h              2                                          The above definition is related to the Verlet Integration, also known as the leap-frog method since the derivative at i does not contain the value       x    i  .

Numerical (Second) Derivative of Time Series Data First and second order derivatives are often used

Answered question

Answer & Explanation

New Questions in Pre-Algebra