Decision Analytics

Microsoft Excel

Author: Conrad George Carlberg

Publisher: Que Publishing

ISBN: 0789751682

Category: Business & Economics

Page: 272

View: 765

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

Business Analysis

Microsoft Excel 2010

Author: Conrad Carlberg

Publisher: Pearson Education

ISBN: 9780789746894

Category: Computers

Page: 528

View: 4868

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

Data Analysis and Decision Making

Author: S. Albright,Wayne Winston,Christopher Zappe

Publisher: Cengage Learning

ISBN: 0538476125

Category: Business & Economics

Page: 1080

View: 4707

DATA ANALYSIS AND DECISION MAKING emphasizes data analysis, modeling, and spreadsheet use in statistics and management science. This text became a market leader in its first edition for its clarity of writing and teach-by-example approach, and it continues that tradition in this edition. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Release

Predictive Analytics

Microsoft Excel

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 0132967251

Category: Business & Economics

Page: 336

View: 8333

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

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

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

Multi-criteria Decision Analysis

Methods and Software

Author: Alessio Ishizaka,Philippe Nemery

Publisher: John Wiley & Sons

ISBN: 1118644913

Category: Mathematics

Page: 312

View: 4601

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

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

Author: Cliff Ragsdale

Publisher: Cengage Learning

ISBN: 130594741X

Category: Business & Economics

Page: 864

View: 8468

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

Statistik mit Excel für Dummies

Author: Joseph Schmuller

Publisher: John Wiley & Sons

ISBN: 3527811702

Category: Computers

Page: 535

View: 4515

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

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

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

Statistical Analysis with R and Microsoft Excel

Author: Conrad Carlberg

Publisher: Que

ISBN: 9780789757852

Category: Computers

Page: 272

View: 4205

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

Business Analytics: Data Analysis & Decision Making

Author: S. Christian Albright,Wayne L. Winston

Publisher: Cengage Learning

ISBN: 1337225274

Category: Business & Economics

Page: 984

View: 5353

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

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

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

Marketing Analytics

Data-Driven Techniques with Microsoft Excel

Author: Wayne L. Winston

Publisher: John Wiley & Sons

ISBN: 1118417305

Category: Computers

Page: 720

View: 8017

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

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

Author: Cliff Ragsdale

Publisher: Cengage Learning

ISBN: 0538746319

Category: Business & Economics

Page: 792

View: 3997

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 2016 (Microsoft Press)

Einfache Anleitungen für wichtige Aufgaben

Author: Curtis Frye

Publisher: N.A

ISBN: 3864918650

Category: Computers

Page: 474

View: 9717

Verstehen einfach gemacht! Steigern Sie Ihre Produktivität mit Excel 2016 und lernen Sie genau das, was Sie gerade im Moment benötigen. Die übersichtliche Struktur lässt Sie Lösungen sofort finden. Klare Anweisungen und viele farbige Bildschirmabbildungen zeigen Ihnen genau, wie's geht - Schritt für Schritt. • Organisieren Sie Ihre Arbeitsmappen, geben Sie schneller Daten ein und formatieren Sie sie übersichtlich. • Führen Sie Berechnungen durch und finden und korrigieren Sie Fehler. • Filtern, sortieren und kombinieren Sie Ihre Daten effizient. • Analysieren Sie Daten mit PivotTables, PivotCharts, Szenarien, Datentabellen und dem Solver. • Visualisieren Sie Daten mit Diagrammen inklusive der neuen Sunburst-, Wasserfall und Treemaps-Diagramme. • Erstellen Sie Datenmodelle und verwenden Sie sie in Business-Intelligence-Analysen. • Arbeiten Sie mit Zeitachsen, Prognosen und Visualisierungen einschließlich KPIs und PowerMap-Datenkarten. Übungsdateien zu diesem Buch finden Sie unter: http://www.dpunkt.de/excel-2016-SFS
Release

More Predictive Analytics

Microsoft Excel

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 0134070933

Category: Computers

Page: 336

View: 8779

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

Regression Analysis Microsoft Excel

Author: Conrad Carlberg

Publisher: Que Publishing

ISBN: 013439352X

Category: Business & Economics

Page: 368

View: 3122

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

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

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

Operations Research

Einführung

Author: Frederick S. Hillier,Gerald J. Liebermann

Publisher: Walter de Gruyter GmbH & Co KG

ISBN: 3486792083

Category: Business & Economics

Page: 868

View: 8564

Aus dem Inhalt: Was ist Operations Research? Überblick über die Modellierungsgrundsätze des Operations Research. Einführung in die lineare Programmierung. Die Lösung linearer Programmierungsprobleme: Das Simplexverfahren. Stochastische Prozesse. Warteschlangentheorie. Lagerhaltungstheorie. Prognoseverfahren. Markov-Entscheidungsprozesse. Reliabilität. Entscheidungstheorie. Die Theorie des Simplexverfahrens Qualitätstheorie und Sensitivitätsanalyse Spezialfälle linearer Programmierungsprobleme. Die Formulierung linearer Programmierungsmodelle und Goal-Programmierung. Weitere Algorithmen der linearen Programmierung. Netzwerkanalyse einschließlich PERT-CPM. Dynamische Optimierung. Spieltheorie. Ganzzahlige Programmierung. Nichtlineare Programmierung Simulation. Anhang. Lösungen für ausgewählte Übungsaufgaben.
Release