Excel graphs produced

Note that for box and survival plots, PROC GPLOT is listed as an alternative. Although PROC BOXPLOT and PROC LIFETEST produce excellent graphs by themselves, sometimes it is necessary to make modifications to the output in a way that these procedures cannot handle directly. When modifications are needed, PROC GPLOT is an excellent choice. Also note that PROC REG and PROC UNIVARIATE are listed as options for scatter plots and box plots, respectively, as they can be useful in producing lower-resolution graphics for statistical appendices. 

In addition to the simple Eh-pH graph shown in Figure 9.3, three-dimensional Eh-pH graphs can be produced. Known quantities of a pollutant can be added to a number of different soil suspensions and its degradation at different combinations of Eh and pH measured. In this way, the optimum conditions for the decomposition of the pollutant in question can be determined. An excellent example of this is the decomposition of pentachlorophe-nol and hexahydro-l,3,5-trinitrol,3,5-triazene in soil and water under various Eh-pH conditions as illustrated in the papers by Petrie et al. [9] and Sing et al. [10]. 

Centre die data and produce three scores plots, those of PC2 vs PCI, PC3 vs PCI and PC3 vs PC2. Label each point with pH (Excel users will have to adapt the macro provided). Comment on these plots, especially in the light of the correlation graph in question 3. 

All graphs in this text have been produced in Excel. The graphics facilities are fairly good except for 3D representations. This section will briefly outline some of the main features of the Chart Tool useful for applications in this text. 

Whenever possible, line and bar graphs should be constructed with the use of computer graphing programs (CricketGraph, Excel, Lotus, etc.). Aside from the fact that they produce graphs that are uniform and visually attractive, they have the added capability of fitting non-ideal data to a best-fit line or polynomial equation. This operation of fitting a set of data to a best-fit line becomes extremely im-... 

This graph was produced by EXCEL after importing the WKl file produced by "Results Spreadsheet" menu of ChemSep. 

We will now add a few finishing touches. The numbers for the horizontal scale in Fig. 1.3-2 are placed just below the horizontal axis, aty= 0. It is nice that Excel selects and labels the scales for you, automatically, but you may want to have the numbers outside rather than inside the graph area. In that case, point with your mouse to a number with the horizontal axis, and click on it. This will result in two black blocks, one on each end of the axis, showing that you have activated the axis. Right-click to produce a small popup menu, and click on Format Axis, then select the tab Patterns, click on Tick mark lables Low, and end with OK. 

Excel can be used to produce graphs of various kinds (Excel refers to graphs as charts ). We present a procedure to constmct a two-dimensional graph using the Chart Wizard. The graph is constracted from values of an independent variable in one column values of a dependent variable in another column. These values must first be loaded into the columns. After the values have been loaded into the spreadsheet, you follow the procedure ... 

Mathematica can produce sophisticated graphs, including two-dimensional graphs and perspective views of three-dimensional graphs. Graphing a function is easier than with Excel, since you do not have to fill columns with values of the variable. 

Granules produced by the Granurex are dense and spherical in shape. The pictures and graphs shown in the following text demonstrate how the Granurex processes ciprofloxacin from a 7 pm poorly flowing powder to 200 pm granules with excellent flow characteristics. 

It is simple to model this equation using a spreadsheet (such as EXCEL), or programs such as MATLAB, or graphics calculators. However, it must be borne in mind that the logarithmic model does not work at very low currents, especially at zero. It is best to start the plots with a current of l.OmAcm. As an example, we have given below the MATLAB script file that was used to produce the graph in Figure 3.1. 

Excel has very good plotting capabilities. Unfortunately, it is not possible in Excel to simply give a command such as plot(/(x)). It is necessary to produce a list or table of x and/(x) values and to graph the resulting data. This is best illustrated by an example. 

Shown in Figure 7.3 is a plot of the original data produced with Excel. Note the regression equation that is displayed on the graph, which was calculated by Excel... 

---