Author: Bernard V Liengme
Publisher: Morgan & Claypool Publishers
ISBN: 1627054197
Category : Science
Languages : en
Pages : 95
Get Book Here
Book Description
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 tha
Author: Bernard V Liengme
Publisher: Morgan & Claypool Publishers
ISBN: 1627057056
Category : Science
Languages : en
Pages : 205
Get Book Here
Book Description
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 tha
Author: B Liengme
Publisher: Myprint
ISBN: 9781681748078
Category :
Languages : en
Pages : 96
Get Book Here
Book Description
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: Bernard V Liengme
Publisher: Morgan & Claypool Publishers
ISBN: 1681744627
Category : Science
Languages : en
Pages : 99
Get Book Here
Book Description
This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.
Author: Brian R. Kent
Publisher: Morgan & Claypool Publishers
ISBN: 1627059261
Category : Technology & Engineering
Languages : en
Pages : 176
Get Book Here
Book Description
SMath is a free mathematical notebook program similar to Mathcad that provides many options for studying and solving complex mathematical equations. This book is a primer providing a concise but thorough introduction that keeps physics at a fairly low leve
Author: Bernard V Liengme
Publisher: Morgan & Claypool Publishers
ISBN: 1681744619
Category : Science
Languages : en
Pages : 92
Get Book Here
Book Description
This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.
Author: Brian Albright
Publisher: CRC Press
ISBN: 0429945051
Category : Business & Economics
Languages : en
Pages : 461
Get Book Here
Book Description
This text presents a wide variety of common types of models found in other mathematical modeling texts, as well as some new types. However, the models are presented in a very unique format. A typical section begins with a general description of the scenario being modeled. The model is then built using the appropriate mathematical tools. Then it is implemented and analyzed in Excel via step-by-step instructions. In the exercises, we ask students to modify or refine the existing model, analyze it further, or adapt it to similar scenarios.
Author: Hector Guerrero
Publisher: Springer
ISBN: 3030012794
Category : Business & Economics
Languages : en
Pages : 358
Get Book Here
Book Description
This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.
Author: Paul Darbyshire
Publisher: John Wiley & Sons
ISBN: 111994564X
Category : Business & Economics
Languages : en
Pages : 294
Get Book Here
Book Description
Co-authored by two respected authorities on hedge funds and asset management, this implementation-oriented guide shows you how to employ a range of the most commonly used analysis tools and techniques both in industry and academia, for understanding, identifying and managing risk as well as for quantifying return factors across several key investment strategies. The book is also suitable for use as a core textbook for specialised graduate level courses in hedge funds and alternative investments. The book provides hands-on coverage of the visual and theoretical methods for measuring and modelling hedge fund performance with an emphasis on risk-adjusted performance metrics and techniques. A range of sophisticated risk analysis models and risk management strategies are also described in detail. Throughout, coverage is supplemented with helpful skill building exercises and worked examples in Excel and VBA. The book's dedicated website, www.darbyshirehampton.com provides Excel spreadsheets and VBA source code which can be freely downloaded and also features links to other relevant and useful resources. A comprehensive course in hedge fund modelling and analysis, this book arms you with the knowledge and tools required to effectively manage your risks and to optimise the return profile of your investment style.
