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:05,002
(upbeat music)
2
00:00:05,002 --> 00:00:06,005
- [Instructor] To close out this chapter,
3
00:00:06,005 --> 00:00:08,008
I would like to ask you to practice some
4
00:00:08,008 --> 00:00:11,003
of the skills that you have learned.
5
00:00:11,003 --> 00:00:12,009
In this workbook named,
6
00:00:12,009 --> 00:00:14,002
Chapter_2_Challenge,
7
00:00:14,002 --> 00:00:15,000
which you can find
8
00:00:15,000 --> 00:00:18,004
in the chapter two folder of your exercise files collection,
9
00:00:18,004 --> 00:00:19,005
I have set up a workbook
10
00:00:19,005 --> 00:00:22,007
and I would like you to perform three tasks.
11
00:00:22,007 --> 00:00:26,006
The first in column D is to calculate a running average
12
00:00:26,006 --> 00:00:29,003
for sales data that is found
13
00:00:29,003 --> 00:00:31,002
in column C.
14
00:00:31,002 --> 00:00:33,006
To remind you what a running average is,
15
00:00:33,006 --> 00:00:35,006
in cell D5,
16
00:00:35,006 --> 00:00:37,001
you would calculate the average
17
00:00:37,001 --> 00:00:41,000
for cells C4 and C5.
18
00:00:41,000 --> 00:00:46,004
In D6, it would be C4 through C6 and so on.
19
00:00:46,004 --> 00:00:50,004
Then I would like you to create a histogram based
20
00:00:50,004 --> 00:00:51,005
on sales data,
21
00:00:51,005 --> 00:00:54,006
which divides daily sales
22
00:00:54,006 --> 00:00:56,000
into a number of bins.
23
00:00:56,000 --> 00:00:59,001
And then also to create an XY scatter chart
24
00:00:59,001 --> 00:01:02,001
that would indicate the relationship, if any,
25
00:01:02,001 --> 00:01:05,005
between the number of customers in column B
26
00:01:05,005 --> 00:01:11,002
and the corresponding sales level in column C.
27
00:01:11,002 --> 00:01:12,000
With that in mind,
28
00:01:12,000 --> 00:01:14,003
go ahead and perform these tasks.
29
00:01:14,003 --> 00:01:16,004
And I will come back in the next movie
30
00:01:16,004 --> 00:01:18,000
and show you one way to solve it.
2130
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.