Book Description
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
Book Description
This applied book for engineers and scientists, written in a non-theoretical manner, focuses on underlying principles that are important 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 complete this treatment of statistics.
Chapter topics include describing and summarizing data; probability and discrete probability distributions; continuous probability distributions and sampling distributions; process control charts; estimation procedures; hypothesis testing; the design of experiments; and simple linear and multiple regression models.
For individuals interested in learning statistics—without a high level of mathematical sophistication.
Customer Reviews:
Very Practical Book.......2003-11-30
I have found this book to be very useful with practical examples and case studies. I felt that as an engineer I needed to know how to use software(to save time)along with the formulas that work in it.This book satisfies that, using a very common software EXCEL..what could be better than this.
I strongly recommend this book for a high level course in statistics.
Good for first edition.......2002-05-10
I used this textbook for a course in statistics. I must say that it was better then the first time that I had taken statistics 5 years ago. The book uses one or two data sets per chapter that helps you focus your thoughts while learning the different techniques. A nice feature about this book that wasnt available 5 years ago is the Excel and Minitab examples which saves a lot of time that is ordinarly spent on copious number crunching. I would have given the book 5 stars, however I found some obvious errors in the book that should have been edited out before the release. Good starter book for sats.
Book Description
Using an informal, conversational style, this "how to" book guides beginning students from spreadsheet basics through the robust engineering and scientific applications of EXCEL, including using EXCEL in the lab.
Students learn how to compose structured, efficient, documented workbooks with data entry cells, summary results and statistics cells, and commented cells. Throughout the book, they'll find innovative techniques for composing spreadsheets, solving problems, analyzing data, and presenting results that will help them in their courses and professional careers. End-of-Chapter problems not only show how to use EXCEL, they also relate directly to topics in engineering and the sciences. Plus, a CD, which is packaged with the text, contains sample workbooks, links to online EXCEL resources, and text updates via the book's web site.
Customer Reviews:
The Cover Says It Is There.......2002-12-19
The CD was missing. Since the CD is referenced throughout the book, one sort of "feels left out" after a while.
Spreadsheet experts stay in balance.......2000-07-01
It is my great pleasure to comment on Van Bloch's textbook on EXCEL for engineers and scientists. His marvellous ability to communicate complicated ideas in simple terms shines through on every page. More than just useful, this book comes to market at a time when electronic spreadsheet analysis has become part and parcel of the day-to-day work of researchers in all areas of engineering and science. Simply put, spreadsheet and data manipulation skills are essential in today's world. Prof. Bloch does his reader's a great service by developing the concepts for use with EXCEL, one of the most widely used spreadsheets in the world. The CD-ROM will be especially helpful to students as they seek to master spreadsheet basics and more advanced techniques.
Book Description
Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to minimize user intervention, automate parameter setup, obtain consistency in both analysis and reporting, and save time through automation. Focusing on the built-in Visual Basic® for Applications (VBA) scripting language of Excel®, the book shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings. It begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use Excel to obtain data from non-native sources, such as databases and third-party calculation tools. After providing the means to access any required information, the book explains how to automate manipulations and calculations on the acquired data sources. Collecting all of the concepts previously discussed in the book, the final chapter demonstrates from beginning to end how to create a cohesive, robust application. With an understanding of this book, readers should be able to construct applications that can import data from a variety of sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.
Book Description
For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.
Customer Reviews:
Just what I needed.......2005-09-22
Since I am in the scientific field and use Excel a lot, I had been waiting for the right book. Well, I finally found it: Well written, concise, excellent examples, and a very fair price. Go for it!
Average customer rating:
|
Guide to Microsoft Excel 2002 for Scientists and Engineers. Third Edition
Bernard V. Liengme
Manufacturer: Butterworth-Heinemann
ProductGroup: Book
Binding: Paperback
 Children's Books
| Subjects
| Books
| Baby-3
| Ages 4-8
| Ages 9-12
| Animals
| Arts & Music
| Books on Cassette
| Books on CD
| Authors & Illustrators, A-Z
| Computers
| Educational
| History & Historical Fiction
| Issues
| Literature
| Obsessions
| People & Places
| Popular Characters
| Reference & Nonfiction
| Religions
| Science, Nature & How It Works
| Series
| Sports & Activities
| Audiobooks
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General & Reference
| Technology
| Science
| Subjects
| Books
General
| Arts & Photography
| Subjects
| Books
All Amazon Upgrade
| Amazon Upgrade
| Stores
| Books
Arts & Photography
| Amazon Upgrade
| Stores
| Books
Computers & Internet
| Amazon Upgrade
| Stores
| Books
Science
| Amazon Upgrade
| Stores
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Arts & Photography
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Children's Books
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Science
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
Excel for Engineers and Scientists, Second Edition
-
Excel for Scientists and Engineers (Excel for Professionals series)
-
Spreadsheet Tools for Engineers: Excel
-
Advanced Excel for Scientific Data Analysis
-
Excel for Scientists and Engineers: Numerical Methods
ASIN: 0750656131 |
Book Description
The new edition has been brought fully up to date with the new Microsoft Office XP release of Excel 2002 but can be used alongside any previous version of Excel, with new Excel 2002 features clearly indicated throughout.
* 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 XP release of Excel 2002.
* Features of Excel 2002 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.
* Can be used alongside any previous version of Excel, with new Excel 2002 features clearly indicated throughout.
Average customer rating:
|
Excel Spreadsheet for Engineers and Scientists
Irvin H. Kral
Manufacturer: Prentice Hall PTR
ProductGroup: Book
Binding: Hardcover
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Engineering
| Professional & Technical
| Subjects
| Books
General & Reference
| Technology
| Science
| Subjects
| Books
Modeling
| Engineering
| Applied
| Mathematics
| Science
| Subjects
| Books
Software
| Information Systems
| Computer Science & Information Systems
| New & Used Textbooks
| Stores
| Books
General
| Engineering
| New & Used Textbooks
| Stores
| Books
ASIN: 0132967650 |
Book Description
An advanced, up-to-date tutorial on programming with the Microsoft Excel spreadsheet program, this is currently the only book available for engineers and scientists that contains complete listings of spreadsheet programs and macros of technical applications. All program segments are based on computer tested code for engineering applications, making this a valuable reference source for engineers and scientists in any field of specialty. The book covers all the important and advanced spreadsheet features and requires no programming ability.
Average customer rating:
- Expensive for this price.
- Practical use of spreadsheets
- Good, but overpriced
- An excellent source of information.
|
A Guide to Microsoft Excel for Scientists and Engineers
Bernard V. Liengme
Manufacturer: John Wiley & Sons Inc
ProductGroup: Book
Binding: Paperback
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Spreadsheets
| Software
| Computers & Internet
| Subjects
| Books
General
| Engineering
| Professional & Technical
| Subjects
| Books
General
| Reference
| Science
| Subjects
| Books
General
| Health, Mind & Body
| Subjects
| Books
ASIN: 0470244283 |
Book Description
Microsoft Excel has a range of functions that can be utilised for the analysis and presentation of experimental results. This text provides a straightforward introduction to these tools directed specifically toward their use in technical subjects.
It begins with a basic introduction to spreadsheets in general and Microsoft Excel in particular, before discussing formulas, charts, curve-fitting, equation solving, macros, statistical functions, logic functions, differentiation, integration and many other associated functions. Two chapters on modelling are also incorporated bringing all the material together to show how Excel can be used to model an entire system. It rounds up with a chapter on report writing, providing valuable instruction on the best way to present results in a formal report.
Written specifically for scientists and engineers this is a book that will be refered to again and again, providing invaluable information on the more technical functions of Microsoft Excel in an accessible and user friendly style.
* Written specifically for scientists and engineers
* Includes chapters on modelling and reporting
* Written clearly and concisely, by an author with a proven track-record in this area
* Includes a broad range of illustrations, including screenshots
* Can be used with any version of Excel, from Excel 5 to Excel 2000
Customer Reviews:
Expensive for this price........2002-10-17
While it would be useful for begineers, I find most of the concepts are raher short and simply presented. I think the amount of information given does not worth to that price. Especially, section regarding writting macros and prograaming are very limited and mostly in psude-code style which doesn't help you gain the experience of excel preograaming.
Practical use of spreadsheets.......2001-06-13
Very helpful examples and good focus on fomulas, equation solving and statistical functions. Report writing section was useful as well.
Good, but overpriced.......1999-10-21
Liengme's guide to Excel is clearly written, has good illustrations, and contains a variety of useful examples. However, I don't know where they get $40 for this thin paperback. Orvis' Excel book is more complete and a better value.
An excellent source of information........1998-11-12
Finally someone has written a very clear concise book explaining Excel in terms that are relevant to scientists and Engineers. For the Engineer who is forced to program in Excel this book is an excellent source of information.
Average customer rating:
|
Excel 4 for Scientists and Engineers
William J. Orvis
Manufacturer: Sybex
ProductGroup: Book
Binding: Paperback
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Spreadsheets
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Science
| Subjects
| Books
ASIN: 0782111963 |
Average customer rating:
- There still is no better for science and engineering applications
- Unveiling the Power of EXCEL in a Easy Manner
- A totally different order of Excel book! Still very current.
- Amaze your colleagues
- Really gives insight on the power and flexibility of Excel.
|
Excel for Scientists and Engineers
William J. Orvis
Manufacturer: Sybex
ProductGroup: Book
Binding: Paperback
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Spreadsheets
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
General
| Science
| Subjects
| Books
ASIN: 0782117619 |
Book Description
Here's a complete sourcebook of numerical methods implemented in Excel. Learn how Excel can simplify all levels of numerical analysis, including those traditionally prepared in high-level programming languages. The companion disk includes all examples and solutions to review problems. Great for students of science and engineering, too!
Customer Reviews:
There still is no better for science and engineering applications.......2006-11-22
This is THE book for teaching or learning how to apply Excel to science and engineering problems. I have tried them all in teaching courses over the past 10 years. None are as clear, authoritative, or instructive.
The book is 10 years old. I will again use it for a course this Spring (2007), but the thread connecting it to current Excel reality is getting stretched thin. Please, please, please write a revsion !!!
Unveiling the Power of EXCEL in a Easy Manner.......2000-10-29
This book is one of a kind. Scientists, engineers and students in the field are already using Excel for data analysis yet Orvis' sourcebook provides a one-flip reference to all the implemented functions of Excel. The second edition features illustration of built-in science and engineering tools and covers Excel for Window 95, Windows 3.1, and Mac.
Reader will learn not only how to calculate and plot simple equations but how to perform curve fitting; calculate statistics, numerical derivatives, and integrals; access external databases; and solve systems of equations and one- and two-dimensional differential equations. The book also explains how to create graphics and how to use the built-in Visual Basic for Applications programming language to extend the capabilities of the Excel worksheets.
Orvis himself is a scientist. The book is based on real uses of a spreadsheet as an engineering tool. Many of the problems were actually solved by Orvis using other techniques before he realized the full potential of the Excel spreadsheets. Therefore the book itself helps solve real problems, not just a textbook problems. This proves to be very helpful for those working in the lab and work on data analysis.
The book assume basic working knowledge with Excel; such as moving around the cells and inserting data. It assumes basic undergrad math. This is highly recommended for scientists and engineers.
A totally different order of Excel book! Still very current........2000-01-23
I've owned copies of both editions of William Orvis's wonderful book and if he revises it again, I'll be first in line for a copy of the third edition. He begins with a general overview of Excel as a scientific and engineering calculation and graphing tool, assuming very little knowledge of Excel and only basic undergrad math skills. It's no book for "dummies," but anyone of reasonable intelligence and clarity of mind will have no difficulty in following what he says here. There are lots of well-explained examples, and the CD which comes with the book makes it easy to reproduce them without laborious data entry. Then he gives a brief survey of Visual Basic for Applications (VBA) -- VBA light, but enough to do many useful things. Next come chapters on data base functions, curve fitting, and series models. After a chapter on numerical differentiation and integration in general, the author deals with techniques for finding roots of nonlinear equations, solving sets of linear and nonlinear equations, and integrating ordinary and partial differential equations. While the book is oriented toward Excel 7 for Win 95, no one is likely to find it at all difficult to apply what it says directly in working with later versions or those running under other OSs. There are lots of topics I'd like to see added, or treated in greater depth, but the author could scarcely have covered more in a single 500-page book, and I have no quarrel with the balance he has chosen. None of the other science- or engineering-oriented Excel books even approach this one in value and coverage -- I've read them all. Excel is no substitute for Mathematica or even MathCad, but this book gave me an entirely different appreciation for the strengths it does offer for analyzing data. This is a book I recommend not only to engineers and "hard" scientists but to anyone with a need for rigorous data analysis.
Amaze your colleagues.......1999-12-06
I bought this book hoping to learn more about macros and visual basic. I learned more than I expected. My colleagues have been using Excel longer than I have and wonder how I know so much about Excel. I wish I had this book when I was in engineering college. Knowing the solver Add-in would have earned me a higher grade guaranteed.
Really gives insight on the power and flexibility of Excel........1999-05-29
Never realized what a powerful analytical tool I had with Excel! The author does a great job of teaching the reader who follows the examples and exercises hands-on. And I've only worked examples througth to the 4th chapter! Very recommendable for anyone doing number crunching and engaged in "what-if?" scenario analysis.
Books:
- Exploratory and Confirmatory Factor Analysis: Understanding Concepts and Applications
- Extraterrestrial Contact: The Evidence and Implications
- Extraterrestrial Contact: The Evidence and Implications
- Faust's Metropolis: A History of Berlin
- Fishing the Everglades: A Complete Guide for the Small Boater
- Flotsam (Caldecott Medal Book)
- Food of the Gods: The Search for the Original Tree of Knowledge A Radical History of Plants, Drugs, and Human Evolution
- Frontiers of Complexity: The Search for Order in a Chaotic World
- Fundamentals of Anatomy & Physiology (7th Edition) (MyA&P Series)
- Fuzzy Sets and Fuzzy Logic: Theory and Applications
Books Index
Books Home
Recommended Books
- Dereliction of Duty : Johnson, McNamara, the Joint Chiefs of Staff, and the Lies That Led to Vietnam
- Bringing Yoga to Life: The Everyday Practice of Enlightened Living
- Towns Without Rivers
- Tropical Colors: Art of Living With Tropical Flowers
- YEARNINGS: EMBRACING THE SACRED MESSINESS OF LIFE
- An Introduction to Systems Biology: Design Principles of Biological Circuits
- A Field Guide to the Birds of Eastern and Central North America
- Love Without End: Jesus Speaks...
- Wars, Women & Other Wonders
- Lt. Ted Meredith, USNR, pt boat officer: Stories from 50 years ago
Excel Scientific and Engineering Cookbook (Cookbooks (O'Reilly))
Engineering with Mathcad: Using Mathcad to Create and Organize your Engineering Calculations
