![]() 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? 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. In the opening Format Trendline pane, check the Polynomial option, and adjust the order number in the Trendline Options section, and then check the Display. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |