Let's assume the table you have obtained after the data cleanup is as above, then to find slope you have to the use the formula:
Value = (y2-y1)/(x2-x1)
Note - in the output slope table Row 2 or the first set of values will become 0 as we have no previous value to subtract with to obtain slope
In excel:
B2 in Slope data = 0
C2 in Slope data = SLOPE('Normalized Blanked Data '!B2:B3;'Normalized Blanked Data'!$A2:$A3)
1 | Time (Cell A) | Sample (Cell B) | 2 | 0,5 | 1,22 | 3 | 1,0 | 2,33 | 4 | 1,5 | 2,68 | 5 | 2,0 | 1,08 | 6 | 2,5 | 3,56 |
Let's assume the table you have obtained after the data cleanup is as above, then to find slope you have to the use the formula: Value = (y2-y1)/(x2-x1)
Note - in the output slope table Row 2 or the first set of values will become 0 as we have no previous value to subtract with to obtain slope
In excel: B2 in Slope data = 0 C2 in Slope data = SLOPE('Normalized Blanked Data '!B2:B3;'Normalized Blanked Data'!$A2:$A3)