A Guide to Microsoft Excel 2013 for Scientists and Engineers

Erscheinungsjahr 2015
ISBN: 978-0-12-802817-9
Verlag: Elsevier Science

Buch, Englisch, 382 Seiten, Format (B × H): 189 mm x 236 mm, Gewicht: 804 g

Completely updated guide for students, scientists and engineers who want to use Microsoft Excel 2013 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 such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.

Zielgruppe

<p>Undergraduate science and engineering students; professional scientists and engineers</p>

Autoren/Hrsg.

Liengme, Bernard

Fachgebiete

• Mathematik | Informatik EDV | Informatik Angewandte Informatik Computeranwendungen in Wissenschaft & Technologie
• Technische Wissenschaften Technik Allgemein Computeranwendungen in der Technik
• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel

Inhaltsverzeichnis

1. Welcome to Microsoft Excel 2013
2. Basic Operations
3. Printing in Excel
4. Using Functions
5. Decision Functions
6. Data Mining
7. Charting
8. Regression Analysis
9. VBA User-Defined Functions
10. VBA Subroutines
11. Modeling I
12. Using Solver
13. Numerical Integration
14. Differential Equations
15. Modeling II
16. Statistics for Experimenters