ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding equation between two sets of noncontiguous data (https://www.excelbanter.com/excel-programming/344687-finding-equation-between-two-sets-noncontiguous-data.html)

Vijaya

Finding equation between two sets of noncontiguous data
 
Hi
I have data like this:

Q C Q C Q c Formula (or equation)
a 1 10 2 20 3 30
b 4 40 5 50 6 60

I want a relation like y =m x or y= 3*e 0.2 ., or somethign liek that,
like how we get aan equation when we add a trend line. Is it possible to get
the equation for the above arranged data, and when i drag it to the next row
of data can the equation be updated using some trend formula or something...
IS this possible

Thanks


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com