Excel walkthrough
Step-by-step
Use these tabs to walk through the process of building a standard curve in Excel. The panel on the right shows the same thing happening in code.
Typical layout
Standards in
A2:A7, absorbance in B2:B7, unknowns in C2:C?
Interactive curve
Live regression
Edit the concentrations and absorbances. The points, best-fit line, equation and R² update instantly. This mirrors what Excel does when you add a linear trendline.
Standard data
| # | Concentration | Absorbance |
|---|
Try deleting one point or adding noise and watch how the slope and R² change.
Standard curve
Line of best fit
y = mx + c
Excel’s linear trendline uses the same least-squares method. “Display equation on chart” shows
the same numbers you see above (up to rounding).