Scatter Plots & Correlation: Is There a Linear Relationship?
This lesson is part of the course
In this lesson
You measure how strongly weekly ad spend and sales move together: the correlation coefficient by hand, then with CORREL, and as a scatter chart with a trendline.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Scatter Plots & Correlation: Is There a Linear Relationship? Locked
- Simple Linear Regression by Hand: Least Squares, R² & Standard Error Locked
- Is the Slope Real? t Statistic, p-Value & Confidence Interval Locked
- Predicting a New Store: Point Forecast & Prediction Interval Locked
- Multiple Regression with LINEST: Three Drivers at Once Locked
- Dummy Variables: Regions and Seasons in a Regression Locked
- Residual Analysis: Residual Plot, Standardised Residuals & Outliers Locked
- Log Models & Elasticity, plus Two Classic Pitfalls Locked