A Journey into Data Science Using Excel: An Applied Approach

For those people who are interested in Data Science and want to extend their knowledge within this field. Using Excel as an explanation tool, this book begins with the basics of statistics, but quickly evolves to explain more advance topics. This book covers: linear regression; R-square; MAPE; MSE; RMSE; Chi-square; correlation; t-tests; decision trees; Accuracy and F1-score; clustering; test & learn using z-score; Recency Frequency Monetary (RFM) customer segmentation, and a detailed time series chapter. The main goal of this book is to remove some of ‘black-box’ mentality that has built up in this field.

All Excel formulas are shown with detailed screenshots on how to replicate the results. There is no need to purchase any further add-ons or download any further software, as this uses the formulas that are part of Excel.