Calculating simple linear regression in Excel - Analyzing data in Excel (7)

Опубликовано: 05 Август 2026
на канале: Statistik am PC

135,096

807

// Calculating Simple Linear Regression in Excel //
Simple linear regression explains a (dependent) variable using an independent variable. It also describes the influence of a variable x on a target variable y.

This video demonstrates how to perform simple linear regression in Excel. First, a scatter plot is used to create a graphical representation. Then, a trend line, also known as the regression line, is added to the chart, and Excel calculates a regression formula and a coefficient of determination (R²).

To further illustrate this process, the slope of the regression line (Beta) is calculated manually in Excel, which is also used to calculate the constant (Alpha).

For questions and suggestions regarding simple linear regression in Excel, please use the comment section. Let us know if you found the video helpful by giving it a thumbs up or down.

``` For further reading, please visit my website:

========================================
💡 Simple Linear Regression in Excel:

https://www.bjoernwalther.com/einfach...

Helpful videos on regression:

==================================
🎥 Calculating Multiple Regression in Excel:    • Multiple lineare Regression in Excel rechn...
🎥 Interpreting Multiple Regression in Excel:    • Multiple lineare Regression in Excel inter...
🎥 Calculating Standardized Coefficients:    • Standardisierte Koeffizienten für die line...

⭐Channel Member⭐ Join:
=======================

   / @statistikampc_bjoernwalther

Timestamp ⏰
============
0:00 Introduction
0:06 Regression - Basics
0:18 Creating a Scatter Plot to Show Relationships
1:24 Adding a Linear Trend Line to the Chart
2:04 Outputting the Regression Equation and Coefficient of Determination
3:03 Explanation of the Regression Equation
3:23 Example Calculation with the Regression Equation
5:09 Manually Calculating the Slope of the Line (Beta)
6:45 Manually Calculating the Constant (Alpha)

Support the Channel? 🙌🏼
===================
PayPal Donation: https://www.paypal.com/paypalme/Bjoer...
Amazon Affiliate Link: https://amzn.to/2iBFeG9

Thank you for your support! ♥

My website 💡

=================
https://www.bjoernwalther.com