The Resource Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
Resource Information
The item Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Sydney Jones Library, University of Liverpool.This item is available to borrow from 1 library branch.
Resource Information
The item Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Sydney Jones Library, University of Liverpool.
This item is available to borrow from 1 library branch.
- Summary
- 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
- Language
- eng
- Extent
- 1 online resource (96 pages)
- Note
-
- "Version: 20141001"--Title page verso
- "A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso
- Contents
-
- Preface -- Acknowledgments -- Author biography
- Projectile trajectory -- Football trajectory -- Adding air resistance
- The pursuit problem -- The numerical approach -- Comparison with the analytical solution
- 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
- Temperature profile -- A formula method -- A matrix method -- A Solver method
- 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
- 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
- Superposition of sine waves and Fourier series -- Addition of sine waves; generation of beats -- Fourier series -- Parametric plots and Lissajous curves
- Fast Fourier transform
- Applying statistics to experimental data -- Comparing averages -- Comparing variances -- Are my data normally distributed?
- Electrostatics -- Coulomb's law -- Electrostatic potential -- Discrete form of Laplace equation
- Random events -- Random walk and Brownian motion -- A random self-avoiding walk
- Isbn
- 9781627054195
- Label
- Modelling physics with Microsoft Excel
- Title
- Modelling physics with Microsoft Excel
- Statement of responsibility
- Bernard V. Liengme
- Title variation
- Modeling physics with Microsoft Excel
- Language
- eng
- Summary
- 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
- Cataloging source
- CaBNVSL
- http://library.link/vocab/creatorName
- Liengme, Bernard V
- Illustrations
- illustrations
- Index
- no index present
- Intended audience
- Professional and scholarly
- LC call number
- QA76.95
- LC item number
- .L546eb
- Literary form
- non fiction
- Nature of contents
-
- dictionaries
- bibliography
- http://library.link/vocab/subjectName
-
- Physics
- Mathematics
- Electronic spreadsheets
- Mathematical modelling
- SCIENCE / Physics / Mathematical & Computational
- Target audience
- adult
- Label
- Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
- Note
-
- "Version: 20141001"--Title page verso
- "A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso
- Bibliography note
- Includes bibliographical references
- Carrier category
- online resource
- Carrier MARC source
- rdacarrier
- Color
- black and white
- Content category
- text
- Content type MARC source
- rdacontent
- Contents
-
- Preface -- Acknowledgments -- Author biography
- Projectile trajectory -- Football trajectory -- Adding air resistance
- The pursuit problem -- The numerical approach -- Comparison with the analytical solution
- 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
- Temperature profile -- A formula method -- A matrix method -- A Solver method
- 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
- 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
- Superposition of sine waves and Fourier series -- Addition of sine waves; generation of beats -- Fourier series -- Parametric plots and Lissajous curves
- Fast Fourier transform
- Applying statistics to experimental data -- Comparing averages -- Comparing variances -- Are my data normally distributed?
- Electrostatics -- Coulomb's law -- Electrostatic potential -- Discrete form of Laplace equation
- Random events -- Random walk and Brownian motion -- A random self-avoiding walk
- Control code
- 9781627054195
- Dimensions
- unknown
- Extent
- 1 online resource (96 pages)
- File format
- multiple file formats
- Form of item
- online
- Isbn
- 9781627054195
- Media category
- electronic
- Media MARC source
- isbdmedia
- Other control number
- 10.1088/978-1-627-05419-5
- Other physical details
- illustrations.
- Reformatting quality
- access
- Specific material designation
- remote
- System details
-
- "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
- System requirements: Adobe Acrobat Reader
- Label
- Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
- Note
-
- "Version: 20141001"--Title page verso
- "A Morgan & Claypool publication as part of IOP Concise Physics"-Title page verso
- Bibliography note
- Includes bibliographical references
- Carrier category
- online resource
- Carrier MARC source
- rdacarrier
- Color
- black and white
- Content category
- text
- Content type MARC source
- rdacontent
- Contents
-
- Preface -- Acknowledgments -- Author biography
- Projectile trajectory -- Football trajectory -- Adding air resistance
- The pursuit problem -- The numerical approach -- Comparison with the analytical solution
- 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
- Temperature profile -- A formula method -- A matrix method -- A Solver method
- 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
- 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
- Superposition of sine waves and Fourier series -- Addition of sine waves; generation of beats -- Fourier series -- Parametric plots and Lissajous curves
- Fast Fourier transform
- Applying statistics to experimental data -- Comparing averages -- Comparing variances -- Are my data normally distributed?
- Electrostatics -- Coulomb's law -- Electrostatic potential -- Discrete form of Laplace equation
- Random events -- Random walk and Brownian motion -- A random self-avoiding walk
- Control code
- 9781627054195
- Dimensions
- unknown
- Extent
- 1 online resource (96 pages)
- File format
- multiple file formats
- Form of item
- online
- Isbn
- 9781627054195
- Media category
- electronic
- Media MARC source
- isbdmedia
- Other control number
- 10.1088/978-1-627-05419-5
- Other physical details
- illustrations.
- Reformatting quality
- access
- Specific material designation
- remote
- System details
-
- "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
- System requirements: Adobe Acrobat Reader
Library Links
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.liverpool.ac.uk/portal/Modelling-physics-with-Microsoft-Excel-Bernard/wZY3drB4lBo/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.liverpool.ac.uk/portal/Modelling-physics-with-Microsoft-Excel-Bernard/wZY3drB4lBo/">Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.liverpool.ac.uk/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.liverpool.ac.uk/">Sydney Jones Library, University of Liverpool</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.liverpool.ac.uk/portal/Modelling-physics-with-Microsoft-Excel-Bernard/wZY3drB4lBo/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.liverpool.ac.uk/portal/Modelling-physics-with-Microsoft-Excel-Bernard/wZY3drB4lBo/">Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.liverpool.ac.uk/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.liverpool.ac.uk/">Sydney Jones Library, University of Liverpool</a></span></span></span></span></div>
