|
USING EXCEL SPREAD SHEET: Beginners!
|
| |
Consider this data from a density experiment: |
| |
Volume(mL)
|
Mass(g)
|
| |
0
|
124.543
|
| |
10
|
134.445
|
| |
20
|
144.567
|
| |
30
|
154.563
|
| |
40
|
164.338
|
| |
50
|
174.248
|
| |
To Enter Data |
| 1 |
Double click on the Excel icon and wait for the
spread sheet to appear. |
| 2 |
Click on cell A1. |
| 3 |
Type "Volume". Hit ENTER or move down to next
cell with arrow key. |
| 4 |
Type in first volume(0). Hit ENTER or move down
to next cell with arrow key. |
| 5 |
Repeat until all volume data is entered. |
| 6 |
Use the arrow keys to move to the top of the second
column. Type "Mass". Hit Enter. |
| 7 |
Enter the mass data in column B. |
| |
| |
To Make a Graph |
| 8 |
Click on the data and drag the mouse to highlight
the data you wish to plot(A2 to B7). |
| 9 |
Click INSERT and select CHART or select the CHART
Icon on the menu bar. |
| 10 |
Select (XY) SCATTER. Select NEXT. |
| 11 |
Check range and graph. If OK, select NEXT. |
| 12 |
If not OK, type location of data into Data Range
Box (example: A2..B7). Select NEXT. |
| 13 |
Type the following information into the appropriate
boxes: |
| |
Title of the graph(Mass vs Volume) |
| |
X range Name of variable (Volume) |
| |
Y range Name of variable (Mass) |
| 14 |
Select NEXT. |
| 15 |
To choose a chart location, click on the circle
beside either "as object:" or "as new sheet:". |
| 16 |
Select FINISH. |
| |
| |
To do a Linear Regression |
| 17 |
Place the cursor on one of the data points on
the graph and click. |
| 18 |
Select CHART(top of screen). Find ADD TRENDLINE.(You
may need to move down until more options appear). |
| 19 |
Select ADD TRENDLINE. |
| 20 |
On the Type tab, click on LINEAR to highlight
that option and click on OK. |
| 21 |
Again at the top of the screen, select CHART.
Find ADD TRENDLINE. |
| 22 |
Select ADD TRENDLINE. |
| 23 |
Click on the Options tab, click on the box beside
DISPLAY EQUATION to get a check in the box. |
| 24 |
Move to the box beside R-SQUARED VALUE and click
to get a check in the box. Click OK. |
| 25 |
The equation for a straight line( y= mx + b) appears
on your graph. The slope of the line is "m". |
| 26 |
Check the R-squared value. The closer it is to
1, the better the data fits an equation for a straight line. |
| |
| |
To Print (Extra paper is in the drawer closest
to the printer.) |
| 27 |
Select FILE. |
| 28 |
Select PRINT. |
| 29 |
Click on OK . |
| |
| |
To Clear and Close |
| 30 |
Place cursor on the small "x" in the far upper
right corner of the screen and click. |
| 31 |
Select NO so that data will not be stored on this
computer. |