1
00:00:00,000 --> 00:00:01,466


2
00:00:01,466 --> 00:00:07,566
Hello and welcome to a video on making histograms in Excel. Today we'll be going over two different

3
00:00:07,566 --> 00:00:13,699
ways you can make a histogram in Excel and we'll be using the data from our class data set that we've already

4
00:00:13,700 --> 00:00:13,733


5
00:00:13,733 --> 00:00:20,366
made. So today let's make a histogram

6
00:00:20,366 --> 00:00:26,466
of DV and the first method that I'm going to show you for making a histogram involves selecting all

7
00:00:26,466 --> 00:00:26,599


8
00:00:26,600 --> 00:00:27,566
of your data and then

9
00:00:27,566 --> 00:00:35,099


10
00:00:35,100 --> 00:00:41,333
I'm going to scroll back up to the top so that my histogram appears near the top of our assignment.

11
00:00:41,333 --> 00:00:42,233


12
00:00:42,233 --> 00:00:48,699
Hit insert. Select the histogram or insert statistics

13
00:00:48,700 --> 00:00:48,733


14
00:00:48,733 --> 00:00:54,666
chart button and there will be a histogram option underneath it. You want the first one.

15
00:00:54,666 --> 00:00:56,799


16
00:00:56,800 --> 00:01:01,033
Okay. That is a histogram. We're going to call this example

17
00:01:01,033 --> 00:01:03,966


18
00:01:03,966 --> 00:01:08,566
A. Now there are a couple things we can do with our histogram to customize it.

19
00:01:08,566 --> 00:01:11,632


20
00:01:11,633 --> 00:01:17,766
We go to chart design. We can see we have the same options that we did for our

21
00:01:17,766 --> 00:01:22,932
box and whisker plot where we can change the data that we use, change the chart type,

22
00:01:22,933 --> 00:01:23,866


23
00:01:23,866 --> 00:01:25,832
change the way the chart looks.

24
00:01:25,833 --> 00:01:30,433


25
00:01:30,433 --> 00:01:35,333
Let's stick with the classic for now. We can change the colors on our chart.

26
00:01:35,333 --> 00:01:47,133


27
00:01:47,133 --> 00:01:48,166
Let's go for this red.

28
00:01:48,166 --> 00:01:53,166


29
00:01:53,166 --> 00:01:58,499
We can also add elements like axis titles. Let's go ahead and add

30
00:01:58,500 --> 00:02:00,366


31
00:02:00,366 --> 00:02:06,399
a vertical and horizontal axis title. We can add data labels if we

32
00:02:06,400 --> 00:02:06,433


33
00:02:06,433 --> 00:02:07,033
want to.

34
00:02:07,033 --> 00:02:12,566


35
00:02:12,566 --> 00:02:15,699
In this case, let's put them at the inside on the end.

36
00:02:15,700 --> 00:02:20,000


37
00:02:20,000 --> 00:02:26,233
We could have grid lines if we wanted. Let's

38
00:02:26,233 --> 00:02:27,466
go for no grid lines.

39
00:02:27,466 --> 00:02:37,299


40
00:02:37,300 --> 00:02:43,366
There we go. If you hit more options, it will give you

41
00:02:43,366 --> 00:02:43,399


42
00:02:43,400 --> 00:02:49,633
more grid line options that open up your whole grid line option bar. So, we could have solid lines, gradient

43
00:02:49,633 --> 00:02:54,966
lines, automatic, which is just solid. In this case, we want no lines.

44
00:02:54,966 --> 00:03:00,199


45
00:03:00,200 --> 00:03:06,266
We could also have a legend, which tells us what the variable is that we're making a histogram for.

46
00:03:06,266 --> 00:03:07,099


47
00:03:07,100 --> 00:03:12,566
We're going to go with them. Because in this case, we're going to make our

48
00:03:12,566 --> 00:03:13,132


49
00:03:13,133 --> 00:03:19,366
chart title, histogram

50
00:03:19,366 --> 00:03:19,399


51
00:03:19,400 --> 00:03:25,566
of DV. Okay. Now, if we wanted

52
00:03:25,566 --> 00:03:30,366
to change the number of bins, we could do that here on our x-axis.

53
00:03:30,366 --> 00:03:31,899


54
00:03:31,900 --> 00:03:38,133
There are numbers that tell us what the bins are. And what number between what

55
00:03:38,133 --> 00:03:38,166


56
00:03:38,166 --> 00:03:44,366
number they go to. If we right-click on that

57
00:03:44,366 --> 00:03:50,466
and click format x-axis, then we'll get x-axis options, including

58
00:03:50,466 --> 00:03:54,932
number of bins. So if we have a specific number of bins that we need to have, say 12,

59
00:03:54,933 --> 00:03:56,999


60
00:03:57,000 --> 00:04:00,033
then we can now have 12 bins on our histogram.

61
00:04:00,033 --> 00:04:05,366


62
00:04:05,366 --> 00:04:09,666
Let's change it back to the automatic.

63
00:04:09,666 --> 00:04:13,599


64
00:04:13,600 --> 00:04:20,000
There is a second way to make a histogram. And this involves using the data analysis tool pack.

65
00:04:20,000 --> 00:04:20,366


66
00:04:20,366 --> 00:04:26,699
If you don't have the data analysis tool pack installed, please see the video specifically for installing that data analysis

67
00:04:26,700 --> 00:04:32,300
tool pack. But once you have it, you'll go to data, click data analysis.

68
00:04:32,300 --> 00:04:37,666


69
00:04:37,666 --> 00:04:42,532
This might be taking a moment to load. There we go. Histogram,

70
00:04:42,533 --> 00:04:44,133


71
00:04:44,133 --> 00:04:49,599
you may have to scroll down a little bit for it, but it'll be right here. Click OK.

72
00:04:49,600 --> 00:04:51,833


73
00:04:51,833 --> 00:04:55,233
And now I've already got some data selected from our previous

74
00:04:55,233 --> 00:04:57,899


75
00:04:57,900 --> 00:05:03,400
project I was working on. So I'm going to go ahead and select DV because we want the same histogram. Again,

76
00:05:03,400 --> 00:05:04,266


77
00:05:04,266 --> 00:05:10,599
for our example, I'm going to click

78
00:05:10,600 --> 00:05:10,633


79
00:05:10,633 --> 00:05:16,566
Labels because I have included the Label DV.

80
00:05:16,566 --> 00:05:18,632


81
00:05:18,633 --> 00:05:23,933
Our output range will be right here.

82
00:05:23,933 --> 00:05:26,766


83
00:05:26,766 --> 00:05:33,099
We're going to select Chart Output because we want a chart when we output our histogram. Otherwise,

84
00:05:33,100 --> 00:05:33,566


85
00:05:33,566 --> 00:05:36,632
we won't get an image of our histogram.

86
00:05:36,633 --> 00:05:41,066


87
00:05:41,066 --> 00:05:46,232
There we go. Now you can see it's created a set of bins for

88
00:05:46,233 --> 00:05:47,066


89
00:05:47,066 --> 00:05:51,632
us for DV. And it's given us this small chart.

90
00:05:51,633 --> 00:05:53,466


91
00:05:53,466 --> 00:05:57,432
The first thing I like to do is go ahead and make this chart a little bigger.

92
00:05:57,433 --> 00:06:01,433


93
00:06:01,433 --> 00:06:07,466
And now, one of the main differences between histograms and bar charts is that bar charts have spaces

94
00:06:07,466 --> 00:06:13,466
and histograms do not. So we want to fix this. So that there's no spaces in

95
00:06:13,466 --> 00:06:19,599
between our bars. To do that, you click on series options, go to gap

96
00:06:19,600 --> 00:06:20,233


97
00:06:20,233 --> 00:06:26,233
width and set that to zero. And now we have a histogram with no

98
00:06:26,233 --> 00:06:31,866
spaces between the bars. Perfect.

99
00:06:31,866 --> 00:06:33,766


100
00:06:33,766 --> 00:06:37,832
We can see the shape of our distribution very nicely in both of them.

101
00:06:37,833 --> 00:06:39,966


102
00:06:39,966 --> 00:06:44,232
You can also change your title,

103
00:06:44,233 --> 00:06:49,566


104
00:06:49,566 --> 00:06:52,899
your labels,

105
00:06:52,900 --> 00:07:00,833


106
00:07:00,833 --> 00:07:03,266
and you can change colors if you want to.

107
00:07:03,266 --> 00:07:18,099


108
00:07:18,100 --> 00:07:23,533
So long as your histogram is able to be viewed and you can see the shape of the distribution,

109
00:07:23,533 --> 00:07:24,166


110
00:07:24,166 --> 00:07:31,132
then it will be fine. We also need to make sure that we have titles, axis labels,

111
00:07:31,133 --> 00:07:34,099


112
00:07:34,100 --> 00:07:40,633
and enough bins that we can see the shape of the distribution, or the number of bins that we've asked for in your assignment.

113
00:07:40,633 --> 00:07:42,099


114
00:07:42,100 --> 00:07:44,566
Okay, good luck and have fun using Excel!