Linest with Multiple Regression without Array Functions
Вставка
- Опубліковано 20 вер 2024
- Instructions on how to use the LINEST function in a multiple regression analysis transparently by using the INDEX function rather than an array function. Excel file available at: 1drv.ms/x/s!Ag...
Thank you so much for this. I've been stuck on a problem (trying to predict the setup that will lead to the minimum drag of on object based on experimental results of different setup changes) for a while and have come back to it a couple months later. Used this method and it's worked brilliantly straight away. I'd thought about kriging but it was much more difficult to implement into a spreadsheet. Thanks again!
excellent and very well demonstrated !
Thank you so much! I could not find an answer for that somewhere else! Its so annoying to copy the formular from the diagram into a cell
Glad I could assist you.
The correct link to the Excel file is : 1drv.ms/x/s!AgtEj5D79IYqgewzy6e3Vc_hlKd60w?e=ob7Wml
Many Thanks!!!
How do you do this with a third degree polynomial trend line?
You can do it with any degree polynomial remember that you need to take your x values and have a squared number and a cube number and treat them as separate inputs. If you need more information please send me an email to Brian@theputts.com
@@brianputt984 Hello, if I use linest function for more then 3rd degree polyniomial, I get only the last coefficients and the rest is always 0. I can't figure this out, it seems like a bug.
Would it be possible for a new link to this sheet(the link is dead). i am trying very hard to repoduce your sheet with no luck, and i am trying to get this polyline stuff worked out it would be great if you could do a 6 order poly line explanation.
Do you still need the excel file?
@@brianputt984 oh yes please i have been working on this a long time ago but it would be nice to see your sheet to validate some of my ditherings many thanks Brian.
@@brianputt984 Would there be any chance, you could serve me with the Excel sheet as well?
@@brianputt984 me too Brian. Would be great. thanks
@@victorh.rampazzo6466 Here is a link to a simple model. If this isn't what you want let me know. 1drv.ms/x/s!AgtEj5D79IYqgew13AjXTyUVLIev4g?e=YRMHAc
Brian