inst_excel_07.2

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

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

View Full Document Right Arrow Icon
    1 Class 7.2: Tables, Graphs and  Excel Solving Problems Using Graphical Analysis
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 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
Background image of page 2
    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
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 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.
Background image of page 4
    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  
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 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
Background image of page 6
    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
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 Graphs - Types Travel Expenses 0 2 4 6 8 10 12 14 16 18 1. Pie Chart 2. Bar Graph
Background image of page 8
    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
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 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.
Background image of page 10
    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  
Background image of page 11

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

View Full DocumentRight Arrow Icon
    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.
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/15/2010 for the course ENGR 111 taught by Professor Walker during the Fall '07 term at Texas A&M.

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 Right Arrow Icon
Ask a homework question - tutors are online