Decision Analytics

Microsoft Excel
Author: Conrad George Carlberg
Publisher: Que Publishing
ISBN: 0789751682
Category: Business & Economics
Page: 272
View: 4579

Continue Reading →

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.

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: 6729

Continue Reading →

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.

Business Analysis

Microsoft Excel 2010
Author: Conrad Carlberg
Publisher: Pearson Education
ISBN: 9780789746894
Category: Computers
Page: 528
View: 9613

Continue Reading →

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

Predictive Analytics

Microsoft Excel
Author: Conrad Carlberg
Publisher: Que Publishing
ISBN: 0132967251
Category: Business & Economics
Page: 336
View: 2085

Continue Reading →

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

Multi-criteria Decision Analysis

Methods and Software
Author: Alessio Ishizaka,Philippe Nemery
Publisher: John Wiley & Sons
ISBN: 1118644913
Category: Mathematics
Page: 312
View: 6169

Continue Reading →

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.

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: 9630

Continue Reading →

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

Decision Analytics and Optimization in Disease Prevention and Treatment


Author: Nan Kong,Shengfan Zhang
Publisher: John Wiley & Sons
ISBN: 1118960130
Category: Business & Economics
Page: 432
View: 2041

Continue Reading →

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.

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: 5711

Continue Reading →

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.

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: 9702

Continue Reading →

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.

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: 8754

Continue Reading →

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

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


Author: Cliff Ragsdale
Publisher: Cengage Learning
ISBN: 1337517313
Category: Business & Economics
Page: 864
View: 8039

Continue Reading →

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.

Predictive Analytics

Microsoft Excel
Author: Conrad George Carlberg
Publisher: Pearson Education
ISBN: 0789749416
Category: Business & Economics
Page: 290
View: 3599

Continue Reading →

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.

Business Analytics: Data Analysis & Decision Making


Author: S. Christian Albright,Wayne L. Winston
Publisher: Cengage Learning
ISBN: 1337225274
Category: Business & Economics
Page: 984
View: 1721

Continue Reading →

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.

Statistik mit Excel für Dummies


Author: Joseph Schmuller
Publisher: John Wiley & Sons
ISBN: 3527811702
Category: Computers
Page: 535
View: 1550

Continue Reading →

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.

Microsoft Excel 2019 Data Analysis and Business Modeling


Author: Wayne Winston
Publisher: Microsoft Press
ISBN: 1509306080
Category: Computers
Page: N.A
View: 5041

Continue Reading →

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. Solve real business problems with Excel—and build your competitive advantage: Quickly transition from Excel basics to sophisticated analytics Use PowerQuery or Get & Transform to connect, combine, and refine data sources Leverage Office 365’s new Geography and Stock data types and six new functions Illuminate insights from geographic and temporal data with 3D Maps Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts Use Excel trend curves, multiple regression, and exponential smoothing Delve into key financial, statistical, and time functions Master all of Excel’s great charts Quickly create forecasts from historical time-based data Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams Run Monte Carlo simulations on stock prices and bidding models Learn about basic probability and Bayes’ Theorem Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook Automate repetitive analytics tasks by using macros

Marketing Analytics

Data-Driven Techniques with Microsoft Excel
Author: Wayne L. Winston
Publisher: John Wiley & Sons
ISBN: 1118417305
Category: Computers
Page: 720
View: 8027

Continue Reading →

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.

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: 8520

Continue Reading →

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.

Microsoft Excel Data Analysis and Business Modeling


Author: Wayne Winston
Publisher: Microsoft Press
ISBN: 1509304223
Category: Computers
Page: 864
View: 6623

Continue Reading →

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

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


Author: Cliff Ragsdale
Publisher: Cengage Learning
ISBN: 0538746319
Category: Business & Economics
Page: 792
View: 5046

Continue Reading →

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.

Entdecken Sie Ihre Stärken jetzt!

Das Gallup-Prinzip für individuelle Entwicklung und erfolgreiche Führung
Author: Marcus Buckingham,Donald O. Clifton
Publisher: Campus Verlag
ISBN: 3593502526
Category: Business & Economics
Page: 288
View: 2349

Continue Reading →

Stärken der Mitarbeiter stärken, anstatt ihre Schwächen bekämpfen - das ist es, was Unternehmen erfolgreich macht. Denn wer täglich das tun darf, was er am besten kann, arbeitet am effektivsten. Damit individuelle Stärken einfach identifiziert und gefördert werden können, haben die Autoren den Strengths- Finder entwickelt. Dieser Selbsttest ermittelt die fünf größten persönlichen Stärken. In diesem Bestseller erhalten Führungskräfte und Mitarbeiter fundierte Informationen, wie diese "Top Five" im Arbeitsalltag am besten eingesetzt werden können - für mehr Zufriedenheit, Motivation und Erfolg im Job.