What do you think?
Rate this book
Simple Predictive Analytics: Using Excel to Solve Business Problems
This book will give you the critical information you need to create, use, and validate simple predictive models , and it will suggest the types of real-world business problems you can solve with those models.
It is designed to be as simple as possible, providing basic, practical, and immediately applicable information for business users new to the world of predictive modeling.
In
Our approach is as
First , introduce analysis fundamentals. These are the basics of doing good and accurate analysis, and it will be important to keep these principles in mind as you create predictive models.
Second , explain the process that will allow you to follow some easy, predefined steps to creating your own predictive models. This is a “big-picture” process flow meant to give you a basic procedure to follow no matter what type of predictive model you need to create.
Last , this guide gives you an in-depth look into various predictive modeling techniques, organized according to the type of data you have and the type of questions you’re trying to answer. This section makes up the bulk of the book, and the explanation of each model tells you what the predictive model looks like, what it can be used for, the assumptions necessary to use the model, a process to follow to create it (including step-by-step instructions in Excel), an explanation of some common errors to watch for, and a section on analyzing your results.
The modeling process you will learn is as
1. Choose a predictive model according to the business question. 2. Check to see if all the conditions for the model are met. 3. Carry out the analysis. 4. Check for statistical significance and fit. 5. Validate the predictive model. 6. Refine the predictive model.
The basic models we go over in this
These models cover four common prediction cases you will
What you will not get in this
What you will get in this
Also, this book may or may not mention wombats.
It is designed to be as simple as possible, providing basic, practical, and immediately applicable information for business users new to the world of predictive modeling.
In
Our approach is as
First , introduce analysis fundamentals. These are the basics of doing good and accurate analysis, and it will be important to keep these principles in mind as you create predictive models.
Second , explain the process that will allow you to follow some easy, predefined steps to creating your own predictive models. This is a “big-picture” process flow meant to give you a basic procedure to follow no matter what type of predictive model you need to create.
Last , this guide gives you an in-depth look into various predictive modeling techniques, organized according to the type of data you have and the type of questions you’re trying to answer. This section makes up the bulk of the book, and the explanation of each model tells you what the predictive model looks like, what it can be used for, the assumptions necessary to use the model, a process to follow to create it (including step-by-step instructions in Excel), an explanation of some common errors to watch for, and a section on analyzing your results.
The modeling process you will learn is as
1. Choose a predictive model according to the business question. 2. Check to see if all the conditions for the model are met. 3. Carry out the analysis. 4. Check for statistical significance and fit. 5. Validate the predictive model. 6. Refine the predictive model.
The basic models we go over in this
These models cover four common prediction cases you will
What you will not get in this
What you will get in this
Also, this book may or may not mention wombats.
89 pages, Paperback
Published January 26, 2019
49 people are currently reading
8 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
January 2, 2020
Excellent and straight forward
This was an excellent brief summary and to-the-point walk through of what can be a complicated subject for many. I liked that he used Excel as it is almost universally available and can be used to perform each statistical test without needing any special addin modules, costly licenses, or programming. The book lists out for each test the conditions required, things to look out for in each type of analysis, and screenshots which were very clear and helpful. This is definitely one of the better books on explaining it very down to earth and not too theoretical. I would have liked a few more things covered like poisson regression or the explanation of some of the additional tests for the nonparametric sections, but overall it kept it simple and straight forward for the reader to explore and grasp how to get each one done.
This was an excellent brief summary and to-the-point walk through of what can be a complicated subject for many. I liked that he used Excel as it is almost universally available and can be used to perform each statistical test without needing any special addin modules, costly licenses, or programming. The book lists out for each test the conditions required, things to look out for in each type of analysis, and screenshots which were very clear and helpful. This is definitely one of the better books on explaining it very down to earth and not too theoretical. I would have liked a few more things covered like poisson regression or the explanation of some of the additional tests for the nonparametric sections, but overall it kept it simple and straight forward for the reader to explore and grasp how to get each one done.
May 3, 2020
This is a good reference book on statistical concepts and applying those concepts using Excel.
Displaying 1 - 2 of 2 reviews