 Statistics and Excel. Wages, data, box plot, or box and whiskers versus histogram. Get ready. Taking a deep breath, holding it in for 10 seconds, looking forward to a smooth, soothing Excel. Here we are in Excel. If you don't have access to this workbook, that's okay. You can either go back to a prior presentation where we basically built this practice problem from a blank sheet, starting with a blank sheet from there. Or you can create your own data set as we focus in on the creation of a histogram for this part of the practice problem. If you do have access to this workbook, there's three tabs down below. Example, practice blank. Example, in essence, answer key. Practice having pre-formatted cells in it so you can focus on the heart of the presentation. The blank tab is where we build everything from, in essence, a blank sheet with just some raw data to start out with. Let's go to the example on the left-hand side. In prior presentations, we're taking our raw data of simply the wages, and we created the box and whisker to get a visual representation of it. Then we did some calculations to try to identify some areas of the box and whisker. Now we want to create the other type of graph, which is quite common to be visualizing that being the histogram. In Excel, histograms are great to be able to use because they give you a really good kind of spread of the data. I think it would be a little bit more difficult prior to having Excel to obviously chart things out in a histogram format by hand. The box and whiskers might be a little bit easier by hand, but they both have their uses and we can compare and contrast them. We'll be doing a lot more work with different kinds of histograms to see how data plots on the histogram and future presentations. Let's go to the blank tab. We have a little bit different format at this point because we added some of the numbers on the box and whiskers, for example. But the general idea being the same. We've got the data on the left. We created the box and whiskers. The way we created the box and whiskers is we simply just selected the entire data, which you could do with the dropdown like this. We went to the insert. That's the tab up top. We went to the charts. In this dropdown, you'll note that that's the home of both the histograms and the box and whiskers because those are going to be applied to similar methods or two methods that will have similar usage. They grouped those things together. We put in our histogram last time and then we did some formatting to the histogram. Remember, our data represents basically just wages that we might see at a company. Now, let's add the second bit, which is going to be the histogram. Now note, if you don't have this data wages, you can look up wages if you want to. You can also use a random generator. If you wanted to have random wages and then add a few outliers just to have some data to work with, you could say equals random and then random between. Our data set is basically between 65,000 and then comma and the top is like 75,000. If you use the random generator, Excel can do that. Random numbers between those points. Copy it down and then maybe add some outliers. This one would be like 85,000. Now it's outside of the range. Obviously, it's great to have real data because our goal is statistics is to oftentimes see what the difference is between the random data set and the actual data set in real life to give some glean some insights as to what's going on with the data. That's one of our strategies, of course, which we'll talk about more later. But that's one way to generate some data if you just want to then practice putting in a histogram. Once you have your data, we can select the data. You can highlight the data this way, dragging down. If you have the table data in a table format, you can put your cursor on the top of the table, select this way. You can also put your cursor on it and hold down control shift, and that'll take you down to the bottom of the data set. If you want to go back up, you can hold down control and backspace, not delete backspace, and that's another nice way. Note that you'd like to be at the top of the data set usually when you're going to be inserting the whatever charts or graphs you're going to put in. Otherwise, the chart or graph will be shown at the bottom and you're going to have to pull it up to the top. I want to be up here because I want to be able to pull the graph like right around here. Let's go ahead and now insert tab up top.