1 00:00:00,000 --> 00:00:05,000 2 00:00:05,000 --> 00:00:11,066 Hello, and welcome to a video on how to make box plots in Excel. So to make any kind 3 00:00:11,066 --> 00:00:17,366 of chart, you'll first want to select your data. In this case, today let's make a box 4 00:00:17,366 --> 00:00:22,966 plot for IV2. So we're going to select just the data from IV2. 5 00:00:22,966 --> 00:00:28,699 6 00:00:28,700 --> 00:00:34,833 Okay, I've gone ahead and selected all that data. And I'm going to scroll back up to the top so that my box chart appears closer 7 00:00:34,833 --> 00:00:36,466 8 00:00:36,466 --> 00:00:40,599 to the top. Next you'll go to insert, insert 9 00:00:40,600 --> 00:00:43,400 10 00:00:43,400 --> 00:00:49,633 statistics chart. This may look a little different depending upon your version of Excel. But look 11 00:00:49,633 --> 00:00:55,833 for either statistics chart or box and whisker plot something along those lines. And you see we've found an option 12 00:00:55,833 --> 00:00:55,866 13 00:00:55,866 --> 00:01:00,399 for a histogram and for a box and whisker plot. In this case we want box and whisker. 14 00:01:00,400 --> 00:01:02,166 15 00:01:02,166 --> 00:01:08,266 Okay, I'm just going to move this off to the side a little bit. Let's change 16 00:01:08,266 --> 00:01:08,299 17 00:01:08,300 --> 00:01:14,433 this chart title to something else. And you can see when I double click it we've got title options. We can have it overlay. 18 00:01:14,433 --> 00:01:20,466 I don't like that though. You can't see your title is clearly. So we'll stick with above. We 19 00:01:20,466 --> 00:01:26,799 have text options. So we can choose our alignment. We can have 20 00:01:26,800 --> 00:01:28,500 21 00:01:28,500 --> 00:01:31,600 shadow color, text fill. 22 00:01:31,600 --> 00:01:35,733 23 00:01:35,733 --> 00:01:41,966 We're not going to do any of that today. Generally speaking, when you're talking about data visualization, 24 00:01:41,966 --> 00:01:48,232 simple is best. We'll just title it Lindsey's box plot today. Or maybe 25 00:01:48,233 --> 00:01:54,266 just my box plot. Your assignment will have a specific name that you'll be naming 26 00:01:54,266 --> 00:02:00,399 your box plot. Now this one down here is a little bit useless. So you can just 27 00:02:00,400 --> 00:02:00,433 28 00:02:00,433 --> 00:02:06,533 click on this one and hit your delete key to get rid of it. If you 29 00:02:06,533 --> 00:02:12,566 do not have a delete key, the backspace key will probably work just as well. Now you'll notice we have these 30 00:02:12,566 --> 00:02:12,599 31 00:02:12,600 --> 00:02:18,866 little buttons off to the side. And you'll have these on almost every chart style that Excel has 32 00:02:18,866 --> 00:02:25,466 available. And you can click these and add chart elements. So if we wanted axis titles, 33 00:02:25,466 --> 00:02:25,499 34 00:02:25,500 --> 00:02:31,566 then that's where we would click to add those. If we didn't want a chart title, we could get rid of it that way. But we do want a 35 00:02:31,566 --> 00:02:37,632 chart title. If we wanted data labels, we could add them here. And this would 36 00:02:37,633 --> 00:02:37,666 37 00:02:37,666 --> 00:02:43,866 let us know what exactly the numbers are for our outliers, for our quartile 38 00:02:43,866 --> 00:02:44,566 39 00:02:44,566 --> 00:02:50,732 percent, sorry, quartiles, our inter quartile range, things like that. 40 00:02:50,733 --> 00:02:54,833 41 00:02:54,833 --> 00:03:00,866 We can have a legend, which we only have one series, so having a legend is a little silly. Let me go ahead 42 00:03:00,866 --> 00:03:00,899 43 00:03:00,900 --> 00:03:07,000 and change my title back to my box plot. Now, if for some reason 44 00:03:07,000 --> 00:03:07,266 45 00:03:07,266 --> 00:03:12,466 this isn't showing up right here, you do also have the option to add chart elements over here. 46 00:03:12,466 --> 00:03:19,232 47 00:03:19,233 --> 00:03:25,833 And you can do a quick layout to quickly change how your chart appears. 48 00:03:25,833 --> 00:03:27,733 49 00:03:27,733 --> 00:03:29,799 We can also change the colors of our chart. 50 00:03:29,800 --> 00:03:35,466 51 00:03:35,466 --> 00:03:41,899 Let's make it lighter blue or maybe orange. 52 00:03:41,900 --> 00:03:47,933 Yeah, orange looks nice. We'll go with orange. We can also reselect our 53 00:03:47,933 --> 00:03:54,199 data. If we decide, oh shoot, this isn't the data that I wanted. You could 54 00:03:54,200 --> 00:03:54,233 55 00:03:54,233 --> 00:03:57,599 change it here. Let's say we want a DV instead. 56 00:03:57,600 --> 00:04:06,200 57 00:04:06,200 --> 00:04:11,933 Click ok and now we can see that our box plot has updated to select 58 00:04:11,933 --> 00:04:12,666 59 00:04:12,666 --> 00:04:18,666 DV instead of IV2. We can also change our chart type and 60 00:04:18,666 --> 00:04:18,699 61 00:04:18,700 --> 00:04:24,733 move our chart. So if you needed it to be on a different sheet, then you could select 62 00:04:24,733 --> 00:04:30,999 it and move it to a new sheet in your workbook. Generally 63 00:04:31,000 --> 00:04:31,033 64 00:04:31,033 --> 00:04:37,166 speaking, it's best to put your things in the sheets where they belong in the first place and not move things around 65 00:04:37,166 --> 00:04:37,199 66 00:04:37,200 --> 00:04:43,433 too much, but if you need to move something then you absolutely can. Okay, 67 00:04:43,433 --> 00:04:48,333 that's it. That's all you need to know about box plots to do your assignment. Have fun learning.