Articles by "Excel"

Showing posts with label Excel. Show all posts

Thomas J. Quirk ... 248 pages - Publisher: Springer; 1st edition (November 16, 2015) ... Language: English - ISBN-10: 3319235540 - ISBN-13: 978-3319235547 ...

This is the first book to show the capabilities of Microsoft Excel to teach engineering statistics effectively.  It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical engineering problems.  If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in engineering courses.  Its powerful computational ability and graphical functions make learning statistics much easier than in years past.  However, Excel 2013 for Engineering Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand engineering problems.  Practice problems are provided at the end of each chapter with their solutions in an Appendix.  Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

J. P. Holman ... 242 pages - Publisher: CRC Press; 1st edition (June, 2006) ... Language: English - ASIN: B006QOGTDQ by Amazon Digital Services ...

With the many software packages available today, it's easy to overlook the computational and graphics capabilities offered by Microsoft® Excel™. 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 + alculate 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!

Michael Alexander, Dick Kusleika ... 816 pages - Publisher: Wiley; 1st edition (January, 2016) ... Language: English - ISBN-10: 1119067863 - ISBN-13: 978-1119067863 ...

Leverage the full power of Excel formulas: Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas. When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential. Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel + Create and use formulas that have the power to transform your Excel experience + Leverage supplemental material online, including sample files, templates, and worksheets from thebook.

Martin Lee Abbott ... 
552 pages - Publisher: Wiley; 1st edition (September 13, 2011)
Language: English - ISBN-10: 0470889454 - ISBN-13: 978-0470889459

Utilizing the latest software, this book presents the essential statistical procedures for drawing valuable results from data in the social sciences.

Mobilizing interesting real-world examples from the field of education, "Understanding Educational Statistics Using Microsoft Excel and SPSS" supplies a seamless presentation that identifies valuable connections between statistical applications and research design. Class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations and the use of software packages that are accessible to both the novice and professional alike to present the fundamental statistical practices for organizing, understanding, and drawing conclusions from educational research data.

The book begines with an introduction to descriptive and inferential statistics and then proceeds to acquaint readers with the various functions for working with quantitative data in the Microsoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequent chapters treat the procedures that are commonly-employed when working with data across various fields of social science research, including: Single-sample tests Repeated measure tests Independent t-tests One way ANOVA and factorial ANOVA Correlation Bivariate regression Chi square Multiple regression

Individual chapters are devoted to specific procedures, each ending with a lab exercise that highlights the importance of that procedure by posing a research question, examining the question through its application in Excel and SPSS, and concluding with a brief research report that outlines key findings drawn from the results. Real-world examples and data from modern educational research are used throughout the book, and a related Web site features additional data sets, examples, and labs, allowing readers to reinforce their comprehension of the material.

Bridging traditional statistical topics with the latest software and applications in the field of education, "Understanding Educational Statistics Using Microsoft Excel and SPSS" is an excellent book for courses on educational research methods and introductory statistics in the social sciences at the upper-undergraduate and graduate levels. It also serves as a valuable resource for researchers and practitioners in the fields of education, psychology, and the social sciences who require a statistical background to work with data in their everyday work.

Steven T. Karris ... 
627 pages - Publisher: Orchard Publications; 3rd edition (February, 2007) ... 
Language: English - ISBN-10: 1934404039 - ISBN-13: 978-1934404034 ...

This text includes the following chapters and appendices: 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 and distributions, Orthogonal functions and matrix factorizations, Bessel, Legendre, and Chebyshev polynomials, Optimization methods, Difference Equations in Discrete-Time systems, Introduction to Simulink, Ill-Conditioned Matrices. Each chapter contains numerous practical applications supplemented with detailed instructions for using MATLAB and/or Excel to obtain quick solutions. For additional information. please visit the Orchard Publications site.

Mike Alexander, John Walkenbach ... 336 pages - Publisher: Wiley; 1st edition (June, 2012) ... Language: English - ISBN-10: 1118281217 - ISBN-13: 978-1118281215 ...

Save time and be more productive with this helpful guide to Excel macros! While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use. * Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge * Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to solve the problem * Provides an explanation of how each macro works and where to use the macro With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.

Contact Form

Name

Email *

Message *

Powered by Blogger.