I attached some lecture ppt, and the assignment below, also there is a excel file you will use.