Regression formula

[Romoluzzi]

I often use regression in data analysis and produce relevant graph.
Here's the code:

Please Login or Register  to view this content.

As you can see I've tried to "catch" automatically in some way the formula given by the trendlines in the graph area in order to use it for other calculations, but unsuccessful.
Have you any hint on how this can be achieved?
Thanks in advance for your usual precious help.

[Romoluzzi]

No suggestions? not even for the new year?

[shg]

You can use LINEST to get the parameters of the regression.

If you post a workbook with an example, I or someone else will show you how.

[MarvinP]

Does the link below help in resolving your desire?

http://zimmer.csufresno.edu/~davidz/...INESTfull.html

[Romoluzzi]

Here's is another evidence that (almost) always the simplest solution is the hardest to find out..... I hadn't thought about using Excel's LINEST function, my fault.
But at this point I have another question: is there any way to use the 10 parameters generated by LINEST in VBA code? In other words, is it possible in a macro / UDF to set a variable to get the value of the slope, the intercept, etc and to use it in further calculations, WITHOUT actually inputting the array formula in a ten-cell area of the worksheet and/or WITHOUT set the calculation in the VBA procedure?
For example, if I use the macro recorder and input the LINEST formula in the worksheet, I get:

Please Login or Register  to view this content.

I see that there is a VBA instruction to calculate the parameters; is it possible to put some of the 10 values DIRECTLY in variables WITHOUT using the corresponding cells values in the worksheet?

I hope my question is clear and I thank you all for your support.

[DonkeyOte]

Do you mean along the lines of:

Please Login or Register  to view this content.

vResults would be a 2d Array of the results.

[shg]

Or

Please Login or Register  to view this content.

[DonkeyOte]

oops... I do like to over engineer every now and then !

[Romoluzzi]

I wish to thank both DonkeyOte and shg for their valuable help.

[shg]

I do like to over engineer every now and then !

Well, maybe. The versatility of the Evaluate function is something that I continue to enjoy seeing good examples of, as here, and you provide great examples. Among other things (if not in this specific case), Evaluate permits the use of the literal arrays that are so convenient in formulas.