{"title":"Conrad Carlberg","description":"","products":[{"product_id":"predictive-analytics-book-conrad-carlberg-9780789749413","title":"Predictive Analytics","description":"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","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49512253751569,"sku":"GOR005958829","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":49629489332497,"sku":"GOR012274659","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49663991218449,"sku":"GOR008607394","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50091757895953,"sku":"CIN0789749416G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51422696145169,"sku":"CIN0789749416VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789749416.jpg?v=1751444676"},{"product_id":"excel-sales-forecasting-for-dummies-book-conrad-carlberg-9780764575938","title":"Excel Sales Forecasting For Dummies","description":"Shows you how to use Microsoft Excel to predict trends and future sales based on something not quite so ethereal-numbers. This title helps to: select and use the right forecasting method for your business; choose and arrange data in lists, then manage that data with pivot tables; and, find relationships in your data.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49536974422289,"sku":"GOR001675037","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":49888803324177,"sku":"CIN0764575937A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50042601373969,"sku":"CIN0764575937G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ WELL_READ \/ INTERNAL","offer_id":51359128551697,"sku":"GOR007569127","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":51547639841041,"sku":"GOR006043915","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51565860323601,"sku":"CIN0764575937VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":51592480030993,"sku":"GOR012983741","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0764575937.jpg?v=1751440962"},{"product_id":"managing-data-with-excel-book-conrad-carlberg-9780789731005","title":"Managing Data with Excel","description":"Get key data management information in the ONLY book that focuses on efficient and effective data management.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49549539639569,"sku":"GOR001558358","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50365516185873,"sku":"CIN0789731002G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789731002.jpg?v=1751139255"},{"product_id":"business-analysis-book-conrad-carlberg-9780789743176","title":"Business Analysis","description":"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","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49560852627729,"sku":"GOR005148018","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49675976474897,"sku":"CIN0789743175G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50365674914065,"sku":"CIN0789743175A","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789743175.jpg?v=1750979421"},{"product_id":"decision-analytics-book-conrad-carlberg-9780789751683","title":"Decision Analytics","description":"Crunch Big Data to optimize marketing and more!         Overwhelmed by all the Big Data now available to you? Not sure what questions to ask or how to ask them? Using Microsoft Excel and proven decision analytics techniques, you can distill all that data into manageable sets—and use them to optimize a wide variety of business and investment decisions. In Decision Analytics: Microsoft Excel, best selling statistics expert and consultant Conrad Carlberg will show you how—hands-on and step-by-step.       Carlberg guides you through using decision analytics to segment customers (or anything else) into sensible and actionable groups and clusters. Next, you’ll learn practical ways to optimize a wide spectrum of decisions in business and beyond—from pricing to cross-selling, hiring to investments—even facial recognition software uses the techniques discussed in this book!       Through realistic examples, Carlberg helps you understand the techniques and assumptions that underlie decision analytics and use simple Excel charts to intuitively grasp the results. With this foundation in place, you can perform your own analyses in Excel and work with results produced by advanced stats packages such as SAS and SPSS.       This book comes with an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code to streamline several of its most complex techniques.      Classify data according to existing categories or naturally occurring clusters of predictor variables   Cut massive numbers of variables and records down to size, so you can get the answers you really need   Utilize cluster analysis to find patterns of similarity for market research and many other applications   Learn how multiple discriminant analysis helps you classify cases   Use MANOVA to decide whether groups differ on multivariate centroids   Use principal components to explore data, find patterns, and identify latent factors   Register your book for access to all sample workbooks, updates, and corrections as they become available at quepublishing.com\/title\/9780789751683.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49579040112913,"sku":"GOR012714827","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51423336431889,"sku":"CIN0789751682VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":51695174549777,"sku":"CIN0789751682G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789751682.jpg?v=1751076013"},{"product_id":"business-analysis-with-microsoft-excel-book-conrad-carlberg-9780789736642","title":"Business Analysis with Microsoft Excel","description":"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","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49580738052369,"sku":"GOR002328131","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49994399252753,"sku":"CIN0789736640G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51091875004689,"sku":"CIN0789736640VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53135579185425,"sku":"GOR012620428","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789736640.jpg?v=1750703514"},{"product_id":"statistical-analysis-book-conrad-carlberg-9780789747204","title":"Statistical Analysis","description":"Statistical Analysis: Microsoft Excel 2010     “Excel has become the standard platform for quantitative analysis. Carlberg has become a world-class guide for Excel users wanting to do quantitative analysis. The combination makes Statistical Analysis: Microsoft Excel 2010 a must-have addition to the library of those who want to get the job done and done right.”    —Gene V Glass, Regents’ Professor Emeritus, Arizona State University     Use Excel 2010’s statistical tools to transform your data into knowledge     Use Excel 2010’s powerful statistical tools to gain a deeper understanding of your data,  make more accurate and reliable inferences, and solve problems in fields ranging from business to health sciences.     Top Excel guru Conrad Carlberg shows how to use Excel 2010 to perform the core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including its new consistency functions. Along the way, you discover the most effective ways to use correlation and regression and analysis of variance and covariance. You see how to use Excel to test statistical hypotheses using the normal, binomial, t and F distributions.     Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by an extensive set of web-based resources.    •  Master Excel’s most useful descriptive and inferential statistical tools    •  Tell the truth with statistics, and recognize when others don’t    •  Accurately summarize sets of values    •  View how values cluster and disperse    •  Infer a population’s characteristics from a sample’s frequency distribution    •  Explore correlation and regression to learn how variables move in tandem    •  Understand Excel’s new consistency functions    •  Test differences between two means using z tests, t tests, and Excel’s  Data Analysis Add-in    •  Use ANOVA and ANCOVA to test differences between more than two means    •  Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha     There is an Excel workbook for each chapter, and each worksheet is keyed to one of the book's figures. You'll also find additional material, such as a chart that demonstrates how statistical power shifts as you manipulate sample size, mean differences, alpha and directionality. To access these free files, please visit http:\/\/www.quepublishing.com\/title\/0789747200 and click the Downloads Tab.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49594095337745,"sku":"GOR006512839","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49634221818129,"sku":"GOR011634337","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49957198758161,"sku":"CIN0789747200G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50406353764625,"sku":"CIN0789747200VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ WELL_READ \/ SBYB","offer_id":51327045107985,"sku":"CIN0789747200A","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789747200.jpg?v=1750785971"},{"product_id":"more-predictive-analytics-book-conrad-carlberg-9780789756145","title":"More Predictive Analytics","description":"Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers  In More Predictive Analytics, Microsoft Excel(r) 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","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49641542811921,"sku":"GOR013322182","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":49778155061521,"sku":"CIN0789756145G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51734514237713,"sku":"CIN0789756145VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789756145.jpg?v=1750703525"},{"product_id":"excel-sales-forecasting-for-dummies-book-conrad-carlberg-9781119291428","title":"Excel Sales Forecasting For Dummies","description":"Excel at predicting sales and forecasting trends using Microsoft Excel!    If you're a sales or marketing professional, you know that forecasting sales is one of the biggest challenges you face on the job.","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49732208656657,"sku":"NGR9781119291428","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50172042314001,"sku":"GOR009780675","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":50432670630161,"sku":"GOR013949004","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51019601707281,"sku":"NIN9781119291428","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52474739261713,"sku":"NLS9781119291428","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":53188450353425,"sku":"CIN1119291429VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1119291429.jpg?v=1750791040"},{"product_id":"business-analysis-with-microsoft-excel-book-conrad-carlberg-9780789759580","title":"Business Analysis with Microsoft Excel","description":"Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits       It’s time to put the full power of Excel quantitative analysis behind your management decisions!       Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Carlberg helps you make the most of Excel’s tools and features in everything from business case development to cash flow analysis.       Becoming an Excel expert has never been easier. You’ll find crystal-clear instructions, real-world examples, insider insights, step-by-step projects, and much more. It’s all complemented by extensive web-based resources, from sample journals and ledgers to business forecasting tools.       ·         Get more insight from income statements and balance sheets   ·         Manage current assets and value inventories   ·         Summarize transactions from journal to balance sheet   ·         Analyze working capital, cash flow, statements, and ratios   ·         Optimize budgeting and planning cycles   ·         Make more accurate and useful forecasts and projections   ·         Measure product or service quality   ·         Plan investments, set decision criteria, and perform sensitivity analyses   ·         Analyze profits, pricing, costs, contributions, and margins   ·         Make better decisions in uncertain conditions   ·         Understand and maximize the value of fixed assets   ·         Efficiently import and export business data      ·         Use Excel and Power BI to analyze data from QuickBooks or other sources","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49732234051857,"sku":"NGR9780789759580","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50366084710673,"sku":"CIN0789759586G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51423306055953,"sku":"CIN0789759586VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":53534346084625,"sku":"NIN9780789759580","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789759586.jpg?v=1769682571"},{"product_id":"bayesian-analysis-with-excel-and-r-book-conrad-carlberg-9780137580989","title":"Bayesian Analysis with Excel and R","description":"Leverage the full power of Bayesian analysis for competitive advantage   Bayesian methods can solve problems you can't reliably handle any other way. Building on your existing Excel analytics skills and experience, Microsoft Excel MVP Conrad Carlberg helps you make the most of Excel's Bayesian capabilities and move toward R to do even more.   Step by step, with real-world examples, Carlberg shows you how to use Bayesian analytics to solve a wide array of real problems. Carlberg clarifies terminology that often bewilders analysts, and offers sample R code to take advantage of the rethinking package in R and its gateway to Stan.   As you incorporate these Bayesian approaches into your analytical toolbox, you'll build a powerful competitive advantage for your organization—and yourself.     Explore key ideas and strategies that underlie Bayesian analysis Distinguish prior, likelihood, and posterior distributions, and compare algorithms for driving sampling inputs Use grid approximation to solve simple univariate problems, and understand its limits as parameters increase Perform complex simulations and regressions with quadratic approximation and Richard McElreath's quap function Manage text values as if they were numeric Learn today's gold-standard Bayesian sampling technique: Markov Chain Monte Carlo (MCMC) Use MCMC to optimize execution speed in high-complexity problems Discover when frequentist methods fail and Bayesian methods are essential—and when to use both in tandem","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49741394313489,"sku":"NGR9780137580989","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":50999374577937,"sku":"NIN9780137580989","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0137580983.jpg?v=1781085198"},{"product_id":"statistical-analysis-book-conrad-carlberg-9780789759054","title":"Statistical Analysis","description":"USE EXCEL’S STATISTICAL TOOLS TO TRANSFORM YOUR DATA INTO KNOWLEDGE           Nationally recognized Excel expert Conrad Carlberg shows you how to use Excel 2016 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples and downloadable workbooks, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes.       You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, Carlberg offers insightful coverage of crucial topics ranging from experimental design to the statistical power of F tests. Updated for Excel 2016, this guide covers both modern consistency functions and legacy compatibility functions.       Becoming an expert with Excel statistics has never been easier! In this book, you’ll find crystal-clear instructions, insider insights, and complete step-by-step guidance.                  Master Excel’s most useful descriptive and inferential statistical tools             Understand how values cluster together or disperse, and how variables move or classify jointly             Tell the truth with statistics—and recognize when others don’t             Infer a population’s characteristics from a sample’s frequency distribution             Explore correlation and regression to learn how variables move in tandem             Use Excel consistency functions such as STDEV.S( ) and STDEV.P( )             Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in             Identify skewed distributions using Excel’s new built-in box-and-whisker plots and histograms             Evaluate statistical power and control risk             Explore how randomized block and split plot designs alter the derivation of F-ratios             Use coded multiple regression analysis to perform ANOVA with unbalanced factorial designs             Analyze covariance with ANCOVA, and properly use multiple covariance             Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2016 shortcuts","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49798365937937,"sku":"CIN0789759055G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50662819037457,"sku":"GOR014028712","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51414414819601,"sku":"CIN0789759055VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789759055.jpg?v=1751395025"},{"product_id":"statistical-analysis-book-conrad-carlberg-9780789753113","title":"Statistical Analysis","description":"Use Excel 2013’s statistical tools to transform your data into knowledge      Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes.    You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests.        Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources.      Master Excel’s most useful descriptive and inferential statistical tools   Tell the truth with statistics—and recognize when others don’t   Accurately summarize sets of values   Infer a population’s characteristics from a sample’s frequency distribution   Explore correlation and regression to learn how variables move in tandem   Use Excel consistency functions such as STDEV.S() and STDEV.P()   Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in   Use ANOVA to test differences between more than two means   Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha   Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50006475931921,"sku":"GOR008646996","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50365924507921,"sku":"CIN0789753111G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50591079923985,"sku":"CIN0789753111VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789753111.jpg?v=1751427452"},{"product_id":"r-for-microsoft-excel-users-book-conrad-carlberg-9780789757852","title":"R for Microsoft Excel Users","description":"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","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50366055219473,"sku":"CIN0789757850G","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789757850.jpg?v=1751395023"},{"product_id":"predictive-analytics-book-conrad-carlberg-9780789758354","title":"Predictive Analytics","description":"EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS!    Now, you can apply cutting-edge predictive analytics techniques to help your business win–and you don’t need multimillion-dollar software to do it. All the tools you need are available in Microsoft Excel 2016, 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 problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, helping you gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS.       Fully updated for Excel 2016, this guide contains valuable new coverage of accounting for seasonality and managing complex consumer choice scenarios. Throughout, Carlberg provides downloadable Excel 2016 workbooks you can easily adapt to your own needs, plus VBA code–much of it open-source–to streamline especially 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 the “how” and “why” of using data to make better decisions, and choose the right technique for each problem                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           Account for trends and seasonality via Holt-Winters smoothing           Prevent trends from running out of control over long time horizons           Construct more accurate predictions by using Solver           Manage large numbers of variables and unwieldy datasets with principal components analysis and Varimax factor rotation           Apply ARIMA (Box-Jenkins) techniques to build better forecasts and clarify their meaning           Handle complex consumer choice problems with advanced logistic regression           Benchmark Excel results against R results","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":50480207429905,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50480207692049,"sku":"CIN0789758350G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":52506627506449,"sku":"CIN0789758350VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":53334895821073,"sku":"GOR008835536","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789758350.jpg?v=1751010509"},{"product_id":"regression-analysis-microsoft-excel-book-conrad-carlberg-9780789756558","title":"Regression Analysis Microsoft Excel","description":"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","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51191441850641,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51191443095825,"sku":"CIN0789756552VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":53133087179025,"sku":"NIN9780789756558","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789756552.jpg?v=1779962480"}],"url":"https:\/\/www.worldofbooks.com\/en-gb\/collections\/author-books-by-conrad-carlberg.oembed","provider":"World of Books ","version":"1.0","type":"link"}