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,004
- [Instructor] One common goal
2
00:00:01,004 --> 00:00:02,007
of performing business data
3
00:00:02,007 --> 00:00:06,008
analysis is to discover relationships between values.
4
00:00:06,008 --> 00:00:09,008
For example, you might own a store and want to determine
5
00:00:09,008 --> 00:00:11,006
whether individuals who come to the store
6
00:00:11,006 --> 00:00:14,002
from farther away are more likely to spend money
7
00:00:14,002 --> 00:00:15,006
once we get there.
8
00:00:15,006 --> 00:00:17,001
If you've collected that data,
9
00:00:17,001 --> 00:00:19,009
you can summarize it visually using what is known
10
00:00:19,009 --> 00:00:22,001
as an XY scatter chart.
11
00:00:22,001 --> 00:00:22,009
In this movie,
12
00:00:22,009 --> 00:00:25,000
I will show you how to create one.
13
00:00:25,000 --> 00:00:26,007
In the exercise files collection,
14
00:00:26,007 --> 00:00:31,000
you will find an Excel workbook called, 20_02_XYScatter.
15
00:00:31,000 --> 00:00:32,004
And that's an Excel workbook
16
00:00:32,004 --> 00:00:36,001
that contains the data that I will use in this movie.
17
00:00:36,001 --> 00:00:37,000
As you can see,
18
00:00:37,000 --> 00:00:38,003
I have two columns of data.
19
00:00:38,003 --> 00:00:39,004
In column A,
20
00:00:39,004 --> 00:00:41,008
I have the distance a customer traveled.
21
00:00:41,008 --> 00:00:43,001
And in column B,
22
00:00:43,001 --> 00:00:46,001
I have the amount that customer spent.
23
00:00:46,001 --> 00:00:49,007
So you can see that in row 2,
24
00:00:49,007 --> 00:00:52,007
a customer that traveled one mile spent $35.
25
00:00:52,007 --> 00:00:57,000
And there was another within one mile who spent $13.
26
00:00:57,000 --> 00:00:58,007
And if we moved down the data set,
27
00:00:58,007 --> 00:01:00,002
which is sorted by distance,
28
00:01:00,002 --> 00:01:02,002
then we can see that it does appear
29
00:01:02,002 --> 00:01:05,003
that the farther away someone started from the store,
30
00:01:05,003 --> 00:01:07,005
that is the more they travel to get there,
31
00:01:07,005 --> 00:01:09,002
the more they're likely to spend.
32
00:01:09,002 --> 00:01:10,008
But let's see what it looks like
33
00:01:10,008 --> 00:01:12,005
in an XY scatter chart.
34
00:01:12,005 --> 00:01:13,008
To create your chart,
35
00:01:13,008 --> 00:01:17,001
click any cell in your data set,
36
00:01:17,001 --> 00:01:20,003
then go to the Insert tab.
37
00:01:20,003 --> 00:01:23,007
And in the Charts group,
38
00:01:23,007 --> 00:01:27,009
click the Insert Scatter (X,Y) or Bubble Chart button.
39
00:01:27,009 --> 00:01:30,004
And then at the top in the Scatter group,
40
00:01:30,004 --> 00:01:34,009
just click the first chart subtype.
41
00:01:34,009 --> 00:01:35,007
When you do,
42
00:01:35,007 --> 00:01:37,003
Excel creates an XY scatter chart.
43
00:01:37,003 --> 00:01:40,009
And you can see that there is a fairly strong relationship
44
00:01:40,009 --> 00:01:44,000
between distance traveled and amount spent.
45
00:01:44,000 --> 00:01:49,001
You can see distance on the horizontal or X axis
46
00:01:49,001 --> 00:01:53,002
and amount spent on the Y or vertical axis.
47
00:01:53,002 --> 00:01:55,002
There is a definite upward trend,
48
00:01:55,002 --> 00:01:56,007
although you can also see
49
00:01:56,007 --> 00:02:02,003
that one individual who traveled 45 miles only spent $35.
50
00:02:02,003 --> 00:02:03,006
But in general,
51
00:02:03,006 --> 00:02:07,000
the farther away someone started from your store,
52
00:02:07,000 --> 00:02:10,000
the more they spend when they get there.
53
00:02:10,000 --> 00:02:11,004
So it's important to remember
54
00:02:11,004 --> 00:02:14,007
that an XY scatter chart only works
55
00:02:14,007 --> 00:02:17,004
if you have two sets of numerical data
56
00:02:17,004 --> 00:02:19,008
that are matched as pairs.
57
00:02:19,008 --> 00:02:20,008
If you have, say,
58
00:02:20,008 --> 00:02:22,000
months of the year,
59
00:02:22,000 --> 00:02:25,004
then an XY scatter chart is probably not your best bet,
60
00:02:25,004 --> 00:02:27,003
because months are categorical data
61
00:02:27,003 --> 00:02:29,000
as opposed to numerical.
4484
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.