Plotting Experimental Data Points and a Calculated Curve

PLOTTING EXPERIMENTAL DATA POINTS AND A CALCULATED CURVE 

Of course, to plot a calculated curve you need to have an equation that fits the data. It may be the least-squcires straight line (obtained from LI NEST) that best fits the data, or a curve produced by an equation appropriate for the data. 

In the same column as the experimental x values, create a suitable range of X values (the best way is to use AutoFill) to calculate the theoretical curve. The x values can be appended either at the end or the beginning of the experimental x values. 

Enter the expression for ycalc separate column and Fill Down, to produce the calculated values. 

Select the three data series (x, yobsd 3/cak) create an XY chart. If you created an embedded chart, you ll have to select it (dick on it) before you can proceed to customize it. 

---

In general, the Smooth Curve options are not useful, especially if you are plotting data that obeys a particular mathematical relationship, or data with some experimental scatter. To produce a chart with a smooth calculated curve through experimental data points, see "Plotting Experimental Data Points and a Calculated Curve" in Chapter 5. 

---