 Hello, this is Professor Steven Ashaband. I'm here to help you out with the exercise on the histogram assignment. So I'm here at the Week 6 Moodle page, and I put in another link to Noah's page there, which you can go to, because that's where we're going to get our data. And here we are at the Noah site. And there's the Station Meteorology link that you'll link to. Now, there's all these different data sets from different places, and if you want to know what all these stand for, you can go to this readme file. And so, for example, Barrow Alaska is BRW, Montelua is MLO, and so forth. We're not going to use this BLD. I think that stands for the Noah building itself. So you'll choose one of these. I'm just going to click on Barrow here. And you can see Barrow's got data from 88 down to 2017, which will, of course, if we want to have a full Spain, we want to just go up to 2016. And you'll want to check over these data sets to make sure that it's got the month that you want. So in this case, it does have a full set, January through December. And you'll also want to check to make sure that you've got that for the final year. So I'll go here to 2016. And yeah, there it has for January as well. So first thing I'm going to do is go back to 1988 for Barrow. And the way you download this is you have to right click on that. And then you're going to save the link as. And you're going to have to put it somewhere. Now, I've already created a folder here where I was going to keep all that. And I've already actually downloaded that. So I don't need to do that. And you'll do the same thing for the other month. Then what you need to do is in Excel is to pick up that data set. And the way you do that is here in Excel. I've got a new sheet here. And you have to do this thing called import. So I'm going to import. And it's just a text file. So you need to click that. And it's going to say, well, what text file do you want? And I think I'm just going to get the 1988 file here. It's going to have this text wizard. You need to say, I want delimited by commas and so forth. So I'm going to go to next. And there's spaces between them. So you need to click on that. And that should be pretty good. And I'm just going to say finish here. And sure, I want that on the current sheet. And if it all has gone well, then you get these data. Now, one more item on here is when you do this, just to kind of get a sense of the scale, I'm going to say the max. And it's the k column, which is the temperatures. OK. And the minimum, that's also the k column. I mean, looking at k column. Sometimes you'll see the number minus 999 show up here. And that means there's no good data for that. Doesn't really matter because, well, it would matter if you were taking the standard deviation. But what we want is a histogram. So it'll kind of ignore that. Once again, though, just to make sure that we have all the data covered, I'm just going to say minus 80, minus 75. This time, we're going to run the temperatures all the way up just so we don't miss anything to like 40 degrees Celsius. And once again, now to do the histogram, I go to data here. I'm going to do the data analysis. There's a histogram. And this is already had filled in. It's k row. That's fine. And just to make sure I got this right, I'm going to go click on here. So that's the histogram that I want. Make sure you click chart output. And hopefully, this will all show up nicely. OK. So here, we have a histogram of the temperature at Barrow for that year. One more thing that you'll need to do is just annotate this a little bit better and say this is a histogram for January 1988, Barrow Alaska. OK. And once you've got that, that's all fine. Now, what I'm going to want you to do is make a copy of this chart and put it into a Word file. So I've opened up a Word file. So that was a copy and paste. And so here, we have the histogram for January 88. And then what you're going to do is do the same thing for, say, 2016 for Barrow, same month, or whichever location you want. You don't have to go for Barrow. And I think that that just kind of completes the assignment. So it's this that I'm going to want you to upload as your assignment. And you don't have to put any captions on it. You just want the graphs.