xlminer analysis toolpak regression how to

I address how to install them later in the book. R and Python are both free, open source tools available for all major operating systems. As long as you have a paid version of Excel 2010 or greater for either Windows or Mac installed on your machine, you should be able to follow along with the majority of the instruction in this book, with some variations, particularly with PivotTables and data visualization. To meet the book’s objectives, I make some technical and technological assumptions: Technical RequirementsĪdvancing into Analytics was written on a Windows computer with the Office 365 version of Excel for desktop.

Few books cover this combination, even though the progression from spreadsheets into programming is common for analysts, myself included. We’ll be using Excel, R, and Python because these are powerful tools, and because they make for a seamless learning journey.

With the tools and frameworks you’ll pick up in this book, you will be well positioned to continue learning more advanced data analysis techniques. Exploring and testing relationships is core to analytics. To that end, I include a learning objective in the preface of Advancing into Analytics.īy the end of this book, you should be able to conduct exploratory data analysis and hypothesis testing using a programming language. Identify, install, and implement the most useful open source packages for your needsĪ good product expresses and delivers on a promise to its audience.Navigate and execute code in Jupyter notebooks.Perform common data wrangling tasks such as sorting, filtering, and aggregating using R and Python.Load, view, and write datasets using R and Python.Make compelling business recommendations using inferential statistics.Explore a dataset for potential research questions to check assumptions and to build hypotheses.With this practical book at your side, you’ll learn how to: This book demonstrates key statistical concepts from spreadsheets and pivots your existing knowledge about data manipulation into R and Python programming. Advancing into Analytics will lower your learning curve.Īuthor George Mount, founder and CEO of Stringfest Analytics, clearly and gently guides intermediate Excel users to a solid understanding of analytics and the data stack. Data analytics may seem daunting, but if you’re familiar with Excel, you have a head start that can help you make the leap into analytics.

Xlminer analysis toolpak regression how to