So, the line is essentially filling in the information between the two known points for you so that you can be reasonably certain when estimating the actual temperature when the thermometer is reading 57.2 degrees, but when you have never measured a 'standard' that corresponds to that reading. When you plot those two data pairs as points and draw a line between them (the calibration curve), then assuming the response of the thermometer is linear, you could pick any point on the line that corresponds to the value the thermometer displays, and you could find the corresponding 'true' temperature. Linear Exponential Logarithmic Polynomial Power Moving average Excel trendline equations and formulas Excel trendline equation is wrong - reasons and fixes Excel trendline types When adding a trendline in Excel, you have 6 different options to choose from. This lets you create a series of data pairs that you'll then use to develop a calibration curve.Ī two-point calibration of a thermometer using the freezing and boiling points of water would have two data pairs: one from when the thermometer is placed in ice water (32 ☏ or 0 ☌) and one in boiling water (212 ☏ or 100 ☌). Check the boxes next to Display Equation on chart and Display R-squared value on chart.

On the right side of the screen, the Format Trendline menu will appear. A straight line will appear on the chart. To perform a calibration, you compare the readings of a device (like the temperature that a thermometer displays) to known values called standards (like the freezing and boiling points of water). Right-click one of the points and then select the Add Trendline option. What is a Calibration Curve and How is Excel Useful When Creating One?

How to find trendline equation in excel