Line-to-line amplitude

[lafbraga]

Friends good night.

Help me solve an issue that I'm not able to solve.

Image a table with two columns

In one analysis and in the other results. For example:

Analysis column - Result column

Turbidity - 1.0

Color - 6.0

Ph - 7.0

Conditionivity - 147

Turbidity 1.2

Color - 6.2

Color - 6.6

Ph - 7.2

There are several mixed analyses.

How would I calculate the amplitude line by line according to a filter applied in a data segmenter.

Type: If I select COLOR, Bi makes an imaginary column with the color values ​​and calculates it like this:

Color - "Imaginary Table"

6.0 - null

6.2 - 0.2 (6.2-6.0)

6.6 - 0.4 (6.6-6.2)

And finally, return to the average of these values ​​(0.3)

[lbendlin · Accepted solution]

Instead of the average of the difference why not show the standard deviation?

see attached.

[lafbraga]

Yes, @lbendlin.

We were trying to calculate the average of the amplitude precisely to calculate the standard deviation. Until I discovered I could calculate the standard deviation directly.

I resolved it exactly that way. Using the population standard deviation (STDEV.P).

Thanks