 Hello, this is Professor Steven Nesheband. I'm here to help you out with the Excel part of this week work and just to orient you here, I am at week five and on our Moodle page and the data that we're going to be working with comes from NOAA and I'm going to go over to NOAA's site here just to show you where this came from. This is NOAA and they have station meteorology data for a lot of locations and one of them is this SPO which stands for South Pole Station and if you click on this .txt file, you can see that we're starting off in 1977 on January 1st and the key column is this one right here, which has the surface temperatures and of course there's lots of other years here going all the way up to 2016. So and the other thing that I want to just orient you to here is the that time period, there's January 1st it's warm at South Pole because that's in the Southern Hemisphere and temperature goes down for the winter and we're going to be focusing on this winter time data, which is more or less April 1st to to August 31st. Now, I've already collected that data from this site here at least for two years, 77 in 2016 and I packed them into some Excel sheets so all you really need to do is open with Microsoft Excel. If you don't have Excel on your system, then we'll have to do this through VDesk, but so now I just opened it up and as you can see, here's all those columns that we were just looking at and there's our key column of surface temperature. Now, what sort of analysis are we going to do about this? Well, one of them is I can look at the maximum temperature and so I have to say equals and then this max and I'm going to click on that and well, here it tells us the maximum temperature in the winter in at South Pole Station was minus 28.7. We can also see how cold it got. That would be the minimum temperature and once again, I'm going to just just enter that. I'll look at how cold it got, pretty cold and and so on, you can also do averages and so forth, but the big piece of it that I need to tell you about goes something like this. What we're going to want to do is what's called a histogram so we can see the distribution of temperatures over that winter and to do that I can see that I'm starting off that the temperatures are as low as minus 74 so I'm going to start off here and this is what you'll do too is say a little bit colder than that and we'll go at say five degree intervals so there's that and it turns out in Excel if you highlight two guys there with a trend then it keeps on going so I'm going to go down to minus 25 okay, and so now what we'll need to do is set up the histogram which I think I'll record in a separate video