A guide to Microsoft Excel 2007 for scientists and engineers [[electronic resource] /] / Bernard V. Liengme ; with David J. Ellert

• Autore: Liengme Bernard V
• Pubblicazione: Amsterdam ; ; Boston, : Academic Press/Elsevier, c2009
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (337 p.)
• Disciplina: 005.360245
• Soggetto topico: Engineering - Data processing; Science - Data processing
• Note generali: Includes index.
• Nota di contenuto: Front Cover; A Guide to Microsoft® Excel 2007 for Scientists and Engineers; Copyright Page; Contents; Preface; Chapter 1 Welcome to Microsoft Excel® 2007; The Excel Window; Exercise 1: The Ribbon; Exercise 2: Quick Access Toolbar; Exercise 3: Working with Shortcuts; The Worksheet; Excel 2007 Specifications; Problems; Chapter 2 Basic Operations; Exercise 1: Simple Arithmetic; Exercise 2: The Arithmetic Operators; Exercise 3: Formatting (Displayed and Stored Values); Exercise 4: Working with Fractions; Exercise 5: A Practical Worksheet; Copying Formulas: What Happens to References? ; What's in a Name?Exercise 6: Another Practical Example; Special Symbols, Subscripts, and Superscripts; Mathematical Limitations of Excel; Play It Again, Sam; Problems; Chapter 3 Printing in Excel; Exercise 1: Quick Print and Print Preview; Exercise 2: Print Area; The Print Dialog; Exercise 3: Some Printing Options; Chapter 4 Using Functions; Exercise 1: AutoSum Tool; The Insert Function Command; Exercise 2: Computing a Weighted Average; Exercise 3: Entering Formulas by Typing; Exercise 4: Trigonometry Functions; Exercise 5: Exponential Functions; Exercise 6: Rounding Functions ; Note on RoundingSignificant Numbers; Some Other Mathematical Functions; Array Formulas; Exercise 7: The Matrix Functions; Volatility: Calculate Mode; Exercise 8: Solving Systems of Equations; Exercise 9: Sum of Diagonal; Financial Functions; Problems; Chapter 5 Decision Functions; Logical Comparison Operators; Exercise 1: Boolean Functions; Exercise 2: Practical Example; The IF Function; Exercise 3: Resistors Revisited; Exercise 4: Quadratic Equation Solver; Exercise 5: Protecting a Worksheet; Table Lookup Functions; Exercise 6: A Simple Lookup; Exercise 7: A Two-Valued Lookup ; Exercise 8: Conditional SummingExercise 9: Array Formulas; Exercise 10: Conditional Formatting; Exercise 11: SUMPRODUCT; Problems; Chapter 6 Data Mining; Exercise 1: Importing a TXT file; Exercise 2: Counting and Summing with Criteria; Exercise 3: Frequency Distribution; Exercise 4: Pivot Tables; Exercise 5: Sorting; Exercise 6: Filtering; Exercise 7: The Excel Table; Problems; Chapter 7 Charts; Types of Charts; Line and XY Chart; Comments about Charts; Chart Terminology; Exercise 1: An XY Chart; Exercise 2: Smooth Lines; Formatting a Chart; Exercise 3: Formatting the Data Series ; Exercise 4: Formatting an AxisExercise 5: Plotting a Function; Exercise 6: More Formatting; Finding Roots; Exercise 7: A Flexible Domain; Exercise 8: Changing Axis Position; Exercise 9: XY Chart with Two Y-axes; Exercise 10: Control Chart; Exercise 11: Too Much Data; Exercise 12: Large Numbers and Log Scale; Exercise 13: Error Bars; Other Chart Types; Exercise 14: Surface Chart; Exercise 15: Combination Chart; Exercise 16: A Bar Chart; Exercise 17: A Parametric Chart; Exercise 18: Polar Chart; Dynamic Charts; Printing a Chart; URLs for Chart Websites; Problems; Chapter 8 Regression Analysis ; Least-Squares Fitting
• Sommario/riassunto: Completely updated guide for scientists, engineers and students who want to use Microsoft Excel 2007 to its full potential.Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas suc
• Titolo autorizzato: A guide to Microsoft Excel 2007 for scientists and engineers
• ISBN: 1-282-16889-4; 9786612168895; 0-08-092351-8
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910777757803321
• Lo trovi qui: Univ. Federico II