Decision Analytics

Microsoft Excel

Author: Conrad George Carlberg

Publisher: Que Publishing

ISBN: 0789751682

Category: Business & Economics

Page: 272

View: 1291

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

Data Analysis and Decision Making with Microsoft Excel, Revised

Author: S. Albright,Wayne Winston,Christopher Zappe

Publisher: Cengage Learning

ISBN: 0324662440

Category: Business & Economics

Page: 1104

View: 5325

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

Business Analysis

Microsoft Excel 2010

Author: Conrad Carlberg

Publisher: Pearson Education

ISBN: 9780789746894

Category: Computers

Page: 528

View: 6338

ANSWER KEY BUSINESS QUESTIONS CONTROL COMPANY FINANCES FORECAST SALES PREPARE BUSINESS CASES MAKE BETTER INVESTMENT DECISIONS IMPROVE QUALITY USE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITS Using real-world examples, Carlberg helps you put Excel’s features and functions to work and get the power of quantitative analysis behind your management decisions. Excel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010’s newest features and functions. Along the way, you’ll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions, insider insights, complete step-by-step projects, and more. It’s all complemented by an extraordinary set of web-based resources, from sample journals and ledgers to business forecasting tools. • Use Excel analysis tools to solve problems throughout the business • Build and work with income statements and balance sheets • Value inventories and current assets, and summarize transactions • Calculate working capital and analyze cash flows • Move from pro formas to operating budgets that help guide your management decisions • Prepare business cases incorporating everything from discount rates to margin and contribution analysis About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel skills, and presents focused tasks and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will: • Dramatically increase your productivity–saving you 50 hours a year, or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make
Release

Predictive Analytics

Microsoft Excel

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 0132967251

Category: Business & Economics

Page: 336

View: 5086

Excel predictive analytics for serious data crunchers! The movie Moneyball made predictive analytics famous: Now you can apply the same techniques to help your business win. You don’t need multimillion-dollar software: All the tools you need are available in Microsoft Excel, and all the knowledge and skills are right here, in this book! Microsoft Excel MVP Conrad Carlberg shows you 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. You’ll get an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code—much of it open-source—to streamline several of this book’s most complex techniques. Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself. • Learn both the “how” and “why” of using data to make better tactical decisions • Choose the right analytics technique for each problem • Use Excel to capture live real-time data from diverse sources, including third-party websites • Use logistic regression to predict behaviors such as “will buy” versus “won’t buy” • Distinguish random data bounces from real, fundamental changes • Forecast time series with smoothing and regression • Construct more accurate predictions by using Solver to find maximum likelihood estimates • Manage huge numbers of variables and enormous datasets with principal components analysis and Varimax factor rotation • Apply ARIMA (Box-Jenkins) techniques to build better forecasts and understand their meaning
Release

Predictive Analytics

Microsoft Excel

Author: Conrad George Carlberg

Publisher: Pearson Education

ISBN: 0789749416

Category: Business & Economics

Page: 290

View: 8720

Explains how to use Excel predictive analytics to solve problems in areas ranging from sales and marketing to operations. Reveals how to build credible and reliable forecasts. Describes advanced techniques to build revenue, reduce costs and improve productivity. Includes downloadable Excel workbooks to adapt to your own requirements.
Release

Multi-criteria Decision Analysis

Methods and Software

Author: Alessio Ishizaka,Philippe Nemery

Publisher: John Wiley & Sons

ISBN: 1118644913

Category: Mathematics

Page: 312

View: 4275

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

Decision Analytics and Optimization in Disease Prevention and Treatment

Author: Nan Kong

Publisher: John Wiley & Sons

ISBN: 1118960122

Category: Business & Economics

Page: 432

View: 5726

A systematic review of the most current decision models and techniques for disease prevention and treatment Decision Analytics and Optimization in Disease Prevention and Treatment offers a comprehensive resource of the most current decision models and techniques for disease prevention and treatment. With contributions from leading experts in the field, this important resource presents information on the optimization of chronic disease prevention, infectious disease control and prevention, and disease treatment and treatment technology. Designed to be accessible, in each chapter the text presents one decision problem with the related methodology to showcase the vast applicability of operations research tools and techniques in advancing medical decision making. This vital resource features the most recent and effective approaches to the quickly growing field of healthcare decision analytics, which involves cost-effectiveness analysis, stochastic modeling, and computer simulation. Throughout the book, the contributors discuss clinical applications of modeling and optimization techniques to assist medical decision making within complex environments. Accessible and authoritative, Decision Analytics and Optimization in Disease Prevention and Treatment: Presents summaries of the state-of-the-art research that has successfully utilized both decision analytics and optimization tools within healthcare operations research Highlights the optimization of chronic disease prevention, infectious disease control and prevention, and disease treatment and treatment technology Includes contributions by well-known experts from operations researchers to clinical researchers, and from data scientists to public health administrators Offers clarification on common misunderstandings and misnomers while shedding light on new approaches in this growing area Designed for use by academics, practitioners, and researchers, Decision Analytics and Optimization in Disease Prevention and Treatment offers a comprehensive resource for accessing the power of decision analytics and optimization tools within healthcare operations research.
Release

R for Microsoft® Excel Users

Making the Transition for Statistical Analysis

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 0134571894

Category: Business & Economics

Page: 272

View: 8461

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. Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis–if you can get over its learning curve. In R for Microsoft® Excel Users, Conrad Carlberg shows exactly how to get the most from both programs. Drawing on his immense experience helping organizations apply statistical methods, Carlberg reviews how to perform key tasks in Excel, and then guides you through reaching the same outcome in R–including which packages to install and how to access them. Carlberg offers expert advice on when and how to use Excel, when and how to use R instead, and the strengths and weaknesses of each tool. Writing in clear, understandable English, Carlberg combines essential statistical theory with hands-on examples reflecting real-world challenges. By the time you’ve finished, you’ll be comfortable using R to solve a wide spectrum of problems–including many you just couldn’t handle with Excel. • Smoothly transition to R and its radically different user interface • Leverage the R community’s immense library of packages • Efficiently move data between Excel and R • Use R’s DescTools for descriptive statistics, including bivariate analyses • Perform regression analysis and statistical inference in R and Excel • Analyze variance and covariance, including single-factor and factorial ANOVA • Use R’s mlogit package and glm function for Solver-style logistic regression • Analyze time series and principal components with R and Excel
Release

Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics

Author: Cliff Ragsdale

Publisher: Cengage Learning

ISBN: 130594741X

Category: Business & Economics

Page: 864

View: 8944

Written by an innovator in teaching spreadsheets and a highly regarded leader in business analytics, Cliff Ragsdale’s SPREADSHEET MODELING AND DECISION ANALYSIS: A PRACTICAL INTRODUCTION TO BUSINESS ANALYTICS, 8E helps readers master important spreadsheet and business analytics skills. Readers find everything needed to become proficient in today’s most widely used business analytics techniques using Microsoft Office Excel 2016. Learning to make effective decisions in today's business world takes training and experience. Author Cliff Ragsdale guides learners through the skills needed, using the latest Excel for Windows. Readers apply what they’ve learned to real business situations with step-by-step instructions and annotated screen images that make examples easy to follow. The World of Management Science sections further demonstrates how each topic applies to a real company. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics

Author: Cliff Ragsdale

Publisher: Cengage Learning

ISBN: 1285969707

Category: Business & Economics

Page: 840

View: 1433

SPREADSHEET MODELING AND DECISION ANALYSIS, Seventh Edition, provides instruction in the most commonly used management science techniques and shows how these tools can be implemented using Microsoft Office Excel 2013. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Data Analysis and Decision Making with Microsoft Excel

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

Publisher: Duxbury Resource Center

ISBN: 9780534261245

Category: Business & Economics

Page: 996

View: 2393

In response to the growing market trend in quantitative education, Albright, Winston, and Zappe's integrated business-statistics and management-science book presents core statistics and management-science book presents core statistics and management-science methods in a modern, unified spreadsheet-oriented approach. With a focus on applications, not on mathematical techniques, the book covers business statistics with some essential management-science topics included. The example-based, Excel spreadsheet approach is useful in courses that combine traditional statistics and management-science topics, though it can be easily used for a one-term business statistics only course. The modeling and application focus, together with the Excel spreadsheet add-ins, provides a complete learning source for both students and practicing managers.
Release

Statistik mit Excel für Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 3527811702

Category: Computers

Page: 535

View: 1236

Statistiken und Aussagen zu Wahrscheinlichkeiten begegnen uns heute überall: Die Umsatzentwicklung in Unternehmen, Hochrechnungen für Wahlergebnisse, PISA-Ergebnisse fünfzehnjähriger Schüler sind nur drei von zahlreichen Beispielen. Joseph Schmuller zeigt Ihnen in diesem Buch, wie Sie die Zahlen in den Griff bekommen und Daten, Statistiken und Wahrscheinlichkeiten richtig lesen und interpretieren. Dafür brauchen Sie keinen Statistikkurs zu belegen und kein Mathegenie zu sein. Für alles gibt es in Excel die passende Funktion und das passende Werkzeug. So können Sie Theorie und Praxis sofort miteinander verbinden.
Release

Business Analytics: Data Analysis & Decision Making

Author: S. Christian Albright,Wayne L. Winston

Publisher: Cengage Learning

ISBN: 1337225274

Category: Business & Economics

Page: 984

View: 4071

Master data analysis, modeling, and spreadsheet use with BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 6E! Popular with students, instructors, and practitioners, this quantitative methods text delivers the tools to succeed with its proven teach-by-example approach, user-friendly writing style, and complete Excel 2016 integration. It is also compatible with Excel 2013, 2010, and 2007. Completely rewritten, Chapter 17, Data Mining, and Chapter 18, Importing Data into Excel, include increased emphasis on the tools commonly included under the Business Analytics umbrella -- including Microsoft Excel’s “Power BI” suite. In addition, up-to-date problem sets and cases provide realistic examples to show the relevance of the material. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Business Analysis with Microsoft Excel, (Adobe Reader)

Author: Conrad Carlberg

Publisher: Pearson Education

ISBN: 9780132713597

Category: Business & Economics

Page: 504

View: 5808

Whether you own a small business or work for a large corporation–whether you are looking for help making financial and business decisions–this book is for you. Business Analysis with Microsoft® Excel, Third Edition, provides in-depth information that will streamline your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions: • What’s the relationship between my cost of goods sold and my inventory? • How do I get Excel to keep these values up-to-date on my income statement and my balance sheet? • I have to track service quality over time. How can I automate that using Excel charts? • How can I forecast future demand for my products, based on prior sales results? • What’s the difference between financial leverage and operating leverage? How do I calculate them using my financial records? • I need to project my financials for next year. Does Excel have a tool for that? What do I need to know to use it effectively? • How do I do all these things using the new Ribbon in Excel 2007? • What are the best ways to automate a connection between Excel and an external database? Category Spreadsheets Covers Applicable for versions of Microsoft Excel 97 to 2007 User Level Intermediate–Advanced More great stuff… is just a click away! • Sample journals and ledgers; examples of trial balances, income statements, and balance sheets • Custom functions, such as FIFO and LIFO, for inventory management • VBA routines that automate the creation of forecasts, quality control charts, and sales and marketing analysis • Statistical process control charts: P charts, X-and-S charts, X-and-MR charts • Forecasting tools: Seasonal smoothing and ARIMA model identification quote from the front cover “Conrad takes the time to give the readers an easy-to-follow step-by-step understanding of the material, accompanied by clear illustrations, making this an excellent book to learn the material. I recommend this book to anyone wanting to gain more expertise in using and manipulating business data from within Excel.” –Bob Umlas, Excel MVP
Release

Microsoft Excel 2013 Data Analysis and Business Modeling

Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Pearson Education

ISBN: 0735681074

Category: Business & Economics

Page: 888

View: 9330

Master business modeling and analysis techniques with Microsoft Excel 2013, 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. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in
Release

Essentials of Business Analytics

Author: Jeffrey D. Camm,James J. Cochran,Michael J. Fry,Jeffrey W. Ohlmann,David R. Anderson

Publisher: Cengage Learning

ISBN: 1285964012

Category: Business & Economics

Page: 696

View: 2200

This book provides coverage over the full range of analytics--descriptive, predictive, prescriptive--not covered by any other single book. It includes step-by-step instructions to help students learn how to use Excel and powerful but easy to use Excel add-ons such as XL Miner for data mining and Analytic Solver Platform for optimization and simulation. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Management Science

Author: Cliff Ragsdale

Publisher: Cengage Learning

ISBN: 0538746319

Category: Business & Economics

Page: 792

View: 1048

Cliff Ragsdale is an innovator of the spreadsheet teaching revolution and is highly regarded in the field of management science. The sixth edition of SPREADSHEET MODELING AND DECISION ANALYSIS retains the elements and philosophy that has made its past editions so successful. This version of SPREADSHEET MODELING AND DECISION ANALYSIS has been updated for use with Microsoft Office Excel 2010. It provides succinct instruction in the most commonly used management science techniques and shows how these tools can be implemented using the most current version of Excel for Windows. This text also focuses on developing both algebraic and spreadsheet modeling skills. Risk Solver Platform replaces Crystal Ball in the sixth edition. Risk Solver Platform includes all of the capabilities of Risk Solver for risk analysis and Monte Carlo simulation, all of the capabilities of Premium solver Platform for optimization, and new capabilities for finding robust optimal decisions using simulation, optimization, stochastic programming, and robust optimization methods. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Microsoft Excel Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Microsoft Press

ISBN: 9781509304219

Category: Business & Economics

Page: 984

View: 4565

Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide will help you apply Excel 2016's most valuable innovations for data analysis and business modeling. It's packed with realistic problems and solutions to help you gain mastery -- including over 150 that are new or revised. Coverage includes: Quickly transitioning from basic Excel to more sophisticated analytics Summarizing data with PivotTables and Descriptive Statistics Exploring new trends in predictive and prescriptive analytics Using Excel Trend Curves, multiple regression, and exponential smoothing Mastering advanced Excel functions such as OFFSET and INDIRECT Delving into key financial, statistical, and time functions Making charts more effective with Power View Tame complex optimization problems with Excel Solver Running Monte Carlo simulations on stock prices and bidding models Using Excel 2016's new FORECAST and Power Map tools Working with the AGGREGATE function and Table Slicers Creating multiple PivotTables from a filter Using HYPERLINKS, ISFORMULA, and UNICODE Performing sensitivity analyses with more than two variables Making the most of the Inquire add-in And much more "
Release

Microsoft Excel 2019 Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Microsoft Press

ISBN: 9781509305889

Category:

Page: 864

View: 7215

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

Marketing Analytics

Data-Driven Techniques with Microsoft Excel

Author: Wayne L. Winston

Publisher: John Wiley & Sons

ISBN: 1118417305

Category: Computers

Page: 720

View: 5467

Helping tech-savvy marketers and data analysts solvereal-world business problems with Excel Using data-driven business analytics to understand customers andimprove results is a great idea in theory, but in today's busyoffices, marketers and analysts need simple, low-cost ways toprocess and make the most of all that data. This expert book offersthe perfect solution. Written by data analysis expert Wayne L.Winston, this practical resource shows you how to tap a simple andcost-effective tool, Microsoft Excel, to solve specific businessproblems using powerful analytic techniques—and achieveoptimum results. Practical exercises in each chapter help you apply and reinforcetechniques as you learn. Shows you how to perform sophisticated business analyses usingthe cost-effective and widely available Microsoft Excel instead ofexpensive, proprietary analytical tools Reveals how to target and retain profitable customers and avoidhigh-risk customers Helps you forecast sales and improve response rates formarketing campaigns Explores how to optimize price points for products andservices, optimize store layouts, and improve onlineadvertising Covers social media, viral marketing, and how to exploit botheffectively Improve your marketing results with Microsoft Excel and theinvaluable techniques and ideas in Marketing Analytics:Data-Driven Techniques with Microsoft Excel.
Release