Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou by Roque, Fernando
Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou by Roque, Fernando

Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou

Perform time series forecasts, linear prediction, and data segmentation with no-code Excel machine learningKey Features: Segment data,...
€109,10 EUR
€109,10 EUR
SKU: 9781803247731
Product Type: Books
Please hurry! Only 252 left in stock
Author: Fernando Roque
Format: Paperback
Language: English
Subtotal: €109,10
Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou by Roque, Fernando

Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou

€109,10
Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou by Roque, Fernando

Data Forecasting and Segmentation Using Microsoft Excel: Perform data grouping, linear predictions, and time series machine learning statistics withou

€109,10
Author: Fernando Roque
Format: Paperback
Language: English
Description

Perform time series forecasts, linear prediction, and data segmentation with no-code Excel machine learning


Key Features:

  • Segment data, regression predictions, and time series forecasts without writing any code
  • Group multiple variables with K-means using Excel plugin without programming
  • Build, validate, and predict with a multiple linear regression model and time series forecasts


Book Description:

Data Forecasting and Segmentation Using Microsoft Excel guides you through basic statistics to test whether your data can be used to perform regression predictions and time series forecasts. The exercises covered in this book use real-life data from Kaggle, such as demand for seasonal air tickets and credit card fraud detection.


You'll learn how to apply the grouping K-means algorithm, which helps you find segments of your data that are impossible to see with other analyses, such as business intelligence (BI) and pivot analysis. By analyzing groups returned by K-means, you'll be able to detect outliers that could indicate possible fraud or a bad function in network packets.


By the end of this Microsoft Excel book, you'll be able to use the classification algorithm to group data with different variables. You'll also be able to train linear and time series models to perform predictions and forecasts based on past data.


What You Will Learn:

  • Understand why machine learning is important for classifying data segmentation
  • Focus on basic statistics tests for regression variable dependency
  • Test time series autocorrelation to build a useful forecast
  • Use Excel add-ins to run K-means without programming
  • Analyze segment outliers for possible data anomalies and fraud
  • Build, train, and validate multiple regression models and time series forecasts


Who this book is for:

This book is for data and business analysts as well as data science professionals. MIS, finance, and auditing professionals working with MS Excel will also find this book beneficial.

Author: Fernando Roque
Publisher: Packt Publishing
Published: 05/27/2022
Pages: 324
Binding Type: Paperback
Weight: 1.23lbs
Size: 9.25h x 7.50w x 0.68d
ISBN: 9781803247731

This title is not returnable

Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review