A Guide to Microsoft Excel 2013 for Scientists and Engineers
A Guide to Microsoft Excel 2013 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2015-03-17

Total Pages: 378

ISBN-13: 0128028165

DOWNLOAD EBOOK

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. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2013 - Features of Excel 2013 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results New to this edition: - The Backstage is introduced (a new Office 2013 feature); all the 'external' operations like Save, Print etc. are now in one place - The chapter on charting is totally revised and updated – Excel 2013 differs greatly from earlier versions - Includes many new end-of-chapter problems - Most chapters have been edited to improve readability

A Guide to Microsoft Excel 2007 for Scientists and Engineers
A Guide to Microsoft Excel 2007 for Scientists and Engineers

Author: Bernard V. Liengme

Publisher:

Published: 2009

Total Pages: 326

ISBN-13:

DOWNLOAD EBOOK

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 such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.

Excel for Scientists and Engineers
Excel for Scientists and Engineers

Author: E. Joseph Billo

Publisher: John Wiley & Sons

Published: 2007-03-16

Total Pages: 480

ISBN-13: 0470126701

DOWNLOAD EBOOK

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Liengme's Guide to Excel 2016 for Scientists and Engineers
Liengme's Guide to Excel 2016 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2019-08-14

Total Pages: 416

ISBN-13: 0128182504

DOWNLOAD EBOOK

Liengme's Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you're using a PC or a Mac. 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. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with Microsoft Office release of Excel 2016. - Features of Excel 2016 are illustrated through a wide variety of examples based on technical contexts, demonstrating the use of the program for analysis and presentation of experimental results. - Where appropriate, demonstrates the differences between the PC and Mac versions of Excel. - Includes many new end-of-chapter problems at varying levels of difficulty.

Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook

Author: David M Bourg

Publisher: "O'Reilly Media, Inc."

Published: 2006-01-17

Total Pages: 445

ISBN-13: 059655317X

DOWNLOAD EBOOK

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Excel Simulations
Excel Simulations

Author: Gerard M. Verschuuren

Publisher: Tickling Keys, Inc.

Published: 2013-11-01

Total Pages: 177

ISBN-13: 1615473351

DOWNLOAD EBOOK

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.

A Guide to Microsoft Excel 2007 for Scientists and Engineers
A Guide to Microsoft Excel 2007 for Scientists and Engineers

Author: Bernard Liengme

Publisher: Academic Press

Published: 2008-11-27

Total Pages: 337

ISBN-13: 0080923518

DOWNLOAD EBOOK

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 such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data. - Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2007. - Features of Excel 2007 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results. - Updated with new examples, problem sets, and applications.

Applied Statistics for Engineers and Scientists
Applied Statistics for Engineers and Scientists

Author: David M. Levine

Publisher: Pearson

Published: 2001

Total Pages: 746

ISBN-13:

DOWNLOAD EBOOK

For courses in Probability and Statistics. This applied text for engineers and scientists, written in a non-theoretical manner, focuses on underlying principles that are important to students in a wide range of disciplines. It emphasizes the interpretation of results, the presentation and evaluation of assumptions, and the discussion of what should be done if the assumptions are violated. Integration of spreadsheet and statistical software (Microsoft Excel and Minitab) as well as in-depth coverage of quality and experimental design complete this treatment of statistics.

Environmental Geology Workbook
Environmental Geology Workbook

Author: Jack W. Travis

Publisher: Waveland Press

Published: 2019-02-27

Total Pages: 415

ISBN-13: 1478639148

DOWNLOAD EBOOK

Environmental geologists use a wide range of geologic data to solve environmental problems and conflicts. Professionals and academics in this field need to know how to gather information on such diverse conditions as soil type, rock structure, and groundwater flow and then utilize it to understand geological site conditions. Field surveys, maps, well logs, bore holes, ground-penetrating radar, aerial photos, geologic literature, and more help to reveal potential natural hazards in an area or how to remediate contaminated sites. This new workbook presents accessible activities designed to highlight key concepts in environmental geology and give students an idea of what they need to know to join the workforce as an environmental geologist, engineering geologist, geological engineer, or geotechnical engineer. Exercises cover: • Preparation, data collection, and data analysis • Descriptive and engineering properties of earth materials • Basic tools used in conjunction with geoenvironmental investigations • Forces operating on earth materials within the earth • Inanimate forces operating on earth materials at the surface of the earth • Human activities operating on earth materials Each activity encourages students to think critically and develop deeper knowledge of environmental geology.