Problem: OLS trendline in Excel
Problem
Data: http://media.nek.lu.se/data/ols.xlsx
Use Excel to solve this problem. Find the OLS trendline
- using the functions average, var.s and covariance.s only
- using the trendline in a scatter plot
- using the function linest
Solution