Homework Module 5 ACC 535

Use the 2_Somerville_2013-2016 Excel data file that contains payments data for 2013 to 2016 for the City of Somerville in Massachusetts. This data was introduced in Case 2.1.

There are 55,746 records (check payments) and a header row. The 15 check amounts equal to $0 were checks that were lost in the mail and that were later reissued for the correct amount. Do not treat them as missing values. Use new Excel worksheet and show your result or text for each question below. Students must provide Question # for each worksheet. If students fail to follow the direction, such homework assignment will not be graded. Students must upload the Excel file to the Assignment Folder for grading accordingly.