Plot a standard curve using Microsoft Excel and its Scatter Chart capabilities.
Video of the Day
Open Microsoft Excel
After starting Excel, enter your data pairs in adjacent columns and rows on a new worksheet.
Select the data values with your mouse. On the Insert tab, click on the Scatter icon and select Scatter with Straight Lines and Markers from its drop-down menu to generate the standard curve.
Adding a trendline can predict other values, when one of the data pair is unknown.
To add a trendline to the graph, right-click on the standard curve line in the chart to display a pop-up menu of plot-related actions. Choose Add Trendline from this menu.