1
00:00:01,020 --> 00:00:03,199
foreign

2
00:00:03,790 --> 00:00:06,860
[Music]

3
00:00:07,400 --> 00:00:13,200
this is a simple test video I will use

4
00:00:10,800 --> 00:00:17,580
an average recording environment my

5
00:00:13,200 --> 00:00:19,859
MacBook Pro 2021 in my office click the

6
00:00:17,580 --> 00:00:22,980
data ribbon then the what-if analysis

7
00:00:19,859 --> 00:00:24,960
tool and pick goal seek the hardest part

8
00:00:22,980 --> 00:00:27,840
of using goal seek is knowing how to

9
00:00:24,960 --> 00:00:32,279
fill out this dialog box we want to set

10
00:00:27,840 --> 00:00:35,880
cell E9 to 5 by varying cell E10 click

11
00:00:32,279 --> 00:00:37,800
OK and goal seek seeks an answer which

12
00:00:35,880 --> 00:00:40,140
could take a little time depending upon

13
00:00:37,800 --> 00:00:43,320
the speed of your computer goal seek

14
00:00:40,140 --> 00:00:47,280
finds a solution click OK look at this

15
00:00:43,320 --> 00:00:50,460
we would need a sample size of 110 100

16
00:00:47,280 --> 00:00:55,440
is not dramatically different than 107

17
00:00:50,460 --> 00:00:58,440
some would say just Round Up 107 to 150

18
00:00:55,440 --> 00:01:00,780
but depending upon the cost of obtaining

19
00:00:58,440 --> 00:01:03,300
samples the difference could have a

20
00:01:00,780 --> 00:01:05,700
significant cost difference

21
00:01:03,300 --> 00:01:08,880
a quick brown fox jumped over the lazy

22
00:01:05,700 --> 00:01:12,659
dog the five boxing Wizards jump quickly

23
00:01:08,880 --> 00:01:16,700
pack my box with five dozen liquor drugs

24
00:01:12,659 --> 00:01:20,040
go lazy fat vexen be shrewd jump quick

25
00:01:16,700 --> 00:01:23,640
when zombies arrive quickly facts judge

26
00:01:20,040 --> 00:01:25,140
Pat amazingly few discotechs provide

27
00:01:23,640 --> 00:01:28,080
jukeboxes

28
00:01:25,140 --> 00:01:29,100
puzzled women bequest jerks very exotic

29
00:01:28,080 --> 00:01:32,280
gifts

30
00:01:29,100 --> 00:01:33,720
brawny Gods just flocked up to quiz and

31
00:01:32,280 --> 00:01:35,579
vexim

32
00:01:33,720 --> 00:01:38,040
Peter Piper picked a peck of pickled

33
00:01:35,579 --> 00:01:40,320
peppers A peck of pickled peppers Peter

34
00:01:38,040 --> 00:01:42,720
Piper picked if Peter Piper picked a

35
00:01:40,320 --> 00:01:46,820
peck of pickled peppers where's the peck

36
00:01:42,720 --> 00:01:46,820
of pickled peppers Peter Piper picked