Book
Data Forecasting and Segmentation Using Microsoft Excel
This book uses real-life datasets from Kaggle to explain basic statistics for machine learning for data segmentation, regression predictions, and forecasts. You’ll focus on variable dependency and autocorrelation to build, test, and use a linear regression prediction model and time series forecasts.
Offered by
Difficulty Level
Intermediate
Completion Time
10h48m
Language
English
About Book
Who Is This Book 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.
Data Forecasting and Segmentation Using Microsoft Excel
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 10h48m total length
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
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!