Graphical Analysis Tutorial: Entering, Plotting, and Analyzing Linear Data, Study notes of Chemistry

A step-by-step tutorial on using Graphical Analysis software to enter, plot, and analyze linear data in the context of chemistry and physics. The tutorial covers data entry, converting height to volume, changing symbol styles, plotting data, scaling axes, and performing a linear regression analysis. The document also includes a checklist for good graphing practices and a self-test exercise.

Typology: Study notes

2021/2022

Uploaded on 07/05/2022

carol_78
carol_78 🇦🇺

4.8

(59)

1K documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
07. Graphical Analysis tutorial.doc
Daley 1 10/9/09
Introduction to Graphical Analysis
In chemistry and physics we often make graphs to show the relationship between two variables. If
the relationship can be modeled by a mathematical function we have a powerful tool for analysis of
the data. You should be familiar with this type of analysis for linear data sets of the form y = mx + b.
Here the dependent variable, y, is related to the independent variable, x, through the slope, m, of
the line and the y-intercept, b. A linear regression fit (best fit) to the data yields a numeric value for
the slope and the y-intercept.
Graphing of Linear Data USING GRAPHICAL ANALYSIS SOFTWARE – 3.04
Graphical Analysis is a easy to learn, inexpensive software program for the MAC or PC. We use this
program extensively in chemistry 1B and 1C. More information about the program can be found at:
http://www.vernier.com/soft/ga.html A complete user’s manual can be downloaded from the vernier
website. At the back of this tutorial is a one-page reference guide provided by vernier.
Aside from simple graphing of data, Graphical Analysis has built-in spreadsheet functions that we
will use in this tutorial to change the raw data into a more suitable form for graphing. From now on,
GA will be used in place of Graphical Analysis.
As a tutorial example, I will use data we collect in chemistry 1B laboratory. The data pairs consist of
temperature of a trapped air sample (x value) and the height of the trapped air sample in a capillary
tube (y value). This data is used in chemistry 1B to illustrate the gas laws, specifically how gas
volume is related to temperature. The raw data a student would collect in lab is given below in Table
I. In the following paragraphs, the screen shots are for the Mac version of Graphical Analysis.
The PC version has slightly different menus but the same functionality.
Table I. Gas Law Data
Step 1.
First enter the
data into GA.
Next double-
click a column
to open up the
Column
Options dialog
box. Change
the X column
heading to
Temperature
with units of
°C (see
picture) and the Y column to Height of air column with units of mm.
Notice in GA the units are entered below the column name. Ignore
the Short Name for now. After you have entered these values the data set should look as shown.
Temperature
(°C)
Height of air
column (mm)
83.5
68.0
82.4
67.0
76.6
66.0
71.7
65.0
64.4
64.0
57.1
63.0
54.7
62.0
47.9
61.0
44.7
60.0
37.7
59.0
33.1
58.0
28.0
57.0
23.9
56.0
20.6
55.5
pf3
pf4
pf5

Partial preview of the text

Download Graphical Analysis Tutorial: Entering, Plotting, and Analyzing Linear Data and more Study notes Chemistry in PDF only on Docsity!

Introduction to Graphical Analysis

In chemistry and physics we often make graphs to show the relationship between two variables. If the relationship can be modeled by a mathematical function we have a powerful tool for analysis of the data. You should be familiar with this type of analysis for linear data sets of the form y = mx + b. Here the dependent variable, y , is related to the independent variable, x , through the slope, m , of the line and the y-intercept, b. A linear regression fit (best fit) to the data yields a numeric value for the slope and the y-intercept. Graphing of Linear Data USING GRAPHICAL ANALYSIS SOFTWARE – 3. Graphical Analysis is a easy to learn, inexpensive software program for the MAC or PC. We use this program extensively in chemistry 1B and 1C. More information about the program can be found at: http://www.vernier.com/soft/ga.html A complete user’s manual can be downloaded from the vernier website. At the back of this tutorial is a one-page reference guide provided by vernier. Aside from simple graphing of data, Graphical Analysis has built-in spreadsheet functions that we will use in this tutorial to change the raw data into a more suitable form for graphing. From now on, GA will be used in place of Graphical Analysis. As a tutorial example, I will use data we collect in chemistry 1B laboratory. The data pairs consist of temperature of a trapped air sample (x value) and the height of the trapped air sample in a capillary tube (y value). This data is used in chemistry 1B to illustrate the gas laws, specifically how gas volume is related to temperature. The raw data a student would collect in lab is given below in Table I. In the following paragraphs, the screen shots are for the Mac version of Graphical Analysis. The PC version has slightly different menus but the same functionality. Table I. Gas Law Data Step 1. First enter the data into GA. Next double- click a column to open up the Column Options dialog box. Change the X column heading to Temperature with units of °C (see picture) and the Y column to Height of air column with units of mm. Notice in GA the units are entered below the column name. Ignore the Short Name for now. After you have entered these values the data set should look as shown. Temperature (°C) Height of air column (mm) 83.5 68. 82.4 67. 76.6 66. 71.7 65. 64.4 64. 57.1 63. 54.7 62. 47.9 6 1. 44.7 60. 37.7 59. 33.1 58. 28.0 57. 23.9 56. 20.6 55.

Step 2. Now we will convert the height of the air column to a volume of trapped air. Since the diameter of the capillary tube is fairly uniform, the volume of the air sample is proportional to its height. This calculation will be done using the built-in spreadsheet functions in GA. The formula for converting a height to a volume for a cylindrical shape is V =! r^2 h , where r is the radius of the capillary tube. For this data the radius is 0.5 mm. Select the Data>New Calculated Column… function from the menu bar. The program will create a new data column to convert all the heights to a volume of air based on a mathematical formula. You enter the required formula into the Equation box. The formula to convert height to volume is entered as: pi0.5^2”Height of air column”. pi** is a selectable Parameter, (0.5^2) is entered using the keyboard, and the ”Height of air column” is selected from the Variables (Columns) pull down menu. Each x-axis height is converted to a volume of air. This is our first use of the spreadsheet functions of GA. Also enter a column name: “Volume of air” and a unit, mm^3. The short name should be set to a capital V. See the screen shots below.

Your graph should now look like this: Step 5. Now we will change the scaling on your graph to have the x-axis start at – 300 °C and the y- axis start a zero. (You may not have to do this for most graphs, but for this data we would like to see where the regression line intercepts the x- axis.) Double-click on the graph to bring up the Graph Options box. Select “Axes Options”. First choose “Manual” for the y-axis scaling. Enter 55 as the Top value and 0 as the Bottom value. Then chose “Manual” for the x-axis. Enter - 300 as the left scale value and 100 as the right scale value. The graph should now look like this: Step 6 Now we will have the program perform a linear regression analysis. This will draw the best-fit regression line and give the slope and y-intercept values. Select Analyze>Linear Fit or click on the menu bar icon. A dialog box will appear on your graph giving the slope and y-intercept values for the linear regression fit as well as a correlation coefficient and a root-mean-square error (RMSE) value. The dialog box can be positioned anywhere on the graph. On the next page is the completed graph.

Summary

This tutorial will give you the basics needed to enter (x,y) data into Graphical Analysis, label the axis, perform simple calculations on your data as needed, plot the data and scale the axis, and finally fit the data to a best-fit straight line. There are many other functions available in GA, try them on a sample data set to see the power of this simple program!

Good Graphing Checklist

  • Always include a label and units on your data columns/axis.
  • Add a suitable, informative title to the graph (the Y-label versus X-label is NOT be a suitable title for any graph). Instead, describe the purpose of generating the graph and include any specific conditions of the data collection not already indicated in the labels of your axes.
  • Display the data points with the options Point Protectors on. This gives a larger symbol for the data point.
  • Use open symbols for your points, not solid symbols.
  • Include the fitted regression curve when needed.
  • Expand your scales when needed to make the axis as "readable" as possible.
  • Determine the units of the fitting constants from your axis units. Remember, when plotting a ln(x) term, the values of ln(x) have no units. However the units of x should be stated. The axis units should be “x in units of …”.
  • Add a legend to the graph if there is more than one data set plotted.