Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Hands-On Machine Learning with Microsoft Excel 2019 Build complete data analysis flows, from data collection to visualization

Product type Paperback

Published in Apr 2019

Publisher Packt

ISBN-13 9781789345377

Length 254 pages

Edition 1st Edition

Tools

Excel

Concepts

Data Analysis

Author (1):

Julio Cesar Rodriguez Martino

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Machine Learning Basics FREE CHAPTER

2. Implementing Machine Learning Algorithms

3. Hands-On Examples of Machine Learning Models

4. Section 2: Data Collection and Preparation

5. Importing Data into Excel from Different Data Sources

6. Data Cleansing and Preliminary Data Analysis

7. Correlations and the Importance of Variables

8. Section 3: Analytics and Machine Learning Models

9. Data Mining Models in Excel Hands-On Examples

10. Implementing Time Series

11. Section 4: Data Visualization and Advanced Machine Learning

12. Visualizing Data in Diagrams, Histograms, and Maps

13. Artificial Neural Networks

14. Azure and Excel - Machine Learning in the Cloud

15. The Future of Machine Learning

16. Assessment

Chapter 7, Implementing Time Series

By setting increasing(TravelDate) to the moving average values in the calculation and following the same steps.
If the seasonality is too different from the real value in the data, then the prediction will have less accuracy. If we increase the confidence interval, then the error will also increase.
Using the COVARIANCE.P function in Excel.

The time series diagram, after applying the logarithm, will look like the following screenshot:

The trend is still ascending, but the standard deviation looks flat and is not dependent on the time.

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Cesar Rodriguez Martino

Julio Cesar Rodriguez Martino is a machine learning (ML) and artificial intelligence (AI) platform architect, focusing on applying the latest techniques and models in these fields to optimize, automate, and improve the work of tax and accounting consultants. The main tool used in this practice is the MS Office platform, which Azure services complement perfectly by adding intelligence to the different tasks. Julio's background is in experimental physics, where he learned and applied advanced statistical and data analysis methods. He also teaches university courses and provides in-company training on machine learning and analytics, and has a lot of experience leading data science teams.

See other products by Cesar Rodriguez Martino