How to Do a Calibration Curve on Excel

1. Run a set of known X variables through the equipment to produce a series of Y outputs.
2. Open Microsoft Excel. In cell A1 type 'concentration.' In cell B1 type 'output' or the appropriate unit of measure for your experiment.
3. Enter experimental concentrations for the X variable in column A, starting at A2.
4. Enter experimental outputs for the Y variable in column B, starting at B2
5. Highlight entire data set.
6. Click the 'Insert' ribbon.
7. Click the 'Scatter' button and select the 'Scatter plot with markers and straight lines.' The graph should now appear and the Excel ribbon should default to design view.
8. Click on the graph. In the Design ribbon under 'Chart layouts,' select 'Layout 9.' The calibration curve is complete. A y=mx b equation will appear in the graph along with the R2 value.