Spreadsheet graph

Data Table 2 shows values of 0 that are obtained for initial y-position values of 1.5 X 1(T13 m to 7.0 X 10 13 m. (You may like to perform these calculations on a spreadsheet.) Graph the initial y-position versus 0 and draw a smooth curve through the data points. Label this graph Figure C. 

Making spreadsheet, graphs of data, statistical analysis Lotus 1-2-3 Excel. 

Once it has been verified that the data can be properly fit to a one-compartment bolus IV model, a linear regression analysis is performed on the data, with time (t) entered as the independent (x) data, and In(Cp entered as the dependent (y) data. Linear regression analysis can be performed on calculators that handle two-variable statistics, or using spreadsheet, graphing, or statistical analysis software on a computer. The analysis should provide values for the intercept (b) and the slope (m) that provide the best possible fit to the measured data in the form y = b + mx, as illustrated in Figure 10.23. The linear regression analysis also often provides a value called the correlation coefficient (r). 

Theory-building tools. Spreadsheets, graphing and data-display utilities, microworlds and modelling environments are computer-based computational tools that increase students ability to create and understand theories. This ability greatly enhances the potential learning that can be derived from student projects. 

A typical plot of x vs./(x) is considered to have one coordinate dimension, the X, and one data dimension,/(x). These data sets are plotted as line graphs, bar graphs, and so forth. These types of plots are readily made with most spreadsheet programs as well as dedicated graphing programs. Figure 13.1 shows two graphs that are considered to have a one-dimensional data space. 

The property calculation experiment offers a list of 34 molecular properties, including thermodynamic, electrostatic, graph theory, geometric properties, and Lipinski properties. These properties are useful for traditional QSAR activity prediction. Some are computed with MOPAC others are displayed in the browser without units. A table of computed properties can be exported to a Microsoft Excel spreadsheet. 

The example spreadsheet covers a three-day test. Tests over a period of days provide an opportunity to ensure that the tower operated at steady state for a period of time. Three sets of compositions were measured, recorded, normalized, and averaged. The daily compositions can be compared graphically to the averages to show drift. Scatter-diagram graphs, such as those in the reconciliation section, are developed for this analysis. If no drift is identified, the scatter in the measurements with time can give an estimate of the random error (measurement and fluc tuations) in the measurements. 

STRATEGY We need to plot the natural logarithm of the reactant concentration as a function of t. If we get a straight line, the reaction is first order and the slope of the graph is —k. We could use a spreadsheet program or the Living Graph Determination of Rate Constant (first-order rate law) on the Weh site for this book to make the plot. 

Activation energies are found from the Arrhenius equation (Eq. 13). We plot In k against 1/T, with T in kelvins, and multiply the slope of the graph by — R to find the activation energy, with R = 8.3145 J-K 1-mol l. A spreadsheet, curve-fitting program,... 

The rate constant for the alkyl bromide reaction is equal to the slope of the line. The best way to determine a slope is by doing a linear curve fit using a spreadsheet or graphing calculator. Somewhat less accurately, any two points on the line determine the slope ... 

The spreadsheet output should also include a graph of the isopleth location. 

The first APIs were sets of functions that an external component could invoke. If there was ary notion of an object receiving the function calls, it was the entire running executable itself. But the most recent developments in this field have put the executable program into the background (see Figure 10.2). The objects are the spreadsheet cells, the paragraphs in the document, the points on the graph the application software is only the context in which those objects execute. The component architecture determines what kinds of object interactions are allowed. 

Enter data into a spreadsheet and obtain a graph of absorbance versus concentration of the standards. Obtain the least-squares line and its equation (Fig. 5.6). 

Six 25 ml volumetric flasks are filled with 10 ml of the analyte and then 1, 2, 3, 4, 5 and 6 ml of a standard solution containing 6.5 x 10 3 moll-1 of the same analyte. 5.00 ml of color-developing reagent is added to each flask and enough distilled water is added to bring each flask to exactly 25.0 ml. The absorbances of the five solutions were 0.236, 0.339, 0.425, 0.548, 0.630 and 0.745, respectively. Use a spreadsheet to obtain a graph of the data and extrapolate the data to obtain the information needed to determine the initial concentration of the analyte. From the data, estimate the uncertainty of the result. 

You should see a peak in the absorbance at about 660 nm. Obtain the precise maximum absorbance at the peak for each solution, and prepare a bar graph (use spreadsheet software) of absorbance vs. solvent. 

Test your IT skills. Try creating Excel spreadsheets based on the Michaelis-Menten equation (Equation 2.9) and its variants (Equations 2.10 and 2.11). Insert into your spreadsheets your own values for JCm, Vmax, [S], [I] and A) and use Excel to plot Michaelis-Menten, Lineweaver-Burke and Eadie-Hofstee graphs. 

The values for ionization energy in the periodic table in Appendix C are first ionization energies. Construct a bar graph to show the relative sizes of lEi values for the main group elements. If available, use spreadsheet software to plot and render your graph. 

Using graph paper or spreadsheet software, plot and label a graph that shows the rate of formation of oxygen gas. The concentration of O2 (in mol/L) is the dependent variable and time (in s) is the independent variable. 

The last two columns show Tpftr and TcSTRi so one can simply read Ca(j) and T(t) fi om Table 5-1, and, since this is the same problem worked previously, the previous graphs can be plotted simply from this spreadsheet (see Figure 5-10). 

Spreadsheet 6.2. Calculation of the volume and measurement uncertainty of the delivery of a nominal 10-mL pipette under the scenarios given. These are graphed in figure 6.7. 

---