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
Publisher: Wiley
Date: November 2023
Pages: 448
ISBN: 978-1119931386
Print: 111993138X
Kindle: B0CJPP7XZM
Audience: Excel users
Level: Introductory
Category: Data Science

Topics include:

• 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.