With the subtitle "Using Data Science to Transform Information into Insight", this book is a field guide to building statistics, machine learning, and powerful artificial intelligence concepts inside the spreadsheet. In this updated edition, author Jordan Goldmeier shows how to implement data science problems using Excel while exposing how things work behind the scenes.
Author: Jordan Goldmeier
Date: November 2023
Audience: Excel users
Category: Data Science
- Cutting-edge Excel tools Power Query and new functions like XLOOKUP, LET and LAMBDA
- Creating artificial intelligence using linear models, ensemble methods, and naïve Bayes
- Mathematical optimization, including non-linear programming and genetic algorithms
- Prediction with time-series data and forecasting with exponential smoothing
- Clustering with k-means, spherical k-means, and graph modularity
- Quantifying and addressing risk with Monte Carlo simulation
- Detecting outliers in single or multiple dimensions
- Statistical programming with R
For recommendations of books on data science see Reading Your Way Into Big Data in our Programmer's Bookshelf section.
For more Book Watch just click.
Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.
To have new titles included in Book Watch contact BookWatch@i-programmer.info
Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.