Built-in functions

Here is a short-cut that simplifies the calculation of 5d and 57. Enter the values for Dj into your calculator, and use its built-in functions to find the standard deviation. Divide this result by Vd to obtain Sq. You can use the same approach to calculate 57. 

Built-in functional specific recognition and binding, e.g., antigen binding by antibodies or hybridization of nucleic acids ... 

The seven ways (r, through r7) for calculating correlation as the square root of the ratio of the explained variation over the total variation between X (concentration of analyte data) and Y (measured data) are described using many notational forms. For example, many software packages provide built-in functions capable of calculating the coefficient of correlation directly from a pair of X and Y vectors as given by rx (Equation 59-7). 

Alternatively, Matlab s built-in function norm can be used to determine normalisation coefficients and perform the same task. An example for column-wise normalisation of a matrix X with orthogonal columns is given below. It is worthwhile to compare X with equation (2.15) the subspace command can be used to determine the angle between the vectors (in rad) and reconfirm orthogonality. ... 

Recent developments have led to agents with a built-in functional group that allows more rapid metabolism. Initially, the presence of ester groupings, as in suxamethonium, allowed fairly rapid metabolism in the body via esterase enzymes that hydrolyse these linkages. The enzyme involved appears to be a non-specific serum acetylcholinesterase (see Box 13.4). Even better is the inclusion of functionalities that allow additional degradation via an elimination reaction. Such an agent is atracurium. 

Cell B14 gives the number of data points with the formula = COUNT(B4 B7). Cell B15 computes the mean value of y. Cell B16 computes the sum S(q — )2 that we need for Equation 4-27. This sum is common enough that Excel has a built in function called DEVSQ that you can find in the Statistics menu of the INSERT FUNCTION menu. 

A large number of chemical/biological processes will be presented, modeled and efficient numerical techniques will be developed and programmed using MATLAB 2. This is a sophisticated numerical software package. MATLAB is powerful numerically through its built-in functions and it allows us to easily develop and evaluate complicated numerical codes that fulfill very specialized tasks. Our solution techniques will be developed and discussed from both the chemical/biological point of view and the numerical point of view. 

MATLAB comes as one main body of built-in functions and codes, and there are many additional specialized MATLAB toolboxes for various applications. As this book is primarily directed towards undergraduate and beginning graduate students, we have restricted ourselves deliberately to using the main body of MATLAB only in our codes and none of its many toolboxes. 

One such construct is for a "one-shot. Some PLCs provide this as a built-in function, but here it will be presented in terms of separate components. The one-shot is generated by the third rung of ladder logic in Fig. 8-60a. But first examine the fourth rung. The input LL drives the output coil LL1. This coil provides the state of level switch LL on the previous scan of ladder logic. This is used in the third rung to produce the one-shot. Output coil OneShot is energized if... 

The need for an inexpensive, stable and versatile system, which incorporates thymine moieties in the polymer backbone led to design of the vinyl-benzylthymine (VBT) monomer [34]. Its structure is presented in Figure 13.4. This monomer can be synthesized in one step from thymine and vinylbenzyl chloride. The monomer contains several built-in functionalities. 

Stand-alone programs carrying out FAST-MCD and FAST-LTS can be downloaded from the Web site http //www.agoras.ua.ac.be/, as well as MATLAB versions. The MCD is available in the packages S-PLUS and R as the built-in function cov.mcd, and it has also been included in SAS Version 11 and SAS/IML Version 7. These packages all provide the one-step reweighed MCD estimates. The LTS is... 

The principal benefit to students is a built-in function for integrating tabulated heat capacities between specified temperature limits. Without this tool, polynomial formulas in Table B.2 of the text must be integrated term-by-term and the initial and final temperatures must be entered as the limits, with tedious calculations being required for the associated arithmetic. With the Physical Property Database tool, the desired species is selected from a pull-down menu, the initial and final temperatures are typed in, and a single click leads to the calculation of the integral. This feature will be most helpful in Chapters 8 and 9 of the text. 

N/A is displayed when certain built-in functions (especially HLCX)KUP, VLOOKUP or MATCH) contain incorrect arguments. 

Function procedures augment Excel s library of built-in functions. A function macro is used in a worksheet in the same way as, for example, the SORT function. It is entered in a single cell of a worksheet, performs a calculation and returns a single result (or an array result) to the cell in which it is located. For example, a custom function macro named ALPHA can be used to calculate aj, the fraction of an acid-base species in one of its protonated forms HjX at a particular pH. The function takes three arguments the pH of the solution, the range of pKa values of the weak acid and the coefficient j. This function is useful in constructing distribution diagrams, titration curves, and so on. 

A custom function is used in a worksheet formula in exactly the same way as any of Excel s built-in functions. You can enter it in a formula by using Paste Function, or by typing it. The workbook containing the custom function must be open. 

For Excel s built-in functions, the Formula Palette (Step 2 of Paste Function) provides help information about each argument as you begin to enter it. There s no way to provide similar information about arguments in the Formula Palette for custom functions. But since the same description text appears in the Step 1 and the Step 2 dialog boxes, you can provide information about the arguments in the description. Unfortunately the limit for Description is 255 characters. You can provide line breaks in the text by using Chr(lO) or Chr(13), but the Formula Palette can only display two lines of text. 

An Add-In custom function is listed in the Paste Function list box without the workbook name preceding the name of the function, making it virtually indistinguishable from Excel s built-in functions. 

Your custom functions will now be indistinguishable from Excel s built-in functions. By giving them names using lower-case letters, you can distinguish them from Excel s built-in functions. 

The LIMS system is mostly empty when bought. Not a single measurement unit is normally included, nor are there any analytical methods. The system has many built-in functionality to make sure that the data in the database is consistent. It also has engines to take care of updates of status when data is changed. 

Metal-doped silica gels exhibit a wide range of optical properties which allow them to be used for optical and optoelectronic triplications. The preparation is done via the sol-gel process. Emission and absorption maxima as well as quantum yield can be adjusted by built-in functionalized silanes [2] or adsorbed semiconductor or metal colloids, respectively [3,4]. 

Although the Find/Replace function works well for these data, it is not as generally useful as the built-in functions for manipulating strings of alphabetical characters and numbers. These functions are called string functions. We will use string functions to strip the parenthetical uncertainties from the data in column D and produce a column of numerical atomic masses. 

In this spreadsheet exercise, we learn to calculate the mean of a data set. First, we define formulas to calculate the mean, and then we use the built-in functions of Excel to accomplish the task. 

Excel has built-in functions to compute many of the quantities that are of interest to us. Now we shall see how to use them to calculate the mean, or in Excel s syntax, the average. Click on cell C13 and type... 

Spreadsheet Summary In the first exercise in Chapter 3 of Applications of Microsoft Excel in Analytical Chemistry, we use Excel to perform the t test for comparing two means assuming equal variances of the two data sets. We first manually calculate the value of t and compare it with the critical value obtained from Excel s function TINV(). We obtain the probability from Excel s TDIST() function. Then, we use Excel s built-in function TTEST() for the same test. Finally, we employ Excel s Analysis ToolPak to automate the t test with equal variances. 

Spreadsheet Summary In Chapter 3 of Applications of Microsoft Excel in Analytical Chemistry, we use two Excel functions to perform the F test. First, we use the built-in function FTEST(), which returns the probability that the variances in two data arrays are not significantly different. Then we use the Analysis ToolPak for the same comparison of variances. 

Linear least-squares analysis is quite easy with Excel. This type of analysis can be accomplished in several ways by using the equations presented in this chapter, by employing the basic built-in functions of Excel, or by using the regression data analysis tool. Because the built-in functions are the easiest of these options, we explore them in detail here and see how they may be used to evaluate analytical data. 

New Spreadsheet Calculations. Throughout the book we have introduced spreadsheets for problem solving, graphical analysis, and many other applications. Microsoft Excel has been adopted as the standard for these calculations, but the instructions could be readily adapted to other programs. Several chapters have tutorial discussions of how to enter values, formulas, and built-in functions. Many other examples worked in detail are presented in our companion book. Applications of Microsoft Excel in Analytical Chemistry. We have attempted to document each stand-alone spreadsheet with working formulas and entries. 

Determining the inverse of a matrix by hand is a fairly complicated matter. Fortunately, Excel has a built-in function, MINVERSE, that will perform the inversion. It also has a matrix multiplication function, MMULT, that will calculate the product of two matrices. In order to let the spreadsheet know that your instructions concern an entire block or array rather than an individual cell, these two functions require that you first highlight the entire block to which the instruction applies, and then enter the instruction while simultaneously depressing Ctrl, Shift, and Enter. 

The chi-square distribution is used to perform statistical tests on the sample variance. It is highly asymmetric for small values of n, but becomes more symmetric and similar to a normal distribution as n becomes large, such as 20 or 30. The cumulative distribution function of the chi-square distribution is listed in Table 3.4 as a function of v and a, where v = - 1 is the number of degrees of freedom and a is the percentage of the distribution above the particular Microsoft Excel has built-in functions, CHIDIST and CHIINV, that compute a chi-square distribution [5, 6]. 

---