Thread
:
how can i fill a table with values from repeated regressions
View Single Post
#
2
Tushar Mehta
Posts: n/a
Check out the LINEST and LOGEST functions. LINEST's name and
documentation are misleading. For more on how to use it for non-linear
regressions see Bernard Liengme's
Polynomial regression. How can I fit my X, Y data to a polynomial using
LINEST?
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
i need to run repeated regressions on a large set of data, and put the
resulting values in a table for each column of data in my set. however, i
don't want to repeat the regression function in the data analysis toolpack
and cut/paste the relevant data into my table, 50 times.
anyone know how to do this
Reply With Quote