I manage a relatively large dataset:
52 columns representing each week in a year
267 rows representing 267 monitoring stations at different locations
The spreadsheet is populated with data on air emissions.
The spreadsheet is up-dated on a weekly basis, and every week I am required to examine the data for each monitoring station to see if emissions are increasing or decreasing. The goal is to spot trends.
Example 1: If emissions at one monitoring station are increasing slowly over the course of 4 or more weeks, I may flag this monitoring station in my dataset and follow up with the facility that is generating the emissions.
Example 2: If emissions at one (or more) monitoring station(s) are decreasing over the course of 12 weeks, I may decide to stop collecting data for this monitoring station (i.e. remove it from my dataset).
Without having to plot/graph data for each monitoring station, is there a function (or other solution) I could use that would make it quick/easy to spot trends in my data?
Thanks,
tan
Bookmarks