How to Use Excel for Bivariate Data Analysis (Scatterplot and Residual Plot)

Описание к видео How to Use Excel for Bivariate Data Analysis (Scatterplot and Residual Plot)

I show you how to use Excel to complete a Linear Regression Analysis for Bivariate Data.
Time Stamps
Intro 0:00
Formatting 0:36
Scatterplot 1:42
Add Trendline 5:18
Add Equation and R^2 Value 5:46
How to Extrapolate 6:16
Correlation Coefficient 6:41
R^2 Value with Formula 7:32
Residual Plot 8:19

Install the Analysis ToolPak in Excel
https://support.office.com/en-us/arti...

Комментарии

Информация по комментариям в разработке