Download the Cover Sheet for this lab as an Adobe PDF. This can be used to record your answers to the questions in the lab.
This table contains data on absences by day of the week.
Enter the data in the table into a spreadsheet and perform the following calculations:
Add an additional week of data as follows: 4, 5, 2, 3, 2. How many cells did you have to change to add this new week's worth of data?
Delete the third week of data. How many cells did you have to change?
Go in and create a circular reference by making the sum of absences for week 1 include the cell containing the sum. Describe what happens.