Nov 16, 2026 | 447 words | 4 min read
6. Linear Regression#
This module builds on prior data analysis experience by introducing linear regression as a method to model relationships between variables. Students will learn to construct empirical models from experimental data and use these models to make predictions and engineering recommendations.
Engineers often need to identify cause-and-effect relationships from experimental data. For example, testing how electrical resistance changes with wire length or analyzing the tradeoff between energy and water use in cooling systems. Linear regression allows engineers to quantify these relationships and evaluate how well a linear model fits the observed data.
In this module, students will learn to calculate regression model parameters (slope and y-intercept) using least-squares methods, evaluate model fit using R-squared and residual analysis, and communicate data-supported recommendations through professionally formatted charts. Students will use Excel to perform regression analysis and interpret statistical measures to justify their engineering conclusions.
Topics Covered
Least-squares regression and model parameters
Slope and y-intercept interpretation
Sum of squared errors and model fit
Coefficient of determination (R-squared)
Regression trendlines in Excel
Residual analysis
Model limitations and assumptions
Engineering recommendations from regression models
Skills and Learning Objectives
At the end of this module, you will be able to:
Calculate regression model parameters (slope and y-intercept) from a dataset
Interpret the physical meaning of slope and y-intercept in engineering context
Compute and apply the least-squares method to construct best-fit lines
Use Excel functions and chart tools to perform regression analysis
Evaluate model fit using R-squared and assess prediction uncertainty
Analyze residuals to validate regression model assumptions
Construct professional scatter plots with multiple data series and trendlines
Write evidence-based engineering recommendations supported by regression analysis
These skills are directly connected to the following Learning Objectives:
- PR02:
Data Storage - Store and access data appropriately.
- PR03:
Calculations - Perform algebraic, array, relational, and logical operations using a programming language. Effectively utilize built-in functions.
- DV01:
Table and Plot Formatting - Prepare tables and plots for technical presentation with proper formatting. Include descriptive titles, axis labels with units, appropriately scaled axes, and visible legends.
- DV03:
Graphical Comparison of Data - Select, interpret, and justify appropriate graphical representations of data based on data type and structure. Use plots to compare distributions and identify patterns.
- DV04:
Regression Model Construction - Construct regression models that describe relationships between variables and support prediction.
- DV05:
Regression Model Evaluation - Evaluate and compare regression models using quantitative metrics (SSE, SST, and R²) and contextual reasoning.
- EC02:
Recognize Limits, Trade-offs, and Confidence - Recognize limitations, trade-offs, and uncertainty in engineering work and communicate appropriate levels of confidence in conclusions.
- EC03:
Make Honest and Responsible Recommendations - Make recommendations that are honest, responsible, and consistent with evidence, while acknowledging broader impacts and professional responsibility.
- PC02:
Communicating Results from Analysis - Clearly state conclusions or results derived from code, models, or data analysis.
- PC05:
Meeting Assignment Expectations - Fully complete all parts of each assignment according to provided instructions.