Expansion
Number AB (cm) % Change newDISTANCE previousDISTANCE
0 (Start) %Change x100
previousDISTANCE
1 #DIV/0!
2 #DIV/0!
3 #DIV/0!
4 #DIV/0!
5 #DIV/0! AB Distance
6 #DIV/0! 1.2
Distance Between Line AB (cm)
7 #DIV/0! 1
8 #DIV/0!
0.8
9 #DIV/0!
10 #DIV/0! 0.6
11 DIRECTIONS
#DIV/0! 0.4
Data Entry
12 #DIV/0! 0.2
1. Enter the AB and CD distances in the two tables on the left.
aren't used!
Clear cells in the % column that 2. Clear the cells in the % Change column for any row where you do not have a distance mea
0
"Add Trendline" . Ch
3. On each % Change graph, right click the2line on the graph and choose 8
0 4 6
3. Copy the % Change data from MS Excel onto the data table in your lab.
4. You may adjust the formatting of the graph if you wish. Expansion Number
Expansion
Number CD (cm) PRINTING (choose Option 1 or Option 2)
% Change
Option 1--Click the graph you want to print to select it. Print. Repeat for each graph.
0 (Start)
Option 2--Open a MS Word document and cut and paste the graphs into Word. You should b
1 #DIV/0!
same page. CD Distance
2 #DIV/0! 1.2
Distance Between Line CD (cm)
3 #DIV/0!
1
4 #DIV/0!
5 0.8
#DIV/0!
6 #DIV/0! 0.6
7 #DIV/0! 0.4
8 #DIV/0! 0.2
9 #DIV/0!
0
10 #DIV/0!
0 2 4 6 8
11 #DIV/0!
Expansion Number
12 #DIV/0!
Clear cells in the % column that aren't used!
eviousDISTANCE
x100
STANCE
% Change AB Distance
1
Percent Change In Distance (AB)
0.9
0.8
0.7
0.6
0.5 % Change
0.4
Expon. (% Change)
0.3
0.2
do not have a distance measurement.
0.1
choose "Add Trendline" . Choose "Exponential".
10 12 14
0
sion Number 0 5 10 15
peat for each graph.
phs into Word. You should be able to get two graphs on the
% Change CD Distance
1
Percent Change In Distance (CD)
0.8
0.6
0.4 % Change
0.2 Expon. (% Change)
0
10 12 14 0 5 10 15
sion Number Expansion Number
% Change
Expon. (% Change)
% Change
Expon. (% Change)