Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,002 --> 00:00:02,003
- [Instructor] When you analyze business data,
2
00:00:02,003 --> 00:00:05,006
you will often need to select a subset
3
00:00:05,006 --> 00:00:08,009
of a larger collection of items.
4
00:00:08,009 --> 00:00:09,009
When the order matters,
5
00:00:09,009 --> 00:00:13,004
you are dealing with what are called permutation.
6
00:00:13,004 --> 00:00:15,001
As an example, let's assume
7
00:00:15,001 --> 00:00:17,000
that you have eight individuals
8
00:00:17,000 --> 00:00:19,008
who have offered to speak at a company event,
9
00:00:19,008 --> 00:00:22,007
but you can only choose three.
10
00:00:22,007 --> 00:00:25,008
If the order those individual speak in matters,
11
00:00:25,008 --> 00:00:28,007
then you're dealing with a permutation.
12
00:00:28,007 --> 00:00:32,001
And again, the order of these speakers matters.
13
00:00:32,001 --> 00:00:34,008
So instead of having 1, 2, 3,
14
00:00:34,008 --> 00:00:40,002
if you have the speakers set up as 2, 3, 1,
15
00:00:40,002 --> 00:00:43,005
then you are dealing with a different permutation.
16
00:00:43,005 --> 00:00:46,004
And once again, order matters.
17
00:00:46,004 --> 00:00:47,005
One question you can ask
18
00:00:47,005 --> 00:00:50,003
about permutations without duplication
19
00:00:50,003 --> 00:00:52,008
is how many unique orders are possible
20
00:00:52,008 --> 00:00:57,003
when choosing three out of eight people with no repeats?
21
00:00:57,003 --> 00:00:58,008
I'll switch over to Excel
22
00:00:58,008 --> 00:01:01,000
and show you how to set up this type of problem
23
00:01:01,000 --> 00:01:03,002
in your workbook.
24
00:01:03,002 --> 00:01:04,008
I've switched over to Excel,
25
00:01:04,008 --> 00:01:08,001
and I have opened the sample file for this movie,
26
00:01:08,001 --> 00:01:12,001
that is, 06_04 Permutations Without Duplication,
27
00:01:12,001 --> 00:01:14,001
and you can find that in the Chapter06 folder
28
00:01:14,001 --> 00:01:16,009
of the Exercise Files collection.
29
00:01:16,009 --> 00:01:20,001
You can see, this is a fairly straightforward worksheet.
30
00:01:20,001 --> 00:01:25,004
And in cells B3 and B4, I have the values that I need.
31
00:01:25,004 --> 00:01:28,004
So in B3, I have the number of available speakers,
32
00:01:28,004 --> 00:01:33,009
and in cell B4, I have the number of open speaking slots.
33
00:01:33,009 --> 00:01:36,004
If I want to count the number of unique orders
34
00:01:36,004 --> 00:01:39,001
without duplication, that is my permutation,
35
00:01:39,001 --> 00:01:43,005
I can go to sell B6, type an equal sign,
36
00:01:43,005 --> 00:01:46,008
and the function
37
00:01:46,008 --> 00:01:49,005
is P-E-R-M-U-T,
38
00:01:49,005 --> 00:01:52,000
which is short for permutation.
39
00:01:52,000 --> 00:01:53,004
So I'll press Tab.
40
00:01:53,004 --> 00:01:57,006
And the number of available speakers is in cell B3,
41
00:01:57,006 --> 00:02:00,003
so I'll type that cell reference, then a comma.
42
00:02:00,003 --> 00:02:03,008
And the number chosen, the number of open speaking slots,
43
00:02:03,008 --> 00:02:05,007
is in B4.
44
00:02:05,007 --> 00:02:08,001
Type a right parentheses and Enter.
45
00:02:08,001 --> 00:02:11,002
And I see that there are actually quite a few orders
46
00:02:11,002 --> 00:02:14,001
that are possible, 336.
47
00:02:14,001 --> 00:02:17,001
If I were to increase the number of available speakers,
48
00:02:17,001 --> 00:02:20,001
then that number would increase even more.
49
00:02:20,001 --> 00:02:23,001
So in cell B3, let's say that I go up to 10,
50
00:02:23,001 --> 00:02:25,004
which is only an increase of two.
51
00:02:25,004 --> 00:02:30,000
We go from 336 to 720.
52
00:02:30,000 --> 00:02:32,003
So that is quite an increase.
53
00:02:32,003 --> 00:02:34,000
If I change the value in B4,
54
00:02:34,000 --> 00:02:36,009
the number of speaking slots to 5,
55
00:02:36,009 --> 00:02:41,006
we go from 720 up to over 30,000.
56
00:02:41,006 --> 00:02:44,008
So as you can see, even at fairly small numbers,
57
00:02:44,008 --> 00:02:49,000
such as 10 available speakers in 5 open speaking slots,
58
00:02:49,000 --> 00:02:51,007
the number of permutations without duplication
59
00:02:51,007 --> 00:02:54,000
gets very large, very fast.
4543
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Akan
Albanian
Amharic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof