Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,004 --> 00:00:01,003
- [Instructor] Charts and graphs,
2
00:00:01,003 --> 00:00:03,006
let you summarize your data visually.
3
00:00:03,006 --> 00:00:06,001
In this movie, I will discuss and demonstrate
4
00:00:06,001 --> 00:00:09,009
how to create a specialized chart called a histogram.
5
00:00:09,009 --> 00:00:11,001
A histogram is a column chart
6
00:00:11,001 --> 00:00:13,005
that indicates the number of values that fall
7
00:00:13,005 --> 00:00:16,009
into a number of bins or value ranges.
8
00:00:16,009 --> 00:00:20,004
You can control the size of the bins and also the number.
9
00:00:20,004 --> 00:00:22,007
And you are able to select the bin,
10
00:00:22,007 --> 00:00:26,007
count, and size that works best for your data.
11
00:00:26,007 --> 00:00:28,001
Now let's switch over to Excel,
12
00:00:28,001 --> 00:00:30,001
and I will show you how to create histograms
13
00:00:30,001 --> 00:00:32,009
in that program.
14
00:00:32,009 --> 00:00:36,008
My sample file is 02_01_Histogram,
15
00:00:36,008 --> 00:00:39,000
and you can find it in the Chapter 2 folder
16
00:00:39,000 --> 00:00:41,006
of the exercise files collection.
17
00:00:41,006 --> 00:00:45,008
In column A, I have 50 values that I generated randomly
18
00:00:45,008 --> 00:00:49,006
that show hourly demand for a particular company.
19
00:00:49,006 --> 00:00:51,009
So you can see it starts in cell A-2.
20
00:00:51,009 --> 00:00:56,008
And if I scroll down, it ends in cell A-51.
21
00:00:56,008 --> 00:00:58,000
To create a histogram,
22
00:00:58,000 --> 00:00:59,006
like I showed you in the introduction,
23
00:00:59,006 --> 00:01:03,002
click any cell in your dataset.
24
00:01:03,002 --> 00:01:07,003
And then on the Insert tab of the ribbon,
25
00:01:07,003 --> 00:01:09,009
go to the Charts area.
26
00:01:09,009 --> 00:01:14,002
Click the Insert Statistic Chart icon.
27
00:01:14,002 --> 00:01:18,007
And in the top group, click Histogram on the left.
28
00:01:18,007 --> 00:01:24,001
And you can see that the histogram chart has been created.
29
00:01:24,001 --> 00:01:27,009
Excel decided based on its internal algorithm
30
00:01:27,009 --> 00:01:30,002
to create five bins,
31
00:01:30,002 --> 00:01:31,008
and you can see the counts.
32
00:01:31,008 --> 00:01:35,001
Between 40 and 60, we have two values.
33
00:01:35,001 --> 00:01:39,002
Between 64 and 88, there are 15.
34
00:01:39,002 --> 00:01:42,007
16 between 88 and 112.
35
00:01:42,007 --> 00:01:45,004
12 between 112 and 136.
36
00:01:45,004 --> 00:01:50,001
And it looks like we also have five between 136 and 160.
37
00:01:50,001 --> 00:01:53,003
If you want to edit the title, for example,
38
00:01:53,003 --> 00:01:56,009
you can go up and click the title.
39
00:01:56,009 --> 00:01:57,008
Select the text.
40
00:01:57,008 --> 00:02:03,004
And I'll call it "Hourly Demand" and click away.
41
00:02:03,004 --> 00:02:07,006
And I have edited the title of my histogram.
42
00:02:07,006 --> 00:02:09,002
Another way to edit a histogram
43
00:02:09,002 --> 00:02:12,000
is to change the size of the bins
44
00:02:12,000 --> 00:02:14,001
or their number.
45
00:02:14,001 --> 00:02:16,005
To do that, you want to right-click a value
46
00:02:16,005 --> 00:02:19,002
on the horizontal or X-axis.
47
00:02:19,002 --> 00:02:22,004
So I'll go down and when I have a tooltip
48
00:02:22,004 --> 00:02:26,004
that says Horizontal Axis, I will right-click.
49
00:02:26,004 --> 00:02:30,000
And then click Format Axis.
50
00:02:30,000 --> 00:02:32,007
The Format Axis task pane appears.
51
00:02:32,007 --> 00:02:35,001
And under Axis Options,
52
00:02:35,001 --> 00:02:38,008
you see that I can select either Bin width
53
00:02:38,008 --> 00:02:40,000
or Number of bins.
54
00:02:40,000 --> 00:02:42,004
I'll start with Bin width.
55
00:02:42,004 --> 00:02:44,001
It's currently set to 24.
56
00:02:44,001 --> 00:02:46,007
And let's say that I want to make my bins
57
00:02:46,007 --> 00:02:48,008
half that size or 12.
58
00:02:48,008 --> 00:02:52,009
So I will change the value.
59
00:02:52,009 --> 00:02:54,005
And I can make it a decimal if I want.
60
00:02:54,005 --> 00:02:56,008
But in this case, I'll just stay with 12.
61
00:02:56,008 --> 00:02:58,003
And press Enter.
62
00:02:58,003 --> 00:03:01,004
And there you see my bins.
63
00:03:01,004 --> 00:03:05,008
And the data distribution takes on a little bit more detail.
64
00:03:05,008 --> 00:03:10,009
You can see that I have one value between 40 and 52.
65
00:03:10,009 --> 00:03:14,002
And a single value also between 52 and 64,
66
00:03:14,002 --> 00:03:17,005
instead of having two values between 40 and 64.
67
00:03:17,005 --> 00:03:19,005
So it's a little more detail.
68
00:03:19,005 --> 00:03:22,000
If you want to change the number of bins,
69
00:03:22,000 --> 00:03:26,007
then you can go back over to the Format Axis task pane.
70
00:03:26,007 --> 00:03:29,002
Select that ratio button.
71
00:03:29,002 --> 00:03:31,008
And let's say that I want to have eight bins.
72
00:03:31,008 --> 00:03:34,003
So instead of 10,
73
00:03:34,003 --> 00:03:36,004
or five like I had at the start,
74
00:03:36,004 --> 00:03:39,006
I'll type eight, press Enter.
75
00:03:39,006 --> 00:03:41,000
And there I have my bins.
76
00:03:41,000 --> 00:03:45,000
And you can see here that I have my decimal values.
77
00:03:45,000 --> 00:03:48,005
And if I drag the histogram chart,
78
00:03:48,005 --> 00:03:51,003
then I get the values written horizontally,
79
00:03:51,003 --> 00:03:52,008
although still offset a little
80
00:03:52,008 --> 00:03:54,005
because the chart isn't quite wide enough
81
00:03:54,005 --> 00:03:58,000
to fit all the values straight across.
82
00:03:58,000 --> 00:04:00,000
Using histograms is a great way
83
00:04:00,000 --> 00:04:02,005
to look at the distribution of your data.
84
00:04:02,005 --> 00:04:05,001
If you care about values that fall within certain ranges,
85
00:04:05,001 --> 00:04:07,000
histograms are a great way to go.
6398
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.