I have two columns of numbers and convert them to vector and I want her formula

[aaeiria]

Hi
I have two columns of numbers and convert them to vector and I want her formula
Please help me.

[teylyn]

Please post a worbook with the source data and some examples of the expected results. Explain the logic that leads to the results.

thanks

[pike]

hi aaeiria
maybe this will help?

[aaeiria]

Please post a worbook with the source data and some examples of the expected results. Explain the logic that leads to the results.

thanks

hi aaeiria
maybe this will help?

I have formula's blue line merely

[aaeiria]

Please help me.

[shg]

Doyou mean you want to see the formula for the best-fit line?

If so, right-click the series and select Add Trendline, tick Linear, and tick Display Equation on chart

If you want the coefficients to appear on the worksheet, you can use LINEST.

[aaeiria]

Doyou mean you want to see the formula for the best-fit line?

If so, right-click the series and select Add Trendline, tick Linear, and tick Display Equation on chart

If you want the coefficients to appear on the worksheet, you can use LINEST.

very very thanks.
it's nice.