Thank you for your time and help in advance.
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? R² ( - )² / (y - )² Here is the mean value of y and is the regression equation, here for exponential is y aexb and for power is y axb Here a intercept and b slope. 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. Tried to calculate the R-squared value for the exponential and power trendline type using the following equation.
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. Trendline equation is a mathematically formula that is computed to mathematically defines the line that best fits the data points. I apologize if this question should be somewhere else but I could not find a seperate section for excel related questions.
0 kommentar(er)
