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 byPackt Logo

Difficulty Level
Intermediate
Completion Time
10h48m approx.
Language
English
Certification
Not available

About Course

Book Content

chapters 10h48m total length

1. Understanding Data Segmentation
2. Applying Linear Regression
3. What is Time Series?
4. An Introduction to Data Grouping
5. Finding the Optimal Number of Single Variable Groups
6. Finding the Optimal Number of Multi-Variable Groups
7. Analyzing Outliers for Data Anomalies
8. Finding the Relationship between Variables
9. Building, Training, and Validating a Linear Model
10. Building, Training, and Validating a Multiple Regression Model
11. Testing Data for Time Series Compliance
12. Working with Time Series Using the Centered Moving Average and a Trending Component
13. Training, Validating, and Running the Model

On this page

Ready to Train Your Team?

Need training for your whole team? Get bulk pricing, LMS integration, and dedicated support.

Trusted by Leading Organizations Worldwide

Join thousands of companies that trust Calibr to power their learning and development initiatives.

Chalet Hotels logo
Pernod Ricard logo
ProMobi logo
Metrique logo
K Raheja Corp logo
Spyne.AI logo
VuNet Systems logo
Procurement Partners logo
vEngage.AI logo
1218 Global logo
TRADEJINI logo
Oben Electric logo
IIT STartups logo
EdTech Digit logo
MindSkillz logo
NewportMed logo

Request Access For Your Organization

Start training your team in minutes!

No credit card required

Related Resources