Roque Data Forecasting and Segmentation Using Microsoft Excel

Perform data grouping, linear predictions, and time series machine learning statistics without using code
1. Auflage 2022
ISBN: 978-1-80323-526-4
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection

E-Book, Englisch, 324 Seiten

No detailed description available for "Data Forecasting and Segmentation Using Microsoft Excel".

Autoren/Hrsg.

Roque, Fernando

Fachgebiete

• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Datenbankdesign & Datenbanktheorie
• Mathematik | Informatik EDV | Informatik Informatik Mensch-Maschine-Interaktion Informationsarchitektur
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Automatische Datenerfassung, Datenanalyse

Inhaltsverzeichnis

Table of Contents - Understanding Data Segmentation
- Applying Linear Regression
- What is Time Series?
- An Introduction to Data Grouping
- Finding the Optimal Number of Single Variable Groups
- Finding the Optimal Number of Multi-Variable Groups
- Analyzing Outliers for Data Anomalies
- Finding the Relationship between Variables
- Building, Training, and Validating a Linear Model
- Building, Training, and Validating a Multiple Regression Model
- Testing Data for Time Series Compliance
- Working with Time Series Using the Centered Moving Average and a Trending Component
- Training, Validating, and Running the Model

Über Autor(innen)

Roque Fernando:

Fernando Roque has 24 years of experience working with statistics for quality control and financial risk assessment of projects since planning, budgeting, and execution. Fernando works applying python k-means and time-series machine-learning algorithms using vegetable activity (NDVI) drones' images to find the crop´s region with more resilience to droughts. He also applies time-series and k-means for supply chain management (logistics) and inventory planning for seasonal demand.