 Hello. We are going to show you how to calculate a sum and a mean using Excel. I'm going to be inputting data. Again, my data consists of 12 numbers, and I'm going to insert it right here starting in D2. Notice how spreadsheet works. We're in the D column and I'm in the second row. I'm going to input 12 numbers. 69, 168. We're going to show you how to get a sum and a mean. Not going to be doing very much in this tutorial. We're still getting our feet wet in Screencast-O-Matic. Where was I? 68, 55, 99, 72, 59, 44, 88, 80, 74, and 71. That should be 12 numbers. It goes from D2 down the column to D13. It's always important to know where your data is located. Write it on your hands. D2, colon, D13. That's where your input data is located. The first thing I'm going to do is get a sum. Always write down what you're getting. So that you don't have to go look at the formula later. Yes. Also, when you show it to a boss, the boss will say, what is this? You'll say, well, it says sum. In column C14, I have the word sum. Now I want this sum to appear in column D14. So now I'm going to use what's called a function wizard. See that little f up there? It says insert function, a little f, a little x. That's called a function wizard. I clicked on it and I look for actually showing sum in average. But I can use this. That's one way to do it. Just use the sum feature or I'll show you another way to do it. Let's do it for the sum feature. OK, so I want the sum, say OK. OK, it's actually saying D2 to D13. Perfect. D2 to D13 and I say that's where my data is. I make sure that's where the data is located. I say OK. And there's the sum. There we go. 879. You can take a minute and check to make sure it's correct. Yes, but it's the sum of these 12 numbers. Now the summation symbol, you'll see it on the menu. If you go back up to the ribbon and you got this is a space saving ribbon. If you go to home and over to the summation symbol, that's a sum. And it would have done it too. That's the same thing. That's a Greek symbol, that symbol up there. That's called sigma and it's a summation symbol. You're going to see it all throughout the semester. Yes, so you could have done it with that. I want to get the average, sometimes called the mean. OK, the average or the mean. I write the word average so I know what I'm doing. OK, and again, I want this where D15. OK, so D15 will be the average. What are the function wizard? Well, average is there. But if it wasn't there, I'd look under statistical look for the word average. Anyway, I got average. In the function wizard, click OK. Now, this is wrong. It says D2 to D14, as I told you, your data is D2 to D13, right? You automatically assumed if there was a number there that that's what you wanted. So you have to be careful. But again, I told you, you had on your hand, you're looking at your hand. D2 to D13, that's what your data is. I have no idea why Excel uses calls this number one. It should be called an array or input data. This number one is strange. I have no idea. But you'll get used to it. Yeah, you'll get used to it because you know what the computer needs. It needs to know where the data is located. Click OK. And there's your average, 73.25, you can tell your boss. Can't be easier than this. Can't be easier than this, exactly. OK, that's it for our first lecture on how to begin to use Excel for statistics.