Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB PDF Download
Are you looking for read ebook online? Search for your book and save it on your Kindle device, PC, phones or tablets. Download Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB PDF full book. Access full book title Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB by Victor J. Law. Download full books in PDF and EPUB format.
Author: Victor J. Law
Publisher: CRC Press
ISBN: 1482201593
Category : Mathematics
Languages : en
Pages : 249
Get Book Here
Book Description
While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic for Applications (VBA). This led to six years of developing teaching notes that
Author: Victor J. Law
Publisher: CRC Press
ISBN: 1482201593
Category : Mathematics
Languages : en
Pages : 249
Get Book Here
Book Description
While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic for Applications (VBA). This led to six years of developing teaching notes that
Author: E. Joseph Billo
Publisher: John Wiley & Sons
ISBN: 0470126701
Category : Computers
Languages : en
Pages : 480
Get Book Here
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
Author: Steven T. Karris
Publisher: Orchard Publications
ISBN: 0974423912
Category : Education
Languages : en
Pages : 570
Get Book Here
Book Description
Annotation This text provides complete, clear, and detailed explanations of the principal numerical analysis methods and well known functions used in science and engineering. These are illustrated with many practical examples. With this text the reader learns numerical analysis with many real-world applications, MATLAB, and spreadsheets simultaneously. This text includes the following chapters:? Introduction to MATLAB? Root Approximations? Sinusoids and Complex Numbers? Matrices and Determinants? Review of Differential Equations? Fourier, Taylor, and Maclaurin Series? Finite Differences and Interpolation? Linear and Parabolic Regression? Solution of Differential Equations by Numerical Methods? Integration by Numerical Methods? Difference Equations? Partial Fraction Expansion? The Gamma and Beta Functions? Orthogonal Functions and Matrix Factorizations? Bessel, Legendre, and Chebyshev Polynomials? Optimization MethodsEach chapter contains numerous practical applications supplemented with detailed instructionsfor using MATLAB and/or Microsoft Excel? to obtain quick solutions.
Author: Steven T. Karris
Publisher: Orchard Publications
ISBN: 1934404039
Category : Education
Languages : en
Pages : 633
Get Book Here
Book Description
This text is written primarily for students/readers who have a good background of high-school algebra, geometry, trigonometry, and the fundamentals of differential and integral calculus.
Author: Shinil Cho
Publisher: Morgan & Claypool Publishers
ISBN: 164327726X
Category : Science
Languages : en
Pages : 162
Get Book Here
Book Description
This book covers essential Microsoft EXCEL®'s computational skills while analyzing introductory physics projects. Topics of numerical analysis include; multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.
Author: James F. Epperson
Publisher: John Wiley & Sons
ISBN: 1118626230
Category : Mathematics
Languages : en
Pages : 579
Get Book Here
Book Description
Praise for the First Edition ". . . outstandingly appealing with regard to its style, contents, considerations of requirements of practice, choice of examples, and exercises." —Zentrablatt Math ". . . carefully structured with many detailed worked examples . . ." —The Mathematical Gazette ". . . an up-to-date and user-friendly account . . ." —Mathematika An Introduction to Numerical Methods and Analysis addresses the mathematics underlying approximation and scientific computing and successfully explains where approximation methods come from, why they sometimes work (or don't work), and when to use one of the many techniques that are available. Written in a style that emphasizes readability and usefulness for the numerical methods novice, the book begins with basic, elementary material and gradually builds up to more advanced topics. A selection of concepts required for the study of computational mathematics is introduced, and simple approximations using Taylor's Theorem are also treated in some depth. The text includes exercises that run the gamut from simple hand computations, to challenging derivations and minor proofs, to programming exercises. A greater emphasis on applied exercises as well as the cause and effect associated with numerical mathematics is featured throughout the book. An Introduction to Numerical Methods and Analysis is the ideal text for students in advanced undergraduate mathematics and engineering courses who are interested in gaining an understanding of numerical methods and numerical analysis.
Author: Robert De Levie
Publisher: Oxford University Press, USA
ISBN: 0195152751
Category : Computers
Languages : en
Pages : 631
Get Book Here
Book Description
This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).
Author: James Hiestand
Publisher: Jones & Bartlett Publishers
ISBN: 1449613012
Category : Mathematics
Languages : en
Pages : 302
Get Book Here
Book Description
Numerical Methods with VBA Programming provides a unique and unified treatment of numerical methods and VBA computer programming, topics that naturally support one another within the study of engineering and science. This engaging text incorporates real-world scenarios to motivate technical material, helping students understand and retain difficult and key concepts. Such examples include comparing a two-point boundary value problem to determining when you should leave for the airport to catch a scheduled flight. Numerical examples are accompanied by closed-form solutions to demonstrate their correctness. Within the programming sections, tips are included that go beyond language basics to make programming more accessible for students. A unique section suggest ways in which the starting values for non-linear equations may be estimated. Flow charts for many of the numerical techniques discussed provide general guidance to students without revealing all of the details. Useful appendices provide summaries of Excel and VBA commands, Excel functions accessible in VBA, basics of differentiation, and more!
Author: A. Nandy
Publisher: Alpha Science Int'l Ltd.
ISBN: 9781842651674
Category : Computers
Languages : en
Pages : 308
Get Book Here
Book Description
This text presents numerical analysis in an easy and lucid manner requiring no prior knowledge of computer programming or intricacies of mathematics using MS-EXCEL 2000 through built in functions of MS-Excel depicting with ease various analysis. The analysis used can also be done using earlier versions of MS-Excel. The majority of numerical analysis needs fall into the curve fitting, interpolation, solutions of equations, integration methods. For these Excel's features provide a very easy and inexpensive way to get the job done.
Author: Matt Davison
Publisher: CRC Press
ISBN: 1439871698
Category : Business & Economics
Languages : en
Pages : 523
Get Book Here
Book Description
Teach Your Students How to Become Successful Working Quants Quantitative Finance: A Simulation-Based Introduction Using Excel provides an introduction to financial mathematics for students in applied mathematics, financial engineering, actuarial science, and business administration. The text not only enables students to practice with the basic techniques of financial mathematics, but it also helps them gain significant intuition about what the techniques mean, how they work, and what happens when they stop working. After introducing risk, return, decision making under uncertainty, and traditional discounted cash flow project analysis, the book covers mortgages, bonds, and annuities using a blend of Excel simulation and difference equation or algebraic formalism. It then looks at how interest rate markets work and how to model bond prices before addressing mean variance portfolio optimization, the capital asset pricing model, options, and value at risk (VaR). The author next focuses on binomial model tools for pricing options and the analysis of discrete random walks. He also introduces stochastic calculus in a nonrigorous way and explains how to simulate geometric Brownian motion. The text proceeds to thoroughly discuss options pricing, mostly in continuous time. It concludes with chapters on stochastic models of the yield curve and incomplete markets using simple discrete models. Accessible to students with a relatively modest level of mathematical background, this book will guide your students in becoming successful quants. It uses both hand calculations and Excel spreadsheets to analyze plenty of examples from simple bond portfolios. The spreadsheets are available on the book’s CRC Press web page.
