國立虎尾科技大學 |

Modelling physics with Microsoft Excel /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Modelling physics with Microsoft Excel // Bernard V. Liengme.
remainder title:	Modeling physics with Microsoft Excel
Author:	Liengme, Bernard V.,
Description:	1 online resource (96 pages) :illustrations. :
Notes:	"Version: 20141001"--Title page verso.
Subject:	Physics - Data processing. -
Online resource:	http://iopscience.iop.org/book/978-1-627-05419-5
ISBN:	9781627054195

Modelling physics with Microsoft Excel /
Liengme, Bernard V.,

Modelling physics with Microsoft Excel /Modeling physics with Microsoft ExcelBernard V. Liengme. - 1 online resource (96 pages) :illustrations. - IOP concise physics..

"Version: 20141001"--Title page verso.

Includes bibliographical references.

Preface -- Acknowledgments -- Author biography

This book demonstrates some of the ways in which Microsoft Excel may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly Excel is never going to out-perform the wonderful symbolic algebra tools that we have today - Mathematica, Mathcad, Maple, MATLAB, etc. However, from a pedagogical stance Excel has the advantage of not being a 'black box' approach to problem solving. The user must do a lot more work than just call up a function. The intermediate steps in a calculation are displayed on the worksheet. Another advantage is the somewhat less steep learning curve. This book shows Excel in action in various areas within Physics. Some Visual Basic for Applications (VBA) has been introduced, the purpose here is to show how the power of Excel can be greatly extended and hopefully to whet the appetite of a few readers to get familiar with the power of VBA. Those with programming experience in any other language should be able to follow the code.

Professional and scholarly.

"The workbooks for this project were made using Excel 2013 but they should all work with the earlier Excel 2007 or Excel 2010 versions" --Preface.

Bernard Liengme attended Imperial College London for his undergraduate and postgraduate degrees; he held post-doctoral fellowships at Carnegie-Mellon University and the University of British Columbia. He has conducted extensive research in surface chemistry and the Mossbauer effect. He has been at St Francis Xavier University in Canada since 1968 as a Professor, Associate Dean and Registrar, as well as teaching chemistry and computer science. He currently lectures part-time on business information systems. Bernard is also the author of other successful books: COBOL by Command (1996), A Guide to Microsoft Excel for Scientists and Engineers (now in its 4th edition) and A Guide to Microsoft Excel for Business and Management (now in its 2nd edition).

ISBN: 9781627054195

Standard No.: 10.1088/978-1-627-05419-5doiSubjects--Topical Terms:

595761
Physics
--Data processing.

LC Class. No.: QA76.95 / .L546eb

Modelling physics with Microsoft Excel /
LDR:05381nam 2200601 i 4500 001 813078
003 IOP
005 20141207145412.0
006 m eo d
007 cr bn |||m|||a
008 150812s2014 caua ob 000 0 eng c
020 $a 9781627054195 $q ebook
020 $z 9781627054188 $q print
024 7 $a 10.1088/978-1-627-05419-5 $2 doi
035 $a (CaBNVSL)thg00914799
035 $a (OCoLC)896372576
035 $a 9781627054195
040 $a CaBNVSL $b eng $e rda $c CaBNVSL $d CaBNVSL
050 4 $a QA76.95 $b .L546eb
072 7 $a PBWH $2 bicssc
072 7 $a SCI040000 $2 bisacsh
100 1 $a Liengme, Bernard V., $e author. $3 1030920
245 1 0 $a Modelling physics with Microsoft Excel / $c Bernard V. Liengme.
246 3 $a Modeling physics with Microsoft Excel
264 1 $a San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) : $b Morgan & Claypool Publishers, $c [2014]
264 2 $a Bristol [England] (Temple Circus, Temple Way, Bristol BS1 6HG, UK) : $b IOP Publishing
300 $a 1 online resource (96 pages) : $b illustrations.
336 $a text $2 rdacontent
337 $a electronic $2 isbdmedia
338 $a online resource $2 rdacarrier
500 $a "Version: 20141001"--Title page verso.
500 $a "A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso.
504 $a Includes bibliographical references.
505 0 $a Preface -- Acknowledgments -- Author biography
505 8 $a Projectile trajectory -- Football trajectory -- Adding air resistance
505 8 $a The pursuit problem -- The numerical approach -- Comparison with the analytical solution
505 8 $a Equation solving with and without Solver -- The van der Waals equation : the fixed point iteration method -- van der Waals equation : using Solver -- Finding roots graphically -- Newton-Raphson method -- Using Solver to obtain multiple roots -- The secant method and goal seek -- The inverse quadratic method -- Solving systems of linear equations -- Solving a system of non-linear equations -- Closing note on Solver
505 8 $a Temperature profile -- A formula method -- A matrix method -- A Solver method
505 8 $a Numerical integration -- Trapezoid rule and Simpson's 1/3 rule -- Centroid of a plane using Simpson's 1/3 rule -- Monte Carlo method I -- Monte Carlo method II -- Buffon's needle
505 8 $a Approximate solutions to differential equations -- Ordinary differential equations (ODEs) -- Euler's method -- The Runge-Kutta method -- Testing for convergence -- Systems of ODEs and second-order ODEs
505 8 $a Superposition of sine waves and Fourier series -- Addition of sine waves; generation of beats -- Fourier series -- Parametric plots and Lissajous curves
505 8 $a Fast Fourier transform
505 8 $a Applying statistics to experimental data -- Comparing averages -- Comparing variances -- Are my data normally distributed?
505 8 $a Electrostatics -- Coulomb's law -- Electrostatic potential -- Discrete form of Laplace equation
505 8 $a Random events -- Random walk and Brownian motion -- A random self-avoiding walk.
520 3 $a This book demonstrates some of the ways in which Microsoft Excel may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly Excel is never going to out-perform the wonderful symbolic algebra tools that we have today - Mathematica, Mathcad, Maple, MATLAB, etc. However, from a pedagogical stance Excel has the advantage of not being a 'black box' approach to problem solving. The user must do a lot more work than just call up a function. The intermediate steps in a calculation are displayed on the worksheet. Another advantage is the somewhat less steep learning curve. This book shows Excel in action in various areas within Physics. Some Visual Basic for Applications (VBA) has been introduced, the purpose here is to show how the power of Excel can be greatly extended and hopefully to whet the appetite of a few readers to get familiar with the power of VBA. Those with programming experience in any other language should be able to follow the code.
521 $a Professional and scholarly.
530 $a Also available in print.
538 $a "The workbooks for this project were made using Excel 2013 but they should all work with the earlier Excel 2007 or Excel 2010 versions" --Preface.
538 $a Mode of access: World Wide Web.
538 $a System requirements: Adobe Acrobat Reader.
545 $a Bernard Liengme attended Imperial College London for his undergraduate and postgraduate degrees; he held post-doctoral fellowships at Carnegie-Mellon University and the University of British Columbia. He has conducted extensive research in surface chemistry and the Mossbauer effect. He has been at St Francis Xavier University in Canada since 1968 as a Professor, Associate Dean and Registrar, as well as teaching chemistry and computer science. He currently lectures part-time on business information systems. Bernard is also the author of other successful books: COBOL by Command (1996), A Guide to Microsoft Excel for Scientists and Engineers (now in its 4th edition) and A Guide to Microsoft Excel for Business and Management (now in its 2nd edition).
588 $a Title from PDF title page (viewed on December 4, 2014).
650 0 $a Physics $x Data processing. $3 595761
650 0 $a Mathematics $x Data processing. $3 527942
650 0 $a Electronic spreadsheets. $3 565512
650 7 $a Mathematical modelling. $2 bicssc $3 1030921
650 7 $a SCIENCE / Physics / Mathematical & Computational. $2 bisacsh $3 985733
710 2 $a Institute of Physics (Great Britain), $e publisher. $3 985711
776 0 8 $i Print version $z 9781627054188
830 0 $a IOP concise physics. $3 985735
856 4 0 $u http://iopscience.iop.org/book/978-1-627-05419-5