Spreadsheets windows

Click the LEFT mouse button on the lower m in the upper right comer of the spreadsheet window to close the window as shown below. You will return to the schematic with all of the properties updated ... 

Note that the default options were chosen in the preceding window. We will look at those further when we explore the subsequent PROC IMPORT code. Now, click OK in the Spreadsheet Options window and then click Next in the Select Table window. The Select Library and Member window opens, which allows for the selection of a SAS library and data set name as follows. 

For reasons discussed above, we needed a complementary, ancillary tool for comparison of the mass spectra of components from multiple urine samples. We desired that the procedure have several characteristics (1) requires little if any manual data entry by the operator (2) utilizes data automatically generated by ChemStation and organized into Microsoft Excel spreadsheets (3) displays both retention times and mass spectral data in the same window (4) minimizes subjective operator judgments and (5) is simple and rapid to use. What emerged after several iterative improvements are the FindPeak macros discussed below. These are largely due to the expertise of Y. Aubut, with valuable input from J. Eggert. 

A simple spreadsheet tool can be used to capture the results of the fraction analyses, provide data visualization, integrate the responses, and thereby establish starting points for the fraction collection window(s), estimation of target purity and amount recovered. This data is useful for extrapolating the number of... 

This window displays a spreadsheet of all of the part s properties. Note that there are more properties than appear on the schematic. Not all properties of a part are displayed on the schematic. To change the voltage of the source, click the LEFT mouse button on the text 12 in the DC column to select the cell ... 

Next, we will attempt to change the name of the source. The property that specifies the name of the source is not displayed in the window. Click the LEFT mouse button as shown below to scroll the spreadsheet to the right ... 

Change of software version(s). Changes in software version(s) require revalidation of the spreadsheet irrespective of whether a new version of Excel or Windows is used. It will be a business decision to stay with the old software version to avoid revalidation and save the resources required. In a large company, this will not be an easy decision. In this case, care should be taken to ensure the use of the appropriate software and spreadsheet version, especially if spreadsheets are used in a shared manner. In the case of a global rollout of new software, revalidation must take place prior to the rollout to ensure the use of validated spreadsheets starting on the day of the rollout. 

To make a graph from the spreadsheet in Figure 2-19d, go to the INSERT menu and select CHART. A window appears with a variety of options. The one you will almost always want is XY (Scatter). Highlight XY (Scatter) and several options appear. Select the one that shows data points connected by a smooth curve. Click Next to move to the next window. 

In a spreadsheet, enter the mean in cell A2 and the standard deviation in cell B2. To find the area under the Gaussian curve from — oo to 900 h in cell C4, we select cell C4 and go to the INSERT menu and choose FUNCTION. In the window that appears, select the Statistical functions and find NORMDIST from the list of possibilities. Double click on NORMDIST and another window appears asking for four values that will be used by NORMDIST. (If you click on help, you will find a cryptic explanation of how to use NORMDIST.)... 

HI Now we use a built-in routine in Excel for the paired t test to see if the two methods in Problem 4-14 produce significantly different results. Enter the data for Methods 1 and 2 into two columns of a spreadsheet. Under the TOOLS menu, select DATA ANALYSIS. If DATA ANALYSIS does not appear, select ADD-INS. Select ANALYSIS TOOLPACK, click OK, and DATA ANALYSIS will be loaded into the tools menu. In the DATA ANALYSIS window, select t-Test Paired Two Sample for Means. Follow the instructions of Section 4-5 and the routine will print out a variety of information including tcafcu ated (which is labeled t Stat) and ftable (which is labeled t Critical two-tail). You should reproduce the results of Problem 4-14. 

We solve Equation A for [HT] by using solver in the spreadsheet, with an initial guess of pH = 10 in cell H10. In the tools menu, select solver and choose Options. Set Precision to le-16 and click OK. In the solver window, Set Target Cell E12 Equal To Value of 0 By Changing Cells HIP. Oick Solve and solver finds pH = 10.33 in cell H10. giving a net charge near 0 in cell E12. 

In the next window, write from what sample and how many of them do you want to assign as Training and press OK. Repeat the process to select the internal Validation samples and the test samples (Query). It may be observed in the spreadsheet how the training samples are highlighted in blue, how the internal validation samples are highlighted in green and the test ones in red. 

It is important to use the most accurate values available for these ratios and to do the calculation on a computer spreadsheet to avoid truncation errors. Once you have the frequency corresponding to 0 ppm, the chemical shift at the center of the spectral window ( the carrier ) can be calculated from the reference frequency of the 13C or 15N channel as we did above for the ll channel. 

Statistical analysis using spreadsheet format experimental design. Macintosh. Anonymous ftp at ftp.sas.com. SAS statistical and data management system on IBM mainframes, VAX, PCs (Windows), Sun, HP, and IBM UNIX workstations. 

Statistical analysis using spreadsheet format experimental design. PCs under Windows, VAX, and mainframes. 

The data table (Figure 11-7) has been compressed by hiding rows containing some of the less interesting data. To obtain the regression parameters, a 3R x 4C array was selected on the spreadsheet and the formula =LINEST(G5 G37,B5 E37,0,1) was entered. Since an array is to be returned, the array formula was entered by using COMMAND+ENTER (Macintosh) or CONTROL+SHIFT+ENTER (Windows). The array of returned values is shown in Figure 11-8. 

In most cases, though, users aren t satisfied to only use the tools that are provided with Windows. Either a particular tool they need isn t included (for example, Microsoft didn t put a spreadsheet application into Windows), or they need a more sophisticated version of a particular application—Wordpad and Word 2000 are both word processors, but that s about where the similarity ends. This demand has led to a booming software industry, and there are literally thousands of applications available that users can install and use with Windows. Because of this, installing and maintaining programs on user s computers is a big part of a technician s job. In order to prepare you for this task, we will discuss the following topics in this chapter ... 

Productivity tools These are applications that help users get their work done. Simple productivity tools such as WordPad and the Calculator are included with Windows we will also be looking at Microsoft Office (the mother of all productivity tools) later in this chapter. Other common applications that fit into this category are the Lotus SmartSuite (which has word processing and spreadsheet components, among others) and Intuit s Quicken for managing finances. 

Window. The window feature allows the screen to be doubled horizontally or vertically and enables you to view two otherwise widely separated areas of the spreadsheet at the same time. One window may be used as a spreadsheet work area and the other for displaying instructions. 

Spreadsheet Summary Chapter 4 of Applications of Microsoft Excel in Analytical Chemistry introduces another way to perform a least-squares analysis. The Analysis ToolPak Regression tool has the advantage of producing a complete ANOVA table for the results. A chart of the fit and the residuals can be produced directly from the Regression window. An unknown concentration is found with the calibration curve, and a statistical analysis is used to find the standard deviation of the concentration. 

---