Problem: Fitted values and residuals in Eviews

Problem

Using EViews and data: http://media.nek.lu.se/data/ols.xlsx

1. Find the trendline and create a plot of the actual values, fitted values and residuals
2. Find OLS residuals and save them in a series called e
3. Find OLS fitted values and save them in a series called yhat
4. Create a new series e2 as y – yhat and confirm that e2 is the same as e
5. Calculate RSS