 Statistics and Excel. Hamlet, Harry Potter and statistics. Let's take a deep breath, hold it in for 10 seconds, getting ready for a smooth soothing Excel. Here we are in Excel. If you don't have access to this workbook, that's okay because we'll basically build this practice problem from a blank sheet and therefore you can just open up a blank sheet and work from there. If you do have access to this workbook, there should be six tabs down below. We're working two practice problems, each of those practice problems having three tabs related to it. The example tab, in essence being the answer key, the end result, the practice tab having some pre-formatted cells within it so you can practice focusing in on the heart of the practice problem. The blank tab having just the data set so we can practice formatting the cells as well as the heart of the practice problem, in this case building a chart. Also note that I'm currently in dark mode. I think that's easier on the eyes, so I hope that doesn't throw anyone off. I do recommend the dark mode if you're going to be using Excel a lot, but the layout should be the same. It's just going to be dark in the dark mode. Let's go on over to the Hamlet. Look at the Hamlet problems. See if we could solve the Hamlet problem. We're not going to solve Hamlet's problem. He has a lot of problems. The problem that we're working with relation to Hamlet is going to have the data on the left-hand side and then we're going to be building this table from the data, this graph from the data, this bar chart from the data. Now if we go into the second tab, the practice tab, we've formatted the data on the left-hand side, so it's a little bit easier to go right to the heart of just using this to create our graph. The third tab just has the data on the left-hand side and we'll practice formatting the cells and then organizing them and then creating the bar chart so we can practice the basics, the essentials of Excel as we go. Now note that if you don't have this data at all, it's not too much data so you could just simply type it in if you so choose and you can work from a blank sheet. You can also look this up online. You can look up the word count for Hamlet. That's what we have in here, the word count for Hamlet and then you can copy and paste that information into your Excel worksheet and then you'll have your data set and we can basically move from there. Because this is our first practice problem within Excel, we want to go over some fundamentals about Excel. So the first thing to note is that we can name any cell within Excel using this grid format using the lettering up top, A, B, C, D, E, F in this case and I think I was on F5 if I move down 1, 2, 3, 4, 5, F5. So this cell is F5 so we can name that cell. That naming is also over here so it's in F5. Also note that if you start typing in a cell, then you're going to be within the cell. So if I just start typing here, now I'm kind of within the cell and if I click off of it now I'm off of the cell. If I want to go back in here and start typing again, if I simply click back on the cell and start typing, it's going to overwrite what I did before. It's going to overwrite what I did. Let's undo that. One way you can undo is right here. This button is quite useful. You can also have the keystroke control Z to undo and boom. So that's going to be a quite useful button. So if you want to go in the cell then you need to double click on the cell. So if I want to go to the end of that F, I need to double click on the cell and now I'm in the cell and I can continue typing from there. The other thing we just want to recognize is that if you put a formula into the cell they usually start with an equal sign. So if you put an equal sign into the cell then if you start clicking on other things over here Excel thinks that you're trying to create a formula. And that's why it's you get the sticky bit right where there's a formula. If you didn't want a formula you got to get rid of that equal sign and then you can basically move around again. The same would be if you started with a plus a plus Excel thinks it's going to be a formula. So it's going to be you know stuck into it there and you're going to have to delete that before you can basically move around again. Quick recap up top. This is what we call the ribbon up top. Many of the functions within the ribbon are going to be in the home page. Within the tabs of the ribbon home insert page layout formula. You've got the groups in each tab so you've got the home tab with a group of the clipboard the group of the font the alignment the number of the style and so on and so forth. So when you start using Excel you'll probably into it intuitively go to these items up top but if you want to formally describe to someone where something is you can say it's in the tab home tab. It's in the group of fonts group and then you're you're narrowing down to this kind of box. So that makes it a little bit easier. This is your quick task bar down here. Most of the stuff is the default. These aren't in the default. I put these down here but the undo is like in the default down here. And then this is your formula bar up top. So anything you type into a cell is also going to show up on the formula bar which is useful especially if you're you know your way out here somewhere. You're typing something like way out here and you're not in the cell anymore right but you can still see the formula kind of up top. All right so those those are just some essentials that we're going to that that we kind of want to understand going into basically any practice problem. Now down here you can increase the size I'm at currently 160 I can zoom in like this or I can hold down control and scroll up on my scroll wheel. So that allows me to zoom in and out also quite useful. Now typically whenever I start a new sheet in Excel. I like to see the numbers in a number format. So right now you can see in the home tab and the numbers group were in the general formatting. So typically I'll select the entire sheet and I'll put my baseline or underlying formatting that I like to work in. You could do that with the drop down here number group and format it up top but I like to right click on it and then go to the format cells. And then I'm in the number tab it's currently in the general format I'm going to I like going to currency but then make the negative numbers bracketed and red and then I remove the dollar sign. And in this case I don't need the decimals so I'm going to remove the decimals as well. And so that's my standard format usually for me so I'll do that basically every time as my underlying data format. All right and then in this data sometimes it might be useful to put the labels up top. So this is actually the number of words in Hamlet. Now our idea here is that hey look obviously if I just take the data of the number of words then it's not the same thing as Hamlet. I'm losing meaning by just having a list of the words in this format. However this format of the words can give us some information because it can tell us how often like Shakespeare uses particular words. You could do similar things with tropes and whatnot and that might give you some information about how you know a writer is pursuing his craft right. So and that could help that could be useful even though it's not we're actually not telling the story here with this word count. So I'm going to add I'm going to add a row up top. Now a few ways you can add the row. Most people might think if I'm going to add the row I'm going to highlight this thing and then try to drag it down like this. I can try to drag it down. That's one way you can do it probably not the most efficient way I'm going to undo that. You can also highlight the whole thing and right click and cut it and then put it down here right underneath it. That's actually the same thing. I right click and I pasted it. That's actually the same thing as moving it the way we did it before. So that's actually a little bit more efficient oftentimes. But what I really can do there's nothing on the right side of the screen here. So what I want to do is add a row above it. That's probably the easiest thing to do so I can select the number one here and I'm going to say this whole row. I want to add something above it to fit my my headers. Now if there was something on the right I'd have to worry about doing it this way. But there's nothing on the right. So I can just right click and insert cells and that will insert an entire row. So hold on. It's highlighting something. That's why get rid of the dancing ants select and then insert. All right. So there it goes. Now if there was something on the right then I could still do it that easier way but it takes I can select like these two. And so I just want to insert cells above it and push everything below it down. I have to be careful if there was something below it with this technique but there's nothing below it. So that's what I wanted to right click. Insert and then I want to say shift the cells down.