This weekend, the parts of the Northeast and Mid-Atlantic have been experiencing some really warm temperatures.
Whether you are a scientist, a teacher, or just an interested individual, plotting temperature can be really informative and even exciting way to visualize this heat advisory.
One of the greatest assets of the NERRS is the System-Wide Monitoring Program (SWMP), which makes parameters such as temperature, humidity, and precipitation easily available. SWMP data is take every 15 minutes, allowing you to see the nearly instantaneous changes in weather rather than just get the daily high and low.
In today’s post, I will demonstrate how I use Excel to make some of the figures I commonly post here, such as the the image’s from last week’s post!
Step 1: Get the data!
SWMP data is downloadable from the Centralized Data Management Office located here: http://cdmo.baruch.sc.edu/.
For today’s example, I was only interested in temperature, so I deleted the other cells so it wouldn’t get crowded. The data comes in metric units, that is Celsius for temperature; however, I will be converting it to Fahrenheit since these units are more recognizable in the United States.
But I encourage you to remember this simple rhyme in case a plot is ever in Celcius: 30 is hot, 20 is pleasing, 10 is cool, 0 is freezing!
Step 2: Make the plot in Excel
You don’t need to be fancy, Excel can be easily used to make some pretty plots! With a few tips, you can have a customized plot.
Step 3: Interpret the data!
It is one thing making the graph, but the true purpose is to understand what the data is displaying! I often like to use Powerpoint to add captions into the plot to highlight important points.
Our plot(s) here show that this weekend was really warm in Maryland!
What’s another way you can look at the SWMP data even easier and quicker? The plotting function from the CDMO website!
So the SWMP data can be a fun way to “see” this heat wave we are currently experiencing in the Chesapeake Bay region! You have tools at the ready to go as in depth into the data as you need!