My question: Why does the equation, which is based on the values from the sensor, give a different result than expected if I plug in the numbers manually? Am I missing something?įor example, in the image below if you plug in 7ml instead of x you get a value of about 45 but the actual value on the trendline is somewhere near 57.
Strangely, if I eye-ball it, it gives a value similar to the sensor readings. Now, although it is a linear relationship as shown in the image below, if I try to find the expected sensor reading or volume by plugging in the number in the equation, I get a totally different number than the expected output from the graph and from the sensor output. After collecting 5 data points for each volume ( 0ml, 5ml, 10ml.), I found the average and plotted the sensor readings vs. I am recording data readings from a sensor based on the water volume in a tank. I apologize if this question should be somewhere else but I could not find a seperate section for excel related questions.
