River sediment data

An environmental engineer measures the suspended sediment in the water at two locations of a river over 15 days. The engineer expects a correlation between the two locations. Because one location is farther downstream, the engineer expects that the correlation pattern is consistent with the time that is needed for water to move between the two locations.

You can use this data to demonstrate Cross Correlation.

Worksheet column Description
Upstream The suspended sediment in the water at location 1
Downstream The suspended sediment in the water at location 2
Date The date that the water was sampled