Chart display equation

Keep the default Linear Regression under the type tab and on the jOptions tab select Display equation on chart. This results in... 

Now choose the Options tab and check the boxes for Display Equation On Chart and Display R-squared Value On Chart then press OK. Excel displays the trendline on the chart as a heavy solid line and the equation (with the least squares coefficients) and Rp- value as a title on the chart. 

Now right-click on any data point and then click on Add Trendline. Under Type, select Linear. Under options, check Display equation on chart and Display / -squared value on chart. Then click on OK. The weight of the line can be adjusted... 

Step 2 Put the cursor on any data point and right click (on the Macintosh, use Ctrl-click). A menu appears choose Add trendline. The trendline is added as shown. Put the cursor on the trendline and right click. Choose Format trendline, then Options and click Display equation on chart also choose Display R-squared on chart. The result is Figure E.l notice that the equation in the figure agrees with Eq. (E.8). 

Also select Display equation on chart, then click OK. 

Use Trendline Polynomial Order 2, using the Option to Display Equation on Chart. 

Display equation on chart Display R-squared value on chart OK... 

It is to be expected that the orthonormal function formed by applying equation 3.10, should be a good fit, when normalized, to the numerical radial function obtained by direct solution of the Schrodinger equation for the lithium atom. This proposition is examined in fig3-3.xls, in which the chart, displayed in Figure 3.3, incorporates the Herman-Skillman... 

Click on the "options" tab, and check the "Display Equation on Chart" box (and, if you want, the "Display R-squared value on Chart" box). Click OK. 

Tiendline dial< box, under Tiend/R tession type, select linear, as shown in Figure 14.15. Then dick on the Options tab of the Add Trendline dialog box and to on the Set inter cept= and the Display equation on chart, as shown in Figure 14.16. 

To find a polynomial that fits the data, first highlight the x-y data. Then go to the Excel tool bar and click on Layout Analysis Trendline More Trendline Options. Choose polynomial as type and in the menu select the desired order of the polynomial. (You can try different orders to find which has the best fit.) Make sure the boxes Display Equation on Chart and Set intercept = 0 are checked. Then click Close. 

These equations are used in the construction of the most common type of control chart, a Shewhart chart (Figure 4.1). The vertical axis of a Shewhart chart displays the process mean, x, of the measured values, e.g. of the pesticide concentration in the fruit, and the horizontal axis is a time axis, so that the variation of these... 

We can try with exponential or polynomial types. We also enable Display Equation on chart and Display R-squared value on chart to show us the equations and the coefficient of variation. For the polynomial fitting, we can select the degree in this case, a third degree polynomial is selected. We see that we get better fitting with the polynomial than with the exponential one see Figure 3.10. 

The detector must be sensitive to the radiation falling on it, and the spectrum is very often displayed on a chart recorder. The spectrum may be a plot of absorbance or percentage transmittance (IOO///0 see Equation 2.16) as a function of frequency or wavenumber displayed linearly along the chart paper. Wavelength is not normally used because, unlike frequency and wavenumber, it is not proportional to energy. Wavelength relates to the optics rather than the spectroscopy of the experiment. 

Equation (10) describes the elution curve obtained from a chromatographic column and is the equation of the curve, or chromatogram, that is traced by the chart recorder or computer printer. Its pertinence is displayed in figure 2. 

Consider the example of quantitative NMR. Spreadsheet 6.3 gives the standard uncertainties and relative standard uncertainties of the components of the combined uncertainty. It is usual to graph the relative standard uncertainties, the standard uncertainties multiplied by the sensitivity coefficient [dy/dx uc(x)], or the squares of the latter expressed as a percentage contribution to the combined uncertainty (see equation 6.23). A horizontal bar chart for each component in decreasing order is one way of displaying these values (figure 6.9). 

The spectrophotometer measures and displays the increase in absorbance at 410 nm as a function of time (AA/At). Whether the output from the instrument is in the form of a strip chart or is collected by a computer, the reaction velocities are usually expressed in terms of change in concentration per unit time, or converted to specified units of enzyme activity. The International Unit (U) for enzyme activity is defined as the amount of enzyme that transforms 1 pmol substrate to product in 1 min under specified assay conditions. The SI unit for activity is the katal, which is defined as the amount of enzyme that transforms 1 mol substrate per second under specified conditions. Thus 1 U = 16.7 nkatal. To convert slopes AA/At values) to velocities (v), the following equation is used ... 

Next run the executable program on the CD supplied with this book. Duplicate Fig. 7.13 by clicking on the Run Program button. Please note that all the answers you have calculated are displayed as the answers in Fig. 7.13. The difference in the answers is due to the equation accuracy used for curve-fitting and the inaccuracies we have made in rounding off and reading the data charts. 

The radial distribution function, for the Is radial wave function of the hydrogen atom, is displayed in Figure 1.7. This EXCEL chart is constructed as follows. The broad design is the same as the previous example but now we need to use the appropriate cell entries for the components of equation 1.9 on the radial mesh. 

Enter the following spectroscopic calibration data into Excel and plot the data (insert XY scatter plot) and then add a line of best fit (chart then add trend line), Display the equation of the line and the value. 

The major disadvantage of the time-delay estimation method in Fig. 7.5 is that it is difficult to find the point of inflection, as a result of measurement noise and small-scale recorder charts or computer displays. The method of Sundaresan and Krishnaswamy (1978) avoids use of the point of inflection construction entirely to estimate the time delay. They proposed that two times t and t2 be estimated from a step response curve. These times correspond to the 35.3 and 85.3% response times, respectively. The time delay and time constant are then calculated from the following equations ... 

---