Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Fundamentals of Correlation and Regression
New
Rating: 4.1 out of 5(6 ratings)
21 students

What you'll learn

  • Understand the fundamentals of correlation and regression and explain how statistical relationships are identified and interpreted in real-world data.
  • Create and interpret scatter plots, correlation coefficients, regression equations, and regression models using Microsoft Excel.
  • Evaluate the strength, direction, and statistical significance of relationships between variables using tools such as p-values, hypothesis tests, and R-squared.
  • Build and interpret simple and multiple linear regression models for prediction, forecasting, and process analysis applications.
  • Identify common regression issues such as outliers, extrapolation, residual patterns, and misleading correlations.
  • Apply correlation and regression tools to practical engineering, manufacturing, quality, business, and operational decision-making problems.
  • Use Microsoft Excel functions and tools such as CORREL, LINEST, trendlines, and the Data Analysis ToolPak to perform statistical analysis.
  • Develop a foundation for more advanced analytical topics such as ANOVA, predictive analytics, machine learning, and logistic regression.

Course content

1 section35 lectures1h 38m total length
  • Introduction to the Course6:25
  • Introduction to Correlation and Regression2:06
  • Observing Correlation1:58
  • All Excel Templates and Examples2:25
  • Measuring Correlation4:58
  • Requirements for Correlation Coefficient1:34
  • Pizza and Subway Example1:09
  • Pizza and Subway, The Z Method1:54
  • Correlation In Excel2:25
  • Significance Level of Correlation Coefficient2:12
  • Glass vs Paper Correlation Example2:23
  • Interpreting R3:32
  • Using the t Statistic to Test for Linear Relationships4:51
  • Glossary of Terminology1:21
  • Basic Concepts of Regression3:12
  • Requirements for the Regression Line Equation2:25
  • Simple Linear Regression in Excel2:04
  • Manual Regression Calculations2:49
  • Making Predictions with Regression Equations1:42
  • Marginal Changes1:06
  • Outliers1:13
  • Residuals and the Least Square Property4:40
  • Explained and Unexplained Variation3:55
  • Coefficient of Determination1:34
  • Prediction Intervals1:54
  • Standard Error of the Estimate2:58
  • Prediction Interval for an Individual y1:50
  • Multiple Regression3:32
  • Building a Multiple Regression Equation in Excel4:17
  • Multiple Regression p Value1:10
  • Dummy Variables in Multiple Regression3:41
  • Introduction to Nonlinear Modeling4:49
  • Closing Comments and References1:49
  • Conclusion to the Course2:22
  • Bonus Lecture6:40

Requirements

  • A basic understanding of introductory statistics is helpful, but advanced statistical knowledge is not required.
  • Students should be comfortable using Microsoft Excel at a basic level, including entering data, creating charts, and using simple formulas.
  • No prior experience with correlation, regression, data analytics, or statistical modeling is required.
  • A copy of Microsoft Excel is recommended so students can follow along with the hands-on examples and downloadable templates.
  • Students should be willing to work through practical examples and apply statistical thinking to real-world problems and decision making.

Description

Learn how to identify relationships in data, build predictive models, and make better decisions using practical statistical tools and Microsoft Excel.

Correlation and regression are among the most important analytical tools used in engineering, manufacturing, quality, operations, business analytics, supply chain management, finance, and data-driven decision making. This course is designed to make these concepts practical, approachable, and immediately useful.

In this Fundamentals of Correlation and Regression, you will learn how to:

  • Interpret correlation and regression results

  • Build and analyze regression models

  • Evaluate statistical significance using p-values and hypothesis tests

  • Understand R-squared, residuals, outliers, and prediction error

  • Create simple and multiple regression models

  • Use Microsoft Excel to perform real-world statistical analysis

  • Apply regression tools to forecasting, prediction, process analysis, and operational improvement

The course combines:

  • Voice-over PowerPoint instruction

  • Step-by-step Microsoft Excel demonstrations

  • Practical examples from engineering, manufacturing, quality, and business applications

  • Downloadable Excel templates and example files

This course is designed for professionals and students who want practical analytical skills without unnecessary theory and mathematical complexity.

Included in This Course:

  • Downloadable Excel templates and example files

  • Glossary of statistical and regression terminology

  • Lifetime access to all course materials

  • Future course updates

  • Practical, career-focused instruction

Who This Course Is For:

  • Manufacturing and quality professionals

  • Engineers and technicians

  • Continuous improvement professionals

  • Supply chain and operations professionals

  • Data and business analysts

  • Students seeking practical statistical analysis skills

  • Anyone wanting a stronger foundation in correlation, regression, and predictive analytics

No prior experience with regression analysis is required. A basic familiarity with Microsoft Excel and introductory statistics is helpful, but advanced mathematics is not necessary.

If you want to better understand data, identify meaningful relationships, and make more informed decisions using Microsoft Excel, this course was built for you. Enroll in Fundamentals of Correlation and Regression today!

Who this course is for:

  • Quality Engineers, Manufacturing Engineers, Process Engineers, Reliability Engineers, Industrial Engineers
  • Continuous Improvement Professionals, Lean Six Sigma Green Belts, Lean Six Sigma Black Belts, Operational Excellence Managers, Quality Managers
  • Production Supervisors, Manufacturing Managers, Operations Managers, Plant Managers, Engineering Managers
  • Supply Chain Analysts, Business Analysts, Data Analysts, Operations Analysts, Financial Analysts
  • Test Engineers, Validation Engineers, Product Engineers, Design Engineers, Mechanical Engineers
  • Calibration Technicians, Quality Technicians, Laboratory Technicians, Metrology Technicians, Engineering Technicians
  • Procurement Professionals, Supplier Quality Engineers, Supplier Development Engineers, Inventory Analysts, Logistics Analysts
  • MBA Students, Engineering Students, Operations Professionals, Project Managers, Technical Managers