1 lab period; work in pairs. Complete the Preparation page before laboratory.
Goals
To learn
To learn the use of a spreadsheet for organizing, manipulating, and plotting data.
Background
Scientists experiment. Normally, the goal of an experiment is to determine how the value of one variable, called the dependent variable, changes as the experimenter systematically alters the value of another variable, called the independent variable. For example, a chemist may be interested in how the volume, V, of a gas sample varies as its pressure, P, is changed; or in how the rate of a reaction changes with the concentration of one of the reactants. There are two common ways of presentin g the results of experiments like these: tabular form and graphical form. Although both methods are commonly used, and are often used together, the graphical method is generally superior because it gives the scientist a visual feeling for the relationship between the dependent and independent variables.
Graphs are usually plotted on a Cartesian axis system as in Figure 1. The vertical axis is called the y-axis (or ordinate) and the horizontal axis, the x-axis (or abscissa). Generally, the value of the dependent variable (or some function of it) is plo tted on the y-axis, and that of the independent variable (or some function of it) on the x-axis. We assume that you have some familiarity with the Cartesian coordinate system and know how to plot a point represented by the ordered pair (x,y) in such an axis system.
A plot of the dependent variable, y, versus the independent variable, x, can be either linear or curved. For example, a plot of temperature in oC versus the corresponding temperature in oF is linear (straight line). On the other hand, a plot of the solubility of a salt such as K2Cr2O7 (potassium dichromate) versus temperature is curved. Although both linear and curved plots can be useful, the linear plot is generally more so, for several reasons. First, linearity or deviations from it are readily seen by eye. On the other hand one cannot tell visually if a curve that resembles a hyperbola is truly hyperbolic. For example, although the curve in Figure 2 looks hyperbolic, it is not obvious from inspection that it actually is. Second, linear plots may be readily extrapolated (extended) into regions which are experimentally not accessible. Extrapolation allows the prediction of the value of the dependent variable under conditions other than those governing the experiment. For these reasons, scientists prefer linear plots. This workshop will focus on these.
The equation governing a linear relationship between two variables, x and y, is given in equation 1, where y is the dependent variable, x is the independent variable, m is a constant called the slope, and b is a constant called the y-intercept.
y = mx + b (1)
These quantities are illustrated in Figure 3. The trick to constructing a linear plot is to cast the functional relationship between dependent and independent variables into the form of equation 1. For example, the relationship between the pressure, P, and volume, V, of a fixed amount of ideal gas at constant temperature is in equation 2.
PV = K (2)
where K = a constant. This equation does not have the form of equation 1. However, dividing both sides by P gives
V = K/P (3)
Equation 3 has the form of equation 1 where y corresponds to V, x to l/P, m to K, and b to 0. A plot of y (V) versus x (1/P) should be a straight line with slope m (K) and intercept zero; i.e., the line should pass through the origin.
Methods for Plotting Graphs
Graphs may be constructed by hand or by computer. A professional scientist or engineer is able to use both methods. The purpose of this workshop is to provide guidance and experience in both plotting methods. The general criteria for con struction of a graph are the same regardless of method. Properly used, they will enable you to produce a plot that has a professional appearance and is easy to read and interpret.
Common Functional Forms in Chemistry
If we agree to use y to represent the dependent variable (the variable measured in the experiment) and x to represent the independent variable (the variable controlled by the experimenter), there are six functional relationships between y and x which occur often in chemistry. These are detailed below. In the following discussion, do not be concerned if you do not understand where the equations come from and what the quantities mean. For now, we are interested only in the forms of the equ ations and how these translate into plots.
Case 1
. y = mx + b. The value of y varies linearly with the value of x.The volume of a sample of gas at constant pressure is related in this way to the temperature in oC. Illustrative data are shown in Table 1.
| Independent Variable, T (oC) | Dependent variable, V (L) |
|---|---|
| 0 | 0.403 |
| 30 | 0.45 |
| 60 | 0.485 |
| 80 | 0.515 |
| 100 | 0.560 |
| 150 | 0.625 |
Clearly V increases as T increases, so a plot of V versus T might be linear. Figure 4 shows such a plot, created using a computer plotting software package. If we put an eye down near the paper and sight along the points, it is clear that they fall alo ng a straight line. The computer has calculated and drawn the straight line which best fits the data. Note that as many points as possible lie near the line, with roughly an equal number above and below it. The line represents the functional relation betw een the dependent variable, V, and the independent variable, T. Slope and intercept, calculated by the computer using the method of linear regression analysis (or method of least squares), are shown in the diagram:
V = 0.001492 T + 0.4019 (4)
The relationship between volume and temperature for a gas is called Charles' Law. The units of the slope, calculated by dividing DV in liters by DT in oC are L/oC. Intercept un its are liters. Several important features of Figure 4 are listed below.
Constraint 2b is usually easier to satisfy when plotting is done by computer. For manual plotting, it is more difficult, because we are restricted by the physical layout of commercial graph paper, with basic intervals of either cm or inches. Each basic interval is further subdivided into 5 or 10 parts. The graph paper you bought for this experiment has the cm as the basic interval with each subdivided into 10 parts. This paper is described as "10 squares (or subdivisions) to the centimeter." The re are usually 24 cm along the long dimension of the paper and 18 cm along the short dimension. In plotting a graph, one must establish a correspondence between the number of units spanned by the variable being plotted and the number of basic intervals available along the axis. The values of t range from 0 to 150 oC. The lower x limit must be £0 and the upper limit ³ 150. However, there are 18 basic intervals along the x-axis. To set up the x-axis so that the left end of the line corresponds to 0 and the right end of the line to l50 would require 150 - 0)/18 = 8.33 oC per cm.
This is an inconvenient number, so constraint 2b is not met. To satisfy both constraints, set the upper limit of the axis at 180 oC. This exceeds 150 and gives a convenient number of variable units per basic interval, specifically, 10 o C per cm. Setting the x-axis up to span the range 0 to 180oC is as close as we can come to using the whole length of the axis, while maintaining plotting convenience. Similarly, V spans the range between 0.403 and 0.625 L, and there are 2 4 basic intervals along the y-axis. The number of variable units spanned is 0.625 - 0.403 = 0.222. The ratio of this number to 24 is inconvenient. Therefore picking lower and upper limits such that a variable range of 0.240 L is spanned gives a convenient correspondence of 0.01 L per cm. The limits used for the y-axis in a manual plot would be set up this way. Finally, the straight line in the manual plot is usually drawn by eye. To calculate the slope in a hand-plot, choose two points which lie on the li ne, not two experimental points. The best straight line averages the data, so a slope calculated from two points exactly on the line is more accurate than a slope based on two experimental points. The two points chosen should lie at the upper and lower ex tremes of the plot, rather than near one another on the line. Again, this is to minimize error in the slope due to error in reading y values from the line. Finally, we choose two points whose x values are convenient--that is, which correspond with lines delineating the basic intervals of the graph paper. Normally this procedure will give values close to the regression values produced in a computer plot.
Whether plotting by hand or computer, setting convenient limits becomes easy with practice, and is one of the goals of this workshop.
Case 2
. y = m/x + b. y is inversely proportional to x.A relationship of this type is that between the volume, V, of a sample of gas and its pressure, P, at constant temperature. Illustrative data is in Table 2.
| Dependent Variable: V,L | Independent Variable: P,atm | 1/P |
|---|---|---|
| 3.67 | 0.10 | 10 |
| 1.45 | 0.25 | 4 |
| 1.02 | 0.36 | 2.8 |
| 0.860 | 0.42 | 2.4 |
| 0.620 | 0.60 | 1.7 |
| 0.4 | 0.90 | 1.1 |
| 0.330 | 1.1 | 0.91 |
As P increases, V decreases, suggesting an inverse relation. A linear plot might be obtained by plotting V versus 1/P. Calculated values of 1/P are given in the 3rd column of Table 2, and a computer plot of V vs. 1/P is in Figure 6. Upper and lower variable limits of the axes have been chosen by the guidelines above. The plot is clearly linear. The slope, calculated by regression analysis, is 0.368 L-atm. The intercept is zero, within experimental error, so the equation relating the variables, called Boyle's Law is
V = 0.368 /P (5)
Case 3
. y = mxn, with n an integer. y is proportional to x raised to an integral power.If n = 1, this equation reduces to case 1; if n = -1, it reduces to case 2 with b = 0. This type of functional relationship occurs frequently in chemical kinetics, where the rate of reaction is often proportional to an integral power of the concentration of a reactant. There are two steps to the graphical analysis of data related by a function of this form.
A plot of ln y versus ln x should be linear, with slope n.
There are two systems of logarithms in common use: logarithm to the base 10 (abbreviated log10); and natural logarithm (abbreviated ln). Natural logarithm is also called logarithm to the base e, where e is the number 2.71828... . These logarithms are defined as follows:
It can be shown that the relationship between the two logarithmic scales is simple:
Once n has been determined,
Table 3 shows the variation of the rate of the reaction in equation 7 as a function of the concentration of NOCl in moles per liter.
2NOCl ® 2NO + Cl2 (7)
| Dependent variable | Independent Variable | |
|---|---|---|
| Rate, moles/L-sec | [NOCl], moles/L | [NOCl]2 |
| 3.60 x 10-9 | 0.30 | 0.09 |
| 1.44 x 10-8 | 0.60 | 0.36 |
| 3.24 x 10-8 | 0.90 | 0.81 |
| 4.80 x 10-9 | 1.10 | 1.21 |
| 7.4 x 10-8 | 1.35 | 1.82 |
| 11.4 x 10-8 | 1.7 | 2.89 |
Assuming this data obeys y = mxn, we first plot ln y vs. ln x to obtain n. Values of ln (Rate) and ln [NOCl] are in Table 4.
| ln (Rate) | ln [NOCl] |
|---|---|
| -19.442 | -1.204 |
| -18.056 | -0.511 |
| -17.245 | -0.105 |
| -16.852 | 0.0953 |
| -16.419 | 0.300 |
| -15.987 | 0.531 |
A computer plot of ln (Rate) vs. ln [NOCl] is shown in Figure 7. The regression slope is 1.997, very close to 2, so n = 2. We now return to the original data and plot Rate vs. [NOCl]2 to obtain m from the slope.
Values of [NOCl]2 are in column 3 of Table 3, and a plot of Rate versus [NOCl]2 is in Figure 8. The slope of this plot is 3.96 x 10-8 L/mole-sec. The original data obey equation 8.
Rate = 3.96 x 10-8[NOCl]2 (8)
Before proceeding, we should note something about the graph in Figure 8. The numerical values of rate (Table 8) are very small, involving an exponential factor of 10-8. It is clumsy to write such small numbers along the axis of a graph. To avoid this, scientists label the axis using only the argument of the number (e.g., the argument of the number, 4.80 x l0-8 is 4.80). The exponential term is acknowledged in the axis label. This has been done in Figure 8, where the vertical axis is labeled, Rate (moles/L-sec) x l08. The number, l08, is the number by which all the experimental rates were multiplied to convert them to the argument, which is actually plotted. Thus
(4.80 x 10-8) x 108 ® 4.80
For plots in which the numbers on one or both axes have implied exponentials, allow for these in calculating slope and intercept manually. Please see your instructor with questions about this.
Case 4
. 1/y = mx + b.Again, this form is common in kinetics. For a second-order reaction, the concentration of the reactant varies with time according to equation 9, where t = time elapsed since the beginning of reaction, k = the second-order rate constant, and [reactant]o is the concentration of reactant at t=0, the beginning of the reaction.
1/[reactant] = kt + 1/[reactant]o (9)
A specific example of a second-order reaction is in equation 10. Table 5 shows how the concentration of C4H6 (butadiene) varies with time.
2C4H6(g) ® C8H12(g) (10)
The third column lists calculated values of 1/[C4H6], which are plotted against time in Figure 9. The plot is linear, with slope 0.0141 L/mole-s and intercept 59 L/mole. From the intercept, [C4H6]o = 1/intercept = 0.0170 M.
1/[C4H6] = 0.0141 t + 59 (11)
| t, sec | [C4H6], moles/L | 1/[C4H6], L/mole |
|---|---|---|
| 195 | 1.62 x 10-2 | 61.7 |
| 604 | 1.47 x 10-2 | 68.0 |
| 1246 | 1.29 x 10-2 | 77.5 |
| 2180 | 1.10 x 10-2 | 90.9 |
| 4140 | 0.89 x 10-2 | 112 |
| 4655 | 0.80 x 10-2 | 125 |
| 6210 | 0.68 x 10-2 | 147 |
| 8135 | 0.57 x 10-2 | 175 |
Case 5
. ln y = mx + b.Kinetics again provides examples of this type of function. For first-order reactions, concentration of reactant varies with time according to equation 12.
ln [reactant] = -kt + ln [reactant]o (12)
where t = time elapsed since the beginning of reaction, k is the first-order rate constant for the reaction, and [reactant]o is the concentration of reactant at t=0.
An example of a first-order reaction is eqn 13.
2N2O5(g) ® 4NO2(g) + O2(g) (13)
Concentration-time data are in Table 6.
| [N2O5], mole/L | t,sec | ln [N2O5] |
|---|---|---|
| 5.00 | 0 | 1.609 |
| 3.52 | 500 | 1.258 |
| 2.48 | 1000 | 0.908 |
| 1.75 | 1500 | 0.560 |
| 1.23 | 2000 | 0.207 |
| 0.87 | 2500 | -0.139 |
| 0.61 | 3000 | -0.494 |
Values of ln [N2O5] are in the third column of the table, and a plot of ln [N2O5] vs. t is in Figure 10. The plot is linear. The rate constant, k (slope), is 7.0 x 10-4 sec-1 (be sure you understand how units are determined). ln [N2O5]o (intercept) is 1.609.
Case 6
. This is a very common functional relation in chemistry.ln y = m/x + b (14)
Some examples include how the equilibrium constant, Keq, for a reaction, the rate constant for a reaction, and the vapor pressure of a pure liquid vary with temperature. Consider a particular example.
For most chemical reactions, the rate constant varies with Kelvin temperature according to eqn 15.
ln k = -Ea/RT + ln A (15)
Here k is the rate constant, T is the temperature, Ea is the activation energy for the reaction, A is the frequency factor for the reaction, and R is the gas constant. (Do not worry about where this equation comes from or what all of the quantities mean--focus on the functional form and the graphical analysis).
Table 7 shows the rate constant as a function of temperature for reaction 16.
H2 + I2 ® 2HI (16)
| Temperature (oC) | k (L/mole-sec) |
|---|---|
| 283 | 1.2 x 10-4 |
| 302 | 3.5 x 10-4 |
| 355 | 6.8 x 10-3 |
| 393 | 3.8 x 10-2 |
| 430 | 1.7 x 10-1 |
To plot ln k versus 1/T (K), we must a) convert temperature to the Kelvin scale; b) reciprocate the Kelvin temperatures; c) find the natural logarithms of the rate constants. The results are in Table 8.
| T(K) | 1/T, K-1 | ln k (no units) |
|---|---|---|
| 556 | 1.799 x 10-3 | -9.028 |
| 575 | 1.739 x 10-3 | -7.958 |
| 628 | 1.592 x 10-3 | -5.573 |
| 666 | 1.592 x 10-3 | -3.270 |
| 703 | 1.422 x 10-3 | -1.772 |
A plot of ln k vs. 1/T is in Figure 11. Slope and intercept are
slope = -1.93 x 104 K
intercept = 25.57
Since slope = -Ea/R, and R = 8.314 J/mole-K, we calculate Ea as follows
Ea = (-8.314 J/mole-K) x (-1.93 x 104K)
= 1.60 x 105 J/mole
Since intercept = ln A, we calculate
A = eintercept = e 25.57 = 1.27 x 1011
In all of the previous examples, zero was a convenient lower limit for the range of the independent variable. In this example, however, zero is not a convenient lower limit for the abscissa if we want to utilize the full dimensions of the window. Since the zero of the abscissa does not occur where the two axes meet, the y-intercept cannot be obtained manually by extrapolating the linear plot to intersect the y-axis. In cases like this, the value of the y-intercept must be calculated. The standard form for a straight line, equation 1, can be rearranged to equation 17.
b = y - mx (17)
First, the slope is calculated from the best-fit line for the data. Then a single point on the line is chosen, and b is calculated by 17.
The intercept in Figure 11 may be calculated this way.
ln A = ln k + Ea/RT
Choosing the point for which ln k = -7.23 and 1/T = 1.7 x 10-3, we obtain
ln A = (-7.23) - (-1.93 x 104) (1.7 x 10-3)
= 25.6
This completes our survey of common linear functional forms. Although other forms occur, familiarity with those discussed here will serve you well.
Before concluding this section, we summarize the practical aspects of constructing and analyzing plots.
Focus Questions
What is the mathematical relationship among the four variables in your data set?
Equipment and Materials
Bring the following items to lab:
Experimental
You will be given a table of experimental data relating the values of four variables. Your goal during the laboratory period is to use graphical methods to determine the functional relationship among the four variables. When you think that you have successfully achieved this, show the graphs to your instructor and explain how you used them to determine the functional relationship. S/he will point out errors, which must be corrected before leaving the lab.
During the two days following your lab period, use a spreadsheet to reproduce the plots that you made manually in the laboratory. No later than 4PM on the second day following your lab meeting, turn in your manual and computer plots and any attendant calculations.
Disposal Methods
No disposal required.
Preparation
Fundamentals: Graphing