excel_10.2

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

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

1 Graphical Analysis Class 10.2

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

View Full Document
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.
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”

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

View Full Document
4 Building a Graph In Excel Enter the Independent Variable (X) and Dependent Variable (Y1) in Excel
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:

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

View Full Document
6 1 10 100 1000 10000 Logarithmic Scales Use to plot numbers that span many orders of magnitude
7 Semi-log graph paper

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

View Full Document
8 Log-log graph paper
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

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

View Full Document
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
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”

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

View Full Document
Result The curve is now a line. New Graph 1 10 100 1000 10000 0 2000 4000 6000 8000 10000 12000 x y1 data
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.

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

View Full Document
14 Result:semi-log x New Graph 0 2000 4000 6000 8000 10000 12000 1 10 100 1000 10000 x y1
15 Result: log-log New Graph 1 10 100 1000 10000 1 10 100 1000 10000 x y1 y1

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## 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
Ask a homework question - tutors are online