How do I access the curve fit coefficients? For example, I want to curve fit a 2nd order polynomial to a set of data and display the coefficients in separate cells then evaluate the curve fit at a defined X value (say cell B5); i.e. y = A5*B5^2 + A6*B5 + A7. So how do I extract the coefficients without copy and paste and get them in column A?
Next time around I drag and drop in new data and my new Y value is immediately calculated. And I want to do this without a macro. Hopefully I was able to sufficiently describe this.
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
Functional prototypes are a key step in product development â€“ they give engineers a chance to test new ideas and designs while also revealing how the product will stand up to real-world use. And when it comes to functional prototypes, 3D printing is rewriting the rules of whatâ€™s possible. Download Now
The company turned to the Studio System to allow for faster retooling on manufacturing lines, speed the development and prototyping of custom parts and to quickly and inexpensively produce maintenance, repair and operations (MRO) parts to keep manufacturing lines up and running. Download Now
The Desktop Metal Studio System allows John Zink Hamworthy Combustion engineers to rapidly create prototypes, design and test innovative new part designs, and streamline their workflows. Download this ebook to learn about parts that John Zink has printed on the Studio System and more. Download Now
In this white paper, learn the step-by-step method for forming sheet metal parts with 3D printed plastic dies to reduce costs and lead time. Sheet metal forming is the most cost-effective forming procedure today for manufacturing parts at large quantities. Download Now