excel_10.2 - Graphical Analysis Class 10.2 1 Learning...

Info iconThis preview shows pages 1–16. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Graphical Analysis Class 10.2
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Learning Objectives Use tables and graphs as problem solving tools Learn and apply different types of graphs and scales Review graphing in Excel Edit graphs Use linear regression by hand, and in Excel.
Background image of page 2
3 Building the Graph in Excel (Review) Select the desired data by dragging through it with the mouse. Use the data entered in the earlier exercise Click the Chart Wizard Choose XY (Scatter), with data connected by lines, if desired. Select “NEXT”
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 Building a Graph In Excel Enter the Independent Variable (X) and Dependent Variable (Y1) in Excel
Background image of page 4
5 Axis Formats (Scales) There are three common axis formats: Rectilinear: Two linear axes Semi-log: one log axis Log-log: two log axes Length (km) 1 km 10 km Log scale: 1 km Length (km) Linear scale:
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 1 10 100 1000 10000 Logarithmic Scales Use to plot numbers that span many orders of magnitude
Background image of page 6
7 Semi-log graph paper
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
8 Log-log graph paper
Background image of page 8
9 Pair Exercise #2: Creating Log Scales in Excel (1 min) Create a new graph using only x and y1. New Graph 0 2000 4000 6000 8000 10000 12000 0 2000 4000 6000 8000 10000 12000 x y1 data
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
10 Pair Exercise #2: Creating Log Scales in Excel (con’t) Now modify the graph so the data are plotted as semi-log (i.e., the y-axis is log scale and the x-axis is linear). To do this, double left click on the y-axis
Background image of page 10
11 Pair Exercise #2: Creating Log Scales in Excel (con’t) On the Scale tab, select logarithmic “OK” Next, go to Chart Options and select the Gridlines tab. Turn on (check) the Minor gridlines for the y-axis. “OK”
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Result The curve is now a line. New Graph 1 10 100 1000 10000 0 2000 4000 6000 8000 10000 12000 x y1 data
Background image of page 12
13 Exercise #3 (5 min) Copy and Paste the graph twice. Modify one of the new graphs to be rectilinear in y and log in x Modify the other new graph to be log- log Note how the scale affects the shape of the curve.
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
14 Result:semi-log x New Graph 0 2000 4000 6000 8000 10000 12000 1 10 100 1000 10000 x y1
Background image of page 14
15 Result: log-log New Graph 1 10 100 1000 10000 1 10 100 1000 10000 x y1 y1
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 16
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 44

excel_10.2 - Graphical Analysis Class 10.2 1 Learning...

This preview shows document pages 1 - 16. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online