Decision Analytics

Microsoft Excel

Author: Conrad George Carlberg

Publisher: Que Publishing

ISBN: 0789751682

Category: Business & Economics

Page: 272

View: 5036

DOWNLOAD NOW »

Explains how to distil big data into manageable sets and use them to optimise business and investment decisions. Reveals techniques to improve a wide range of decisions, and use simple Excel charts to grasp the results. Includes downloadable Excel workbooks to adapt to your own requirements.
Release

Predictive Analytics

Microsoft Excel 2016

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 9780789758354

Category: Business forecasting

Page: 384

View: 7738

DOWNLOAD NOW »

Microsoft Excel MVP Conrad Carlberg shows readers how to use Excel predictive analytics to solve real-world problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, showing how to gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS. Readers will get an extensive collection of downloadable Excel workbooks that can be easily adapted to their own unique requirements, plus VBA code--much of it open-source--to streamline several of this book's most complex techniques. Step by step, readers build on Excel skills they already have, learning advanced techniques that can help them increase revenue, reduce costs, and improve productivity.
Release

Data Analysis and Decision Making with Microsoft Excel, Revised

Author: S. Christian Albright,Wayne Winston,Christopher Zappe

Publisher: Cengage Learning

ISBN: 0324662440

Category: Business & Economics

Page: 1104

View: 2696

DOWNLOAD NOW »

The emphasis of the text is on data analysis, modeling, and spreadsheet use in statistics and management science. This text contains professional Excel software add-ins. The authors maintain the elements that have made this text a market leader in its first edition: clarity of writing, a teach-by-example approach, and complete Excel integration. This edition has been revised to be compatible with Excel 2007 and the corresponding add-ins for Excel 2007. If you have moved to Excel 2007, you should use this revised edition. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Regression Analysis Microsoft Excel

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 9780789756558

Category: Business & Economics

Page: 368

View: 1336

DOWNLOAD NOW »

This is today's most complete guide to regression analysis with Microsoft® Excel for any business analytics or research task. Drawing on 25 years of advanced statistical experience, Microsoft MVP Conrad Carlberg shows how to use Excel's regression-related worksheet functions to perform a wide spectrum of practical analyses. Carlberg clearly explains all the theory you'll need to avoid mistakes, understand what your regressions are really doing, and evaluate analyses performed by others. From simple correlations and t-tests through multiple analysis of covariance, Carlberg offers hands-on, step-by-step walkthroughs using meaningful examples. He discusses the consequences of using each option and argument, points out idiosyncrasies and controversies associated with Excel's regression functions, and shows how to use them reliably in fields ranging from medical research to financial analysis to operations. You don't need expensive software or a doctorate in statistics to work with regression analyses. Microsoft Excel has all the tools you need--and this book has all the knowledge! Understand what regression analysis can and can't do, and why Master regression-based functions built into all recent versions of Excel Work with correlation and simple regression Make the most of Excel's improved LINEST() function Plan and perform multiple regression Distinguish the assumptions that matter from the ones that don't Extend your analysis options by using regression instead of traditional analysis of variance Add covariates to your analysis to reduce bias and increase statistical power
Release

Microsoft Excel 2019 Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Microsoft Press

ISBN: 9781509305889

Category:

Page: 864

View: 2612

DOWNLOAD NOW »

Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables-and how to effectively build a relational data source inside an Excel workbook.
Release

More Predictive Analytics

Microsoft Excel

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 0134070933

Category: Computers

Page: 336

View: 9396

DOWNLOAD NOW »

Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers! In More Predictive Analytics, Microsoft Excel® MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code--all you need is Excel and this all-new, crystal-clear tutorial. Carlberg goes beyond his highly-praised Predictive Analytics, introducing proven methods for creating more specific, actionable forecasts. You’ll learn how to predict what customers will spend on a given product next year… project how many patients your hospital will admit next quarter… tease out the effects of seasonality (or patterns that recur over a day, year, or any other period)… distinguish real trends from mere “noise.” Drawing on more than 20 years of experience, Carlberg helps you master powerful techniques such as autocorrelation, differencing, Holt-Winters, backcasting, polynomial regression, exponential smoothing, and multiplicative modeling. Step by step, you’ll learn how to make the most of built-in Excel tools to gain far deeper insights from your data. To help you get better results faster, Carlberg provides downloadable Excel workbooks you can easily adapt for your own projects. If you’re ready to make better forecasts for better decision-making, you’re ready for More Predictive Analytics. Discover when and how to use smoothing instead of regression Test your data for trends and seasonality Compare sets of observations with the autocorrelation function Analyze trended time series with Excel’s Solver and Analysis ToolPak Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future Initialize your forecasts with a solid baseline Improve your initial forecasts with backcasting and optimization Fully reflect simple or complex seasonal patterns in your forecasts Account for sudden, unexpected changes in trends, from fads to new viral infections Use range names to control complex forecasting models more easily Compare additive and multiplicative models, and use the right model for each task
Release

Microsoft Excel Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Microsoft Press

ISBN: 1509304223

Category: Computers

Page: 864

View: 5629

DOWNLOAD NOW »

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel–and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes’ Theorem Automate repetitive tasks by using macros
Release

Multi-criteria Decision Analysis

Methods and Software

Author: Alessio Ishizaka,Philippe Nemery

Publisher: John Wiley & Sons

ISBN: 1118644913

Category: Mathematics

Page: 312

View: 1172

DOWNLOAD NOW »

This book presents an introduction to MCDA followed by more detailed chapters about each of the leading methods used in this field. Comparison of methods and software is also featured to enable readers to choose the most appropriate method needed in their research. Worked examples as well as the software featured in the book are available on an accompanying website.
Release