inst_excel_07.2

# inst_excel_07.2 - Class7.2:Tables,Graphsand Excel...

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

1 Class 7.2: Tables, Graphs and  Excel Solving Problems Using Graphical Analysis

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

View Full Document
2 Learning Objectives Learn to use tables and graphs as  problem solving tools Learn and apply different types of  graphs and scales Prepare graphs in Excel Be able to edit graphs
3 Proper Use of Tables &  Graphs Engineers  record and  present data in  two primary  formats:  Tables  and Graphs Height  H (m)  Temp  T ( °Χ 29 Πρεσσυρε Π(κΠα 29 0 15.0 101.3 300 12.8 97.7 600 11.1 94.2 0 2 4 6 8 10 12 14 16 0 500 1000 1500 Height (m) 0 20 40 60 80 100 120 140 160 Temp Pressure

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

View Full Document
4 Tables Tables should  always  have: Title Column headings with brief descriptive name,  symbol and appropriate units. Numerical data in the table should be written  to the proper number of significant digits.   The decimal points in a column should be aligned.   Tables should  always  be referenced and  discussed (at least briefly) in the body of the  text of the document containing the table.
5 Table Example Temperature and Pressure of Widgets at Various Heights Height H (m) Temp T ( ° Χ29 Πρεσσυρε Π(κΠα 29 0 15.0 101.3 300 12.8 97.7 600 11.1 94.2

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

View Full Document
6 Exercise Enter the following table in Excel You can make your tables look nice by  formatting text and borders Independent  Variable, x  Dependent  Variable, y1  Dependent  Variable, y2  1 2500 10 50 5000 100 7500 1000 150 10000 200
7 Graphs Proper graphing of data involves  several steps: Select appropriate graph type Select scale and gradation of axes, and  completely label axes Plot data points, then plot or fit curves Add titles, notes, and or legend

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

View Full Document
8 Graphs - Types Travel Expenses 0 2 4 6 8 10 12 14 16 18 1. Pie Chart 2. Bar Graph
9 Graphs - Types 4. Line Graph 0 2 4 6 8 10 12 14 16 0 500 1000 1500 Height (m) 0 20 40 60 80 100 120 140 160 Temp Pressure 1 2 3 4 5 6 7 0 1 2 3 4 5 6 7 8 0 2 4 6 8 10 12 14 Object 1 Object 2 Body Temperature ( 0 C Speed (m/s) Distance (m) 3. 3-D Graph

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

View Full Document
10 Graphs Each graph must include: A descriptive title which provides a clear and  concise statement of the information being  presented A legend defining point symbols or line types used  for curves needs to be included  Labeled axes  Graphs should always be  referenced/discussed in the body of the text  of the document containing the table.
11 Titles and Legends Each graph must be identified with a  descriptive title The title should include clear and  concise statement of the information  being presented A legend defining point symbols or line  types used for curves needs to be  included

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

View Full Document
12 Axis Labels Each axis must be labeled The axis label should contain the name  of the variable and its units.   The units can be enclosed in  parentheses, or separated from the  label by a comma.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 53

inst_excel_07.2 - Class7.2:Tables,Graphsand Excel...

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

View Full Document
Ask a homework question - tutors are online