+ Reply to Thread
Results 1 to 2 of 2

Savitzky golay filter in excel

  1. #1
    Registered User
    Join Date
    03-02-2016
    Location
    London
    MS-Off Ver
    8
    Posts
    1

    Savitzky golay filter in excel

    Please I know that this issue has been addressed before , I still find it difficult to apply this to my data which I have attached below . I would be grateful if anyone could help provide a formula for Savitzky Golay smoothing in excel 2016 or suggest any excel add-on.
    thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Savitzky golay filter in excel

    It would probably help us help you if you had included some of your failed attempts.

    Here's one discussion from this forum (https://www.excelforum.com/excel-gen...smoothing.html ) that uses a relatively simple SUMPRODUCT() function to implement a 7 point Savitzky Golay smoothing algorithm. To use other n, you would simply need to lookup the convolution and normalization coefficients for you desired n. This page (http://www.statistics4u.info/fundsta..._savgolay.html ) looks like a good overview with links to more detailed derivation of the algorithm, a table of coefficients at different n, and links to the original papers.

    IMO, at this point, we need to better understand the steps or parts that you are having trouble with in order to suggest help.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to replace drop down list filter to those normal excel filter?
    By cks1026 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2016, 02:48 AM
  2. [SOLVED] Excel 2007-Adv Filter Copy and Loop with Nested Autofilter Using Values from Adv Filter
    By Southfish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2014, 02:07 AM
  3. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  4. Replies: 1
    Last Post: 02-07-2014, 03:04 AM
  5. Savitzky-Golay function for non-linearity test
    By ahma in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2013, 05:12 AM
  6. Savitzky Golay Smoothing
    By YeahMan in forum Excel General
    Replies: 5
    Last Post: 09-06-2012, 07:08 AM
  7. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1