Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,003 --> 00:00:01,008
- [Instructor] One of the most important pieces
2
00:00:01,008 --> 00:00:03,005
of information you can learn about
3
00:00:03,005 --> 00:00:06,002
your business operations is how long it takes
4
00:00:06,002 --> 00:00:08,002
to perform a specific task.
5
00:00:08,002 --> 00:00:10,008
For example, if you repair phone screens,
6
00:00:10,008 --> 00:00:13,004
you might find that the average time
7
00:00:13,004 --> 00:00:16,007
to repair is five minutes.
8
00:00:16,007 --> 00:00:19,004
You can use the exponential distribution using
9
00:00:19,004 --> 00:00:22,007
that average of five denoted here by lambda,
10
00:00:22,007 --> 00:00:25,004
as part of the exponential distribution
11
00:00:25,004 --> 00:00:30,000
to determine the probability of a specific time.
12
00:00:30,000 --> 00:00:31,004
This is what the graph looks like.
13
00:00:31,004 --> 00:00:34,002
And it may seem odd that the average time
14
00:00:34,002 --> 00:00:39,000
of five only occurs about 7% of the time.
15
00:00:39,000 --> 00:00:40,005
And the reason that's the case is
16
00:00:40,005 --> 00:00:44,005
because there is the possibility of long times,
17
00:00:44,005 --> 00:00:47,008
for example 20 or 25 minutes.
18
00:00:47,008 --> 00:00:51,004
However, those long duration repairs are offset
19
00:00:51,004 --> 00:00:53,002
by the much higher probability
20
00:00:53,002 --> 00:00:56,004
of having a repair taking one, two, three, four,
21
00:00:56,004 --> 00:00:58,008
or five minutes.
22
00:00:58,008 --> 00:01:00,003
To see how this works in Excel,
23
00:01:00,003 --> 00:01:04,003
I will switch over to our sample workbook.
24
00:01:04,003 --> 00:01:06,007
I have opened our Excel sample file
25
00:01:06,007 --> 00:01:09,006
and that is 04_03_Exponential.
26
00:01:09,006 --> 00:01:12,001
You can find that in the Chapter Four folder
27
00:01:12,001 --> 00:01:14,007
of the Exercise Files collection.
28
00:01:14,007 --> 00:01:19,001
I have the average time, or lambda, in cell E1,
29
00:01:19,001 --> 00:01:22,001
and I also have a table on the left
30
00:01:22,001 --> 00:01:23,009
that will let me calculate the probability
31
00:01:23,009 --> 00:01:28,004
of a specific number of minutes for a repair.
32
00:01:28,004 --> 00:01:31,007
So I'll click in cell B2, type an equal sign,
33
00:01:31,007 --> 00:01:35,001
and I will use the exponential distribution function,
34
00:01:35,001 --> 00:01:40,003
that is expon.dist.
35
00:01:40,003 --> 00:01:42,000
First, I need to know my X,
36
00:01:42,000 --> 00:01:43,007
that is the value that I'm comparing.
37
00:01:43,007 --> 00:01:48,002
So that's in cell A2, for this particular calculation,
38
00:01:48,002 --> 00:01:49,006
then a comma.
39
00:01:49,006 --> 00:01:55,000
The lambda is in cell E1, but I need to use one divided
40
00:01:55,000 --> 00:01:57,007
by lambda, and that is a characteristic
41
00:01:57,007 --> 00:01:59,009
of the exponential distribution.
42
00:01:59,009 --> 00:02:02,007
If you don't divide one by lambda,
43
00:02:02,007 --> 00:02:04,005
you will get very strange results.
44
00:02:04,005 --> 00:02:09,009
So in cell B2, I'll type one divided by E1.
45
00:02:09,009 --> 00:02:15,001
And because I want this value to remain constant,
46
00:02:15,001 --> 00:02:16,007
the cell reference remain constant,
47
00:02:16,007 --> 00:02:22,005
I'll press F4 on Windows, it's Command-T on the Mac,
48
00:02:22,005 --> 00:02:25,001
then a comma, and I am looking
49
00:02:25,001 --> 00:02:29,001
for the probability density function or point probability,
50
00:02:29,001 --> 00:02:32,004
so I will highlight false for this final argument,
51
00:02:32,004 --> 00:02:36,000
Press Tab, right parentheses and Enter.
52
00:02:36,000 --> 00:02:42,002
And I get a probability of about 0.1637.
53
00:02:42,002 --> 00:02:46,005
I can now copy this formula down to the remaining cells.
54
00:02:46,005 --> 00:02:49,003
So I will click cell B2
55
00:02:49,003 --> 00:02:51,000
and then double-click the fill handle
56
00:02:51,000 --> 00:02:52,008
at the bottom right corner.
57
00:02:52,008 --> 00:02:55,004
I know that my mouse pointer's in the right place
58
00:02:55,004 --> 00:02:58,003
when it changes to a black cross, double-click,
59
00:02:58,003 --> 00:03:02,006
and you can see that the formula has been copied down.
60
00:03:02,006 --> 00:03:05,007
And I see the individual probabilities.
61
00:03:05,007 --> 00:03:09,009
Now let's say that I want to calculate the probability
62
00:03:09,009 --> 00:03:13,001
of getting a value between three and seven.
63
00:03:13,001 --> 00:03:16,008
So I have already calculated my probabilities
64
00:03:16,008 --> 00:03:20,002
for three here, and then seven here,
65
00:03:20,002 --> 00:03:23,001
but because their point probabilities, I can't use them.
66
00:03:23,001 --> 00:03:26,004
I need to use the cumulative function.
67
00:03:26,004 --> 00:03:32,006
So I will go to cell E3, and then type an equal sign,
68
00:03:32,006 --> 00:03:35,006
and I'm going to subtract the probability
69
00:03:35,006 --> 00:03:37,009
of getting three or less from the probability
70
00:03:37,009 --> 00:03:40,002
of getting seven or less.
71
00:03:40,002 --> 00:03:44,004
So I'll start by calculating the value for seven,
72
00:03:44,004 --> 00:03:47,005
that is the cumulative probability of getting seven or less.
73
00:03:47,005 --> 00:03:55,001
So that's expon.dist, the value is seven, lambda,
74
00:03:55,001 --> 00:03:58,003
and again, it needs to be one divided by lambda,
75
00:03:58,003 --> 00:04:00,000
that's in E1.
76
00:04:00,000 --> 00:04:01,009
I'm not going to copy the formula, so I won't worry
77
00:04:01,009 --> 00:04:04,008
about a cell reference, and it is cumulative.
78
00:04:04,008 --> 00:04:08,007
So I will highlight true, which it already is,
79
00:04:08,007 --> 00:04:13,000
and then press Tab to get that, then right parentheses
80
00:04:13,000 --> 00:04:15,006
and I will subtract the same calculation
81
00:04:15,006 --> 00:04:16,006
for the number three.
82
00:04:16,006 --> 00:04:19,002
I'll go through it a little bit more quickly.
83
00:04:19,002 --> 00:04:24,006
Exponential distribution, three, one divided by E1,
84
00:04:24,006 --> 00:04:29,006
comma, cumulative true, right parentheses and Enter.
85
00:04:29,006 --> 00:04:33,001
And I get 30.22%.
86
00:04:33,001 --> 00:04:34,006
So the probability of getting a value
87
00:04:34,006 --> 00:04:39,001
between three and seven, inclusive, is 30.22%,
88
00:04:39,001 --> 00:04:40,009
or about a the third of the time.
89
00:04:40,009 --> 00:04:44,000
And that makes sense with an average of five.
7053
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.