Chart analysis

1. Rising trend with max Y-value
2. Falling trend with min Y-value
3. Wobbling around a middle Y-value
4. Existing maximum during this period at X point with Y-value
5. Existing minimum during this period at X point with Y-value

hatzisn said:

According to my knowledge no. You will have to google for ways to calculate mathematical trends or best fits. In the university the only analysis for best fit they taught us was mean squares. Please also note that according to the number of points in chart and position of each point in graph (as it is logical - f.e. the ten first points or the ten last) this best fit line changes. I get the feeling though that this is not what you need.

Click to expand...

Dim SubIntervals_qty as int = 10   'the source period is divided into this number parts [ i] (iterable) to compare them
Dim OverallAVG as float    'average Y-value of the whole period
Dim DeltaYPercent as Int = 0.2  'allowed Y-range

1. Rising trend with max Y-value: if AVG(Y)[i+1] >= AVG(Y)[ i]
2. Falling trend with min Y-value: if AVG(Y)[i+1] <= AVG(Y)[ i]
3. Wobbling around a middle Y-value: if AVG(Y)[ i] >= OverallAVG * (1-DeltaYPercent) and AVG(Y)[ i]<= OverallAVG * (1 + DeltaYPercent)
4. Existing maximum during this period at X point with Y-value: .... need to think
5. Existing minimum during this period at X point with Y-value .... need to think

hatzisn said:

video for the least squares method

Click to expand...

rabbitBUSH said:

around the meteorology part

Click to expand...