Is there a way to build a Generalized Additive Model in Excel?
Is there a way to build a Generalized Additive Model in Excel?
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
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
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.
Originally Posted by shg
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks