+ Reply to Thread
Results 1 to 5 of 5

Gam

  1. #1
    Registered User
    Join Date
    05-08-2020
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    35

    Gam

    Is there a way to build a Generalized Additive Model in Excel?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Gam

    I'd never heard of a GAM so I can't help personally. However, Googling: Generalized Additive Model in Excel comes up with a lot of relevant pages and videos.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-08-2020
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    35

    Re: Gam

    Thanks. My search seems to suggest that to do it, I would have to buy some add-on app. I was hoping someone might have figured it out with the native Excel

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

    Re: Gam

    Excel (and spreadsheets in general) are a very useful programming language for developing many different analysis models. As with any programming language, programming usually begins by first understanding the model you want to program. I would say it is generally unwise to assume that any of us on the forum are knowledgeable enough in whatever this "generalized additive model" is to program it into Excel from scratch without some instruction on the model. Help us understand what a Generalized Additive Model is with all of the mathematical and statistical principles necessary to understand, and we should be able to help you program it into Excel.

    Are you required to program the entire thing from scratch? I put "Generalized Additive Model Excel" into my favorite search engine and the first result was a tutorial for a 3rd party add-in (based on R??) that claims to do this in Excel as a plug and play add-in https://help.xlstat.com/6762-general...l-or-gam-excel I cannot vouch for its accuracy or utility, but it looked easy enough to use. Would something like that be suitable for you?

    Are you required to use Excel? Naturally in those search results were non-Excel based solutions claiming to do GAMs. Again, if you are not required to program your own from scratch and not required to use Excel, it might be easiest to find a pre-programmed app that has all of the algorithms for GAMs programmed in. Where costs might be incurred, consider whether the cost of paying for an app is, in the long run, less expensive than the investment needed to program the algorithms from scratch.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    05-08-2020
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    35

    Re: Gam

    Thanks MrShorty. I did see the rlstat add-on and was hoping to not have to buy it. I also know this can be done directly in R without using Excel, but I am not that good at R. I was hoping Excel might have a "hidden" built-in function that could help. It looks like that is not the case. Back to learning R for me! Thanks again for the follow up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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