SMS221 Chapter Notes - Chapter 4: Sparkline, Histogram
Get access
Related Documents
Related Questions
GRAPHING EXERCISE #1
Graph the following data on one graph using Excel.
The following data was obtained in a lab exercise comparing temperature and gas pressure. The quantity and the volume of the gas were constant.
Temperature in ºC | Pressure in mm Hg |
100 | 1174 |
73 | 1079 |
52 | 1020 |
25 | 949 |
0 | 861 |
-30 | 758 |
-48 | 700 |
-79 | 601 |
-94 | 566 |
-100 | 500 |
Plotting Graphs Using Excel
1. Click on the Excel icon. A series of rows and columns will appear.
Column A corresponds to the x-axis and Column B corresponds to the y-axis.
Enter the values for the x- and y- axes in columns A and B, respectively.
Position the cursor on the first cell, click and hold down the left mouse button and highlight all the values of columns A and B you have entered.
Click on the chart wizard (an icon that looks like a bar graph).
Click on scatter, next, and then click on the second sub choice. Click on next.
Click on next.
Your graph should show up on the screen. Click on next.
Click on chart title. Type in the title of your graph followed âby your nameâ. Label the x- and y-axes by placing a name with units in the space given for Category x and Value y.
Click on gridlines. Click on minor gridlines for both the x- and y-axes. Click on next.
You are given a choice between saving as a new sheet or saving in the current sheet. Saving as a new sheet will produce a larger picture of the graph, while saving within the current sheet allows for both the data sheet and graph to be printed on the same page. Click as a new sheet and the click finish.
If there is a lot of empty space on your graph, you need to adjust the scale on the x- and y-axes. To do this, double click on the axis you wish to adjust. The number that you will be changing appears in the âminimumâ box. (Note: the value at the origin does not necessarily need to be zero.
To print the graph, click on file and then click on print.
GRAPHING EXERCISE #2
Use this data in the following exercises.
Time, min Mass, g Time, min Mass,g
0.0 8.860 6.0 8.765
1.0 8.844 7.0 8.748
2.0 8.828 8.0 8.734
3.0 8.814 9.0 8.719
4.0 8.796 10.0 8.703
5.0 8.782
1. Using Excel, graph the time and mass data as in #1. Using the linear regression feature on excel, determine the equation of a line and show that equation on your graph.
2. Answer the following questions using the graph you have created above.
What is the independent variable?
What item is plotted on the abscissa?
What would be the mass of acetone in grams at a time of 12 minutes?
What would be the mass of acetone in grams at a time of 4.6 minutes? Show two ways to find this value.
Materials:
Measuring cups
Thermometer
Small pan.
Part A. Manual Centigrade vs Fahrenheit Graphing
1.Convert 0, 15, 38, 45, and 100 degrees of Celsius to digress of Fahrenheit using:
°F = (1.8 à °C) + 32. Fill in the data in the following data table.
Table 2. Data table for temperature °C vs. °F
°C | °F |
0 | |
15 | |
38 | |
45 | |
100 |
2.Use the graph paper-I provided on line. Plot the above data using steps described. Be sure to calculate the range and scale.
Part B. Manual Volume vs Weight graphing
3.Fill ¼, ½, ¾, and 1 measuring cups with water and weigh them.
4.Create your own data table and graph your data following graph making steps. Show your calculation steps on your graph paper. (Use graph paper-II under the course tab) (6 points)
5.Make sure to use two different graph papers (I and II) to be able to earn full credit.
6.You will need to scan and copy your graphs on a word document and submit.
Part C. Computer Graphing
1.It is very important to learn computer graphing after you have learned graphing data by hand. The computer will do most of the steps for you; you must provide data. Computer programs can create a complete graph from your data.
2.General computer graphing follows the following steps:
Open an Excel spreadsheet.
Enter the values without the units using A and B columns. Highlight the cells that are filled with data.
Choose Insert then Scatter from the pull down menu, select smooth lines and marker scatter or any other xy scatter.
If you choose layout; you could label the graph and the axes, and add gridlines.
Your graph should look like the following graph.
3.Above instructions assume that you have some knowledge of Microsoft Excel. Unless you are comfortable with your computer, you should have someone that can help you out when you try this the first time.
Using the data from Part A, and Part B make two computer graphs.