Read Books Online and Download eBooks, EPub, PDF, Mobi, Kindle, Text Full Free.
Download Data Analysis With Microsoft Excel 50 For Windows full books in PDF, epub, and Kindle. Read online Data Analysis With Microsoft Excel 50 For Windows ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!
Author : Kenneth N. Berk
Publisher :
ISBN 13 :
Total Pages : 464 pages
Book Rating : 4.0/5 ( download)
Download or read book Data Analysis with Microsoft Excel written by Kenneth N. Berk and published by . This book was released on 2006 with total page 464 pages. Available in PDF, EPUB and Kindle. Book excerpt:
Author : Wayne Winston
Publisher : Microsoft Press
ISBN 13 : 0137613679
Total Pages : 1788 pages
Book Rating : 4.1/5 (376 download)
Download or read book Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) written by Wayne Winston and published by Microsoft Press. This book was released on 2021-12-17 with total page 1788 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel—and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook
Author : Jinjer L. Simon
Publisher : Visual
ISBN 13 : 9780764537547
Total Pages : 308 pages
Book Rating : 4.5/5 (375 download)
Download or read book Excel Data Analysis written by Jinjer L. Simon and published by Visual. This book was released on 2003 with total page 308 pages. Available in PDF, EPUB and Kindle. Book excerpt: * Essential for those who know basic Excel and want to explore the full potential of the program * Teaches how to manipulate data to suit specific needs and achieve more by doing less work * Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility * Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver
Author : Kenneth N. Berk
Publisher : Thomson Brooks/Cole
ISBN 13 : 9781565275256
Total Pages : 360 pages
Book Rating : 4.2/5 (752 download)
Download or read book Data Analysis with Microsoft Excel 5.0 for Windows written by Kenneth N. Berk and published by Thomson Brooks/Cole. This book was released on 1995 with total page 360 pages. Available in PDF, EPUB and Kindle. Book excerpt:
Author : Conrad Carlberg
Publisher : Que Publishing
ISBN 13 : 0133823997
Total Pages : 714 pages
Book Rating : 4.1/5 (338 download)
Download or read book Statistical Analysis written by Conrad Carlberg and published by Que Publishing. This book was released on 2014-04-04 with total page 714 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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
Author : Wayne Winston
Publisher : Microsoft Press
ISBN 13 : 1509306080
Total Pages : 1488 pages
Book Rating : 4.5/5 (93 download)
Download or read book Microsoft Excel 2019 Data Analysis and Business Modeling written by Wayne Winston and published by Microsoft Press. This book was released on 2019-03-28 with total page 1488 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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
Author : Michael R. Middleton
Publisher : South Western Educational Publishing
ISBN 13 :
Total Pages : 294 pages
Book Rating : 4.3/5 (91 download)
Download or read book Data Analysis Using Microsoft Excel 5.0 written by Michael R. Middleton and published by South Western Educational Publishing. This book was released on 1995 with total page 294 pages. Available in PDF, EPUB and Kindle. Book excerpt: Microsoft Excel 5.0 is a widely used spreadsheet tool and this book is an excellent reference that shows students how to maximize the use of Excel 5.0s new data analysis functions.
Author : Paul McFedries
Publisher : John Wiley & Sons
ISBN 13 : 1119518164
Total Pages : 58 pages
Book Rating : 4.1/5 (195 download)
Download or read book Excel Data Analysis For Dummies written by Paul McFedries and published by John Wiley & Sons. This book was released on 2018-11-13 with total page 58 pages. Available in PDF, EPUB and Kindle. Book excerpt: Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key module in Microsoft Office—the number-one productivity suite—and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you’ll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If you’re familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.
Author : Bart Czernicki
Publisher : Apress
ISBN 13 : 1430230614
Total Pages : 567 pages
Book Rating : 4.4/5 (32 download)
Download or read book Silverlight 4 Business Intelligence Software written by Bart Czernicki and published by Apress. This book was released on 2011-01-27 with total page 567 pages. Available in PDF, EPUB and Kindle. Book excerpt: Business intelligence (BI) software allows you to view different components of a business using a single visual platform, which makes comprehending mountains of data easier. BI is everywhere. Applications that include reports, analytics, statistics, and historical and predictive modeling are all examples of business intelligence. Currently, we are in the second generation of business intelligence software—called BI 2.0—which is focused on writing business intelligence software that is predictive, adaptive, simple, and interactive. As computers and software have evolved, more data can be presented to end users with increasingly visually rich techniques. Rich Internet application (RIA) technologies such as Microsoft Silverlight can be used to transform traditional user-interfaces filled with boring data into fully interactive analytical applications that quickly deliver insight from large data sets. Furthermore, RIAs now include 3D spatial-design capabilities that move beyond a simple list or grid and allow for interesting layouts of aggregated data. BI 2.0 implemented via an RIA technology can truly bring out the power of business intelligence and deliver it to an average user on the Web. Silverlight 4 Business Intelligence Software provides developers, designers, and architects with a solid foundation in business intelligence design and architecture concepts for Microsoft Silverlight. This book covers key business intelligence design concepts and how they can be applied without an existing BI infrastructure. Author Bart Czernicki provides you with examples of how to build small BI applications that are interactive, highly visual, statistical, predictive—and most importantly—intuitive to the end-user. Business intelligence isn’t just for the executive branch of a Fortune 500 company—it is for the masses. Let Silverlight 4 Business Intelligence Software show you how to unlock the rich intelligence you already have.
Author : John C. Lee
Publisher : World Scientific
ISBN 13 : 9789810238797
Total Pages : 374 pages
Book Rating : 4.2/5 (387 download)
Download or read book Business and Financial Statistics Using Minitab 12 and Microsoft Excel 97 written by John C. Lee and published by World Scientific. This book was released on 2000 with total page 374 pages. Available in PDF, EPUB and Kindle. Book excerpt: The personal computer has made statistical analysis easier and cheaper. Previously, statistical analysis was difficult for many reasons. Two of the reasons were: (1) statistical analysis was slow and tedious because calculations were done by hand; (2) it was costly because it was done on mainframes and mainframe time was expensive. This book discusses statistical analysis using two personal computer software packages, Minitab 12 and Microsoft Excel 97, Minitab was chosen because it is powerful and is one of the more user-friendly statistical software packages. Microsoft Excel 97 was selected because it is one of the most important software packages to learn and most companies use Microsoft Excel. Excel is a software package that is not dedicated to statistical analysis like Minitab, but it has many statistical features and a very powerful development environment for writing customized statistical analysis. The book is organized in a textbook format. Each chapter discusses statistical conceptsand illustrates the use of Minitab and/or Excel. Often it becomes necessary to write macros (programs) in order to do specific statistical analysis. This books prints the codes of the macros for the reader to use and study. This is valuable because usually the difficult part is how to write the code. What the reader will find after studying this book is that statistical analysis will become more fun because he will have more time doing statistical analysis and make less statistical calculations.
Author : Wayne Winston
Publisher : Pearson Education
ISBN 13 : 0735681074
Total Pages : 1167 pages
Book Rating : 4.7/5 (356 download)
Download or read book Microsoft Excel 2013 Data Analysis and Business Modeling written by Wayne Winston and published by Pearson Education. This book was released on 2014-01-15 with total page 1167 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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
Author : Brian D. Bissett
Publisher : CRC Press
ISBN 13 : 1584888865
Total Pages : 478 pages
Book Rating : 4.5/5 (848 download)
Download or read book Automated Data Analysis Using Excel written by Brian D. Bissett and published by CRC Press. This book was released on 2007-06-15 with total page 478 pages. Available in PDF, EPUB and Kindle. Book excerpt: Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to m
Author : Eben Weitzman
Publisher : SAGE Publications
ISBN 13 : 1452246777
Total Pages : 383 pages
Book Rating : 4.4/5 (522 download)
Download or read book Computer Programs for Qualitative Data Analysis written by Eben Weitzman and published by SAGE Publications. This book was released on 1995-02-02 with total page 383 pages. Available in PDF, EPUB and Kindle. Book excerpt: For those interested in finding a computer application well-suited for their own qualitative research or just learning more about the capabilities of the latest generation of computer software designed with text, Computer Programs for Qualitative Data Analysis by Eben A. Weitzman and Matthew B. Miles probably represents the single investment they can make. . . . In Computer Programs for Qualitative Data Analysis, Weitzman and Miles . . . provide a critical, in-depth look at 24 separate applications. The authors make an impressive team: Weitzman is a professor of social and organizational psychology with an extensive computer background, and Miles is a social psychologist who is well-known in the field of qualitative research for co-authoring a popular book on qualitative data analysis with A. Michael Huberman. Together, the two researchers have produced an informative, user-friendly sourcebook that can save readers a significant amount of time and money when shopping for a software program for qualitative data analysis. Weitzman and Miles clearly put a tremendous amount of work into Computer Programs for Qualitative Data Analysis; they write their reviews of each application in remarkably lucid and jargon-free language in a format reminiscent of Consumer Reports. The level of detail in the reviews reflects their careful and thoughtful field-testing of 24 software programs. Reviews average about 10 pages each and actually show you what each application can do, and every review includes a series of realistic visuals (complete with helpful captions) that display what the computer screen looks like when performing various functions with that specific computer program. In addition to describing the special features of each computer program, Weitzman and Miles discuss the strengths and weaknesses of every application and make explicit comparisons with other applications in the same ′family.′ "Sage Publications deserves special credit for their role in publishing Computer Programs for Qualitative Data Analysis. Instead of issuing this book in hardcover and attaching a hefty price tag, they released it as an oversized (81/2-by-11-inch) paperback and made this valuable information available at a modest cost. Computer Programs for Qualitative Data Analysis is the most comprehensive resource on its subject currently available, and is an excellent starting point for qualitative researchers interested in integrating computer technology more fully into their own data analysis strategies." --Harvard Educational Review "The book by Weitzman & Miles is one of many new books on computers and qualitative software and indeed a good one. . . . The book is truly a user′s book--one of the useful ones. . . . After this first feeling of self-confidence, I just kept on reading the book and found very thorough and illuminative reviews of no less that 24 computer programs for qualitative analysis. . . . Renata Tesch initiated the work of making it easier for us to survey the qualitative analysis methods--Weitzman & Miles carry on in the finest way." --Nyhedsbrer "Although the authors have a background in social and organizational psychology, their expertise on qualitative research methods is relevant to gerontologists. . . . The authors give a history of the use of computers in qualitative data analysis, describe the different types of programs, and suggest future directions, but the bulk of this book is reviews of the software out there. . . . Before you spend several hundred dollars on a software program, spend thirty and get this book." --T. L. Brink in Clinical Gerontologist "Eben A. Weitzman and Matthew B. Miles′s valuable sourcebook on computer programs is designed exclusively for those interested in qualitative data analysis. . . . For qualitative researchers who want to learn or update their knowledge of the use of computer software." --Choice "What program do I use to analyze my field notes? Eben A. Weitzman and Matthew B. Miles provide the information you need to make that decision intelligently: full descriptions, informed judgments, and helpful comparisons. Anyone who does fieldwork needs this book." --Howard Becker, Department of Sociology, University of Washington, Seattle "This will be the standard work of reference for several years to come. We owe the authors a considerable debt of gratitude for all the work they have put into reviewing such a comprehensive range of software. The result is incredibly lucid." --Paul Atkinson, University of Wales, Cardiff "The book is absolutely perfect for my situation. I don′t know how many readers will be in the position of purchasing software for respective labs, but those who are will be in for a real treat. The comprehensiveness of the reviews is more than adequate to determine whether a particular program meets the needs of an individual or group. . . . It is the most comprehensive book of its kind, for any kind of software, that I have ever seen." --Steven E. Wolfel, Research Publishing Consultant "Making decisions about choosing software for qualitative data analysis can be intimidating and I think this book will be an excellent resource for those of us who are involved in this type of research. I found this to be an extremely well-thought-out and informative resource book. The detail is wonderful." --Kathleen R. Gilbert, Indiana University, Bloomington Do you want to start, extend, or update your use of computer software for qualitative data analysis? If so, this clear and user-friendly guidebook is for you. Without assuming its reader has extensive computer experience, Computer Programs for Qualitative Data Analysis takes a critical yet practical look at the wide range of software currently available. It gives detailed reviews of 24 programs in five major categories (text retrievers, textbase managers, code-and-retrieve programs, code-based theory-builders, and conceptual network-builders) and gives ratings of more than 75 features per program. The authors also provide detailed guidance in operating each program. They help you to ask key questions about your computer use--the nature of your project, time line, analyses planned, and the worksheets required--to help you identify the programs best suited to your needs. Up-to-date and practical, Computer Programs for Qualitative Data Analysis is an absolute must-have book for any qualitative researcher who uses--or wants to use--computer programs in analyses.
Author : Christian N. Madu
Publisher : Chi Publishers Inc
ISBN 13 : 9780967602325
Total Pages : 182 pages
Book Rating : 4.6/5 (23 download)
Download or read book Statistics as Easy as 1, 2, 3 with Microsoft Excel for Windows written by Christian N. Madu and published by Chi Publishers Inc. This book was released on 2003 with total page 182 pages. Available in PDF, EPUB and Kindle. Book excerpt: This title has been written as a basic statistical applications book for non-statistics majors. It focuses on the use of Microsoft Excel Add-Ins function in analyzing basic statistical problems. It is intended for beginners, and it introduces statistical concepts in ways that may be relevant to practitioners. The data used throughout the book is based on responses to common social issues. This way, the book can be relevant to multiple users with different backgrounds. The topics covered include: questionnaire design, descriptive statistics; hypothesis testing; confidence interval estimation; nonparametric statistics; and simple and multiple regression analysis. of statistics. Students majoring in business, health sciences, and social sciences are also likely to find the book useful in understanding statistical concepts. Practitioners who may be interested in exploring the power of Microsoft Excel for statistical analysis should also find the book very useful.
Author : Bill Jelen
Publisher : Pearson Education
ISBN 13 : 0789746689
Total Pages : 579 pages
Book Rating : 4.7/5 (897 download)
Download or read book Pivot Table Data Crunching written by Bill Jelen and published by Pearson Education. This book was released on 2010-10-20 with total page 579 pages. Available in PDF, EPUB and Kindle. Book excerpt: PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
Author : John W. Foreman
Publisher : John Wiley & Sons
ISBN 13 : 1118839862
Total Pages : 432 pages
Book Rating : 4.1/5 (188 download)
Download or read book Data Smart written by John W. Foreman and published by John Wiley & Sons. This book was released on 2013-10-31 with total page 432 pages. Available in PDF, EPUB and Kindle. Book excerpt: Data Science gets thrown around in the press like it'smagic. Major retailers are predicting everything from when theircustomers are pregnant to when they want a new pair of ChuckTaylors. It's a brave new world where seemingly meaningless datacan be transformed into valuable insight to drive smart businessdecisions. But how does one exactly do data science? Do you have to hireone of these priests of the dark arts, the "data scientist," toextract this gold from your data? Nope. Data science is little more than using straight-forward steps toprocess raw data into actionable insight. And in DataSmart, author and data scientist John Foreman will show you howthat's done within the familiar environment of aspreadsheet. Why a spreadsheet? It's comfortable! You get to look at the dataevery step of the way, building confidence as you learn the tricksof the trade. Plus, spreadsheets are a vendor-neutral place tolearn data science without the hype. But don't let the Excel sheets fool you. This is a book forthose serious about learning the analytic techniques, the math andthe magic, behind big data. Each chapter will cover a different technique in aspreadsheet so you can follow along: Mathematical optimization, including non-linear programming andgenetic algorithms Clustering via k-means, spherical k-means, and graphmodularity Data mining in graphs, such as outlier detection Supervised AI through logistic regression, ensemble models, andbag-of-words models Forecasting, seasonal adjustments, and prediction intervalsthrough monte carlo simulation Moving from spreadsheets into the R programming language You get your hands dirty as you work alongside John through eachtechnique. But never fear, the topics are readily applicable andthe author laces humor throughout. You'll even learnwhat a dead squirrel has to do with optimization modeling, whichyou no doubt are dying to know.
Author : Conrad Carlberg
Publisher : Que Publishing
ISBN 13 : 0132967251
Total Pages : 302 pages
Book Rating : 4.1/5 (329 download)
Download or read book Predictive Analytics written by Conrad Carlberg and published by Que Publishing. This book was released on 2012-07-02 with total page 302 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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
