ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I get multiple trend data on one curve? (https://www.excelbanter.com/excel-worksheet-functions/111707-can-i-get-multiple-trend-data-one-curve.html)

Jason

Can I get multiple trend data on one curve?
 
I need to find points in a curve where the data slope changes. I have been
doing this manually and was wondering if there is a trend function I can use
to find these points automatically?

Here is a Very simple example of my data. (usually have 200 points)
1 0
2 10
3 20
4 28
5 36
6 41
7 46
8 51
9 54
10 57
11 60
12 62
13 64
14 65
15 66
16 67

If you graph this, you can plainly see the changes of slope, but the data I
usually use is a smooth curve that I am trying to find Breakpoints for to
linearize the curve. Thanks for any help


All times are GMT +1. The time now is 02:06 PM.

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