- #1

- 160

- 0

how can i obtain the equation of the curve from excel?

- Thread starter denian
- Start date

- #1

- 160

- 0

how can i obtain the equation of the curve from excel?

- #2

- 160

- 0

any help will be appreciated.

- #3

Integral

Staff Emeritus

Science Advisor

Gold Member

- 7,201

- 56

If your data is linear, you can also use the LINEST command to compute the slope and intercept of the best fit line. This is the same as choosing a linear fit trend line, except the slope and intercept are more easily used to extrapolate (this the official name of extending a trend line beyond your data set.

You can also extrapolate by selecting your data and "drag fill" the column until you get beyond the x value you need. For this to work you need a constant [itex] \Delta [/itex]x in your data.

- #4

- 160

- 0

thank you.

- Last Post

- Replies
- 9

- Views
- 4K

- Last Post

- Replies
- 1

- Views
- 7K

- Last Post

- Replies
- 2

- Views
- 27K

- Last Post

- Replies
- 3

- Views
- 23K

- Replies
- 2

- Views
- 916

- Replies
- 13

- Views
- 6K

- Replies
- 5

- Views
- 667

- Last Post

- Replies
- 4

- Views
- 879

- Last Post

- Replies
- 3

- Views
- 2K

- Last Post

- Replies
- 3

- Views
- 2K