Thank you for your time and help in advance. Select Linear under Trend/Regression Type, and check Display Equation on chart and Display R-squared. 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. Besides linear trendlines, an Excel chart can display trendlines of the following types: Logarithmic: Used when the rate of change in the data increases or.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |