Thank you for your time and help in advance.

Trendline equation is a formula that finds a line that best fits the data points. Microsoft Excel plots the incorrect trendline when you manually substitute values for the x variable. 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? Workaround More information Symptoms The equation that is displayed for a trendline on an XY Scatter chart in Microsoft Excel is incorrect. 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.

Before you create a trendline: You can add trendlines to bar, line, column. This is useful for a visual display, but you can also calculate the formula of the line using Excel’s SLOPE and INTERCEPT functions. 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. You can add trendlines to see patterns in your charts. Excel has features that allow you to plot the data pairs graphically in a chart, add a trendline (calibration curve), and display the calibration curve’s equation on the chart. 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.

Excel how to show trendline equation