What Every Engineer Should Know About Excel
Download What Every Engineer Should Know About Excel PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get What Every Engineer Should Know About Excel book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages.
What Every Engineer Should Know About Excel
With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by Microsoft® ExcelTM. The software is nearly ubiquitous and understanding its capabilities is an enormous benefit to engineers in almost any field and at all levels of experience. What Every Engineer Should Know About Excel offers in nine self-contained chapters a practical guide to the features and functions that can be used, for example, to solve equations and systems of equations, build charts and graphs, create line drawings, and perform optimizations. The author uses examples and screenshots to walk you through the steps and build a strong understanding of the material. With this book, you will learn how to... Set up the keyboard for direct entry of most math and Greek symbols Build a default scatter graph that is applicable to most simple presentations with little cosmetic modification Apply many types of formats to adjust the cosmetics of graphs Use 3D surface and area charts for data and functional representations, with associated cosmetic adjustments Correlate data with various types of functional relations Use line drawing tools to construct simple schematics or other diagrams Solve linear and nonlinear sets of equations using multiple methods Curve student grades using Excel probability functions Model device performance using different types of regression analysis involving multiple variables Manipulate Excel financial functions Calculate retirement accumulation with variable contribution rate and retirement payouts to match increases in inflation Apply Excel methods for optimization problems with both linear and nonlinear relations Use pivot tables to manipulate both experimental data and analytical relationships Calculate experimental uncertainties using Excel And much more!
What Every Engineer Should Know About Data-Driven Analytics
Author: Satish Mahadevan Srinivasan
language: en
Publisher: CRC Press
Release Date: 2023-04-13
What Every Engineer Should Know About Data-Driven Analytics provides a comprehensive introduction to the theoretical concepts and approaches of machine learning that are used in predictive data analytics. By introducing the theory and by providing practical applications, this text can be understood by every engineering discipline. It offers a detailed and focused treatment of the important machine learning approaches and concepts that can be exploited to build models to enable decision making in different domains. Utilizes practical examples from different disciplines and sectors within engineering and other related technical areas to demonstrate how to go from data, to insight, and to decision making Introduces various approaches to build models that exploits different algorithms Discusses predictive models that can be built through machine learning and used to mine patterns from large datasets Explores the augmentation of technical and mathematical materials with explanatory worked examples Includes a glossary, self-assessments, and worked-out practice exercises Written to be accessible to non-experts in the subject, this comprehensive introductory text is suitable for students, professionals, and researchers in engineering and data science.
What Every Engineer Should Know about MATLAB® and Simulink®
Using examples from mathematics, mechanical and electrical engineering, and control and signal processing, this book provides an introduction to MATLAB and Simulink and examines the advantages and limitations of both. The author demonstrates how to visualize the results of calculations in various kinds of graphical representations, how to write useful script files and functions for solving specific problems, how to avoid disastrous, computational errors, and how to insert calculations and graphs into technical reports produced by either MS Word or LaTeX. Companion software with functions and script files are available online.