[ Home | Data Analysis | Excel | Visual Basic ]

All work should be completed in the session for which it is set. Work carried over for marking in the following week will only receive half the credit. Note that the session ends at 5:30pm, and work should be marked by this time.

This week you should complete the following tasks:

One of the major practical procedures discussed in the data analysis lectures is the least squares fitting of a straight line to a set of data points. Exercise Excel-6 is a guided spreadsheet application. (You will need the spreadsheet Least_squares_fit.xls.) In exercise Excel-7 you construct the spreadsheet yourself.

This week's lecture discussed the least squares method for finding the best fit of a straight line to a set of data points.

[ Previous week | Next week ]