{"product_id":"simple-predictive-analytics-using-excel-to-solve-business-problems-paperback","title":"Simple Predictive Analytics: Using Excel to Solve Business Problems - Paperback","description":"\u003cp\u003eby \u003cb\u003eCurtis Seare\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThis book will give you the critical information you need to create, use, and validate simple predictive models\u003c\/strong\u003e, and it will suggest the types of real-world business problems you can solve with those models.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eIt 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.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIn summary: \u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\u003cp\u003eAn introduction to and some fundamentals for good analysis\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eA process outline to make analysis quick and effective\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eA description of some of the most used predictive models and methods, and how they relate to business questions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eComprehensive \"How To\" sections, including step-by-step Excel tutorials and common pitfalls to avoid\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eOur approach is as follows: \u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eFirst\u003c\/strong\u003e, 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.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eSecond\u003c\/strong\u003e, 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.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eLast\u003c\/strong\u003e, 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.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe modeling process you will learn is as follows: \u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e1. Choose a predictive model according to the business question.\u003c\/p\u003e\u003cp\u003e2. Check to see if all the conditions for the model are met.\u003c\/p\u003e\u003cp\u003e3. Carry out the analysis.\u003c\/p\u003e\u003cp\u003e4. Check for statistical significance and fit.\u003c\/p\u003e\u003cp\u003e5. Validate the predictive model.\u003c\/p\u003e\u003cp\u003e6. Refine the predictive model.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe basic models we go over in this text: \u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\u003cp\u003eGeneral Regression (linear, multivariate, exponential, logarithmic, polynomial, time series)\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLogistic Regression\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eANOVA (t-test, one and two-way ANOVA)\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eChi-Square\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThese models cover four common prediction cases you will encounter: \u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\u003cp\u003ePredict a numerical outcome with numerical explanatory variables\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003ePredict a yes or no outcome with numerical explanatory variables\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003ePredict a numerical outcome with categorical explanatory variables\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003ePredict a categorical outcome with categorical explanatory variables\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003e\u003cbr\u003e\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you will not get in this book: \u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\u003cp\u003eComplex statistical explanations\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eComplex math\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eComplex predictive models (read: machine learning is not covered)\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003ePython, R, or other coding languages used for modeling\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003e\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you will get in this book: \u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\u003cp\u003eSimple statistics\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eSimple math\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eSimple predictive models\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eModeling procedures using Excel\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eSuggestions on how to apply these to real business situations\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eAlso, this book may or may not mention wombats.\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 90\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.19 x 11.02 x 8.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e January 26, 2019\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42713021841471,"sku":"9781795224734","price":8.08,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/759e7a47a8063d24a1a978ed298b77e1.webp?v=1765063180","url":"https:\/\/dhl-adrianne.myshopify.com\/products\/simple-predictive-analytics-using-excel-to-solve-business-problems-paperback","provider":"BBB","version":"1.0","type":"link"}