Finding equation between two sets of noncontiguous data

V

vijaya

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To find equation for two sets of non contiguous data 2
Match 2 set data and combine to 1set 2
Excel Equation Help 1
trend data, with twist 1
Missing data when using TREND function 0
Estimating costs 0
Arranging data 3
Multiple If statements, Calculating quarterly % holding costs 0

Top