Wayne L. Winston Knihy

Helping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results. Practical exercises in each chapter help you apply and reinforce techniques as you learn. Shows you how to perform sophisticated business analyses using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools Reveals how to target and retain profitable customers and avoid high-risk customers Helps you forecast sales and improve response rates for marketing campaigns Explores how to optimize price points for products and services, optimize store layouts, and improve online advertising Covers social media, viral marketing, and how to exploit both effectively Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.

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

The author presents how to use simple mathematics to analyze statistical and probability-related questions in professional baseball, basketball, and football, and in sports gambling, how coaches and managers use mathematics to evaluate players and team performance, and in a new epilogue, how statistics and numerical analysis played roles in recent sporting events such as the Dallas Mavericks' 2011 NBA championship

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 "

Focusing on deterministic models, this book is designed for the first half of an operations research course. A subset of Winston's best-selling Operations Research, Introduction to Mathematical Programing offers self-contained chapters that make it flexible enough for one- or two-semester courses ranging from advanced beginning to intermediate in level. Appropriate for undergraduate majors, MBAs, and graduate students, it emphasizes model-formulations and model-building skills as well as interpretation of computer software output. LINDO, GINO, and LINGO software packages are available with the book in Windows, Macintosh, or DOS versions. Linear algebra prerequisite.

Easy to understand and to the point--and without any jargon--PRACTICAL MANAGEMENT SCIENCE uses an active-learning approach and realistic problems to help you understand and take advantage of the power of spreadsheet modeling. With real examples and problems drawn from finance, marketing, and operations research, you’ll easily come to see how management science applies to your chosen profession and how you can use it on the job. The authors emphasize modeling over algebraic formulations and memorization of particular models. All of these add-ins have been revised for Excel 2007. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

With its understandable explanations of Monte Carlo and step-by-step instructions for Microsoft Excel, Lotus, and @Risk software, this text/software package offers both the instruction and the practice students need to begin solving complex business problems. It is designed for use as the primary learning tool in a short business simulation course (for advanced undergraduate and MBA students), or as a supplement to courses in investments, corporate finance, management science, marketing strategy, operations management, and actuarial science.

Easy to understand and to the point--and without any jargon--Management Science Modeling uses an active-learning approach and realistic problems to help you understand and take advantage of the power of spreadsheet modeling. With real examples and problems drawn from finance, marketing, and operations research, you'll easily come to see how management science applies to your chosen profession and how you can use it on the job. The authors emphasize modeling over algebraic formulations and memorization of particular models. All of these add-ins have been revised for Excel 2007.