Math quiz help

Configuration
1

Greetings,
Soooo i want to read the temps from a temp sensor of swimming pool, as there is a prehistoric control unit there, i connected to the temp wires, with A/D converter and i’m getting reads but cant figure out the formula. What my brain can understand that it is exponential linear function. But thats all. What formula can i use if i have this readings:

|reading|real temp|reading prev diff|real prev temp diff|my stuff|
|23669   |  23.1   |                |                      |                |
|23872   |  25.7   |    203         |        2.6        |7.807692308|
|23881   |  25.8   |      9         |        0.1          |    9          |
|23923   |  26.2   |    42          |        0.4         |       10.5     |

And just in case i try to use build in column tags:

reading
23669
23872
23881
23923

real temp
23.1
25.7
25.8
26.2

2

There is definitely a linear correlation:

Trend
Trend1653×993 75.7 KB

To calculate the slope is not too difficult, have a look here:
https://www.mathsisfun.com/equation_of_line.html

3

Omg its really linear LOL, there must be some correction between.
Thank you very much !!!

4

OK…you triggered my curiosity if I could find it and I think I got it close enough…

Temp = (reading - 21771.475806)/81.93548387

1 Like
5

:rofl: :rofl: :rofl: :rofl: :rofl:
Working like a charm, thank you for your curiosity :stuck_out_tongue_winking_eye: :heart:

1 Like
6

Screenshot_31
:stuck_out_tongue:
woohooo

1 Like