Problem: OLS trendline in Excel

Problem

Data: \video\data/ols.xlsx

Use Excel to solve this problem. Find the OLS trendline

1. using the functions average, var.s and covariance.s only
2. using the trendline in a scatter plot
3. using the function linest