Plots, Curve-Fitting, and Data Modeling in Microsoft Excel This handout offers some tips on making nice plots of data collected in your lab experiments, as well as instruction on how to use the built-in curve-fitting routines in Microsoft Excel. So your formula so far is: =STDEV(B2:B14)/ Standard Curves Analysis Introduction A standard curve is used to calibrate an instrument or assay. Open the Excel sheet that contains your data. The higher the SD value wide the bell curve, and the smaller the SD value, the slimmer the bell curve is. 146 curve fitting as was done in the linear and quadratic curve fit examples. Right-click the data series and select Add Trendline. standard curve equation excel Non-linear calibration curve method (CalCurveQuadFit.
