1
00:00:00,142 --> 00:00:02,725
(smooth music)

2
00:00:05,003 --> 00:00:07,830
- [Dr. Jerz] Hello, I am Dr. Rick Jerz

3
00:00:07,830 --> 00:00:10,050
This is a simple test video.

4
00:00:10,050 --> 00:00:12,840
I will use an average
recording environment

5
00:00:12,840 --> 00:00:17,070
my MacBook Pro 2021 in my office.

6
00:00:17,070 --> 00:00:20,310
Click the data ribbon, then
the What If analysis tool

7
00:00:20,310 --> 00:00:22,080
and pick goal seek.

8
00:00:22,080 --> 00:00:24,120
The hardest part of using goal seek

9
00:00:24,120 --> 00:00:26,760
is knowing how to fill
out this dialogue box.

10
00:00:26,760 --> 00:00:31,760
We want to set cell E9 to
five by varying cell E10.

11
00:00:31,830 --> 00:00:35,370
Click OK, and goal seek seeks the answer

12
00:00:35,370 --> 00:00:37,680
which could take a little
time depending upon

13
00:00:37,680 --> 00:00:39,360
the speed of your computer.

14
00:00:39,360 --> 00:00:41,220
Goal seek finds a solution.

15
00:00:41,220 --> 00:00:42,510
Click OK.

16
00:00:42,510 --> 00:00:43,500
Look at this.

17
00:00:43,500 --> 00:00:46,740
We would need a sample size of 110.

18
00:00:46,740 --> 00:00:50,910
100 is not dramatically
different than 107.

19
00:00:50,910 --> 00:00:55,740
Some would say just round up 107 to 150.

20
00:00:55,740 --> 00:00:59,400
But depending upon the
cost of obtaining samples

21
00:00:59,400 --> 00:01:03,270
the difference could have a
significant cost difference.

22
00:01:03,270 --> 00:01:06,300
The quick brown fox
jumped over the lazy dog.

23
00:01:06,300 --> 00:01:09,360
The five boxing wizards jump quickly.

24
00:01:09,360 --> 00:01:12,750
Pack my box with five dozen liquor jugs.

25
00:01:12,750 --> 00:01:17,220
Go, lazy fat vixen, be shrewd, jump quick.

26
00:01:17,220 --> 00:01:20,940
When zombies arrive,
quickly fax Judge Pat.

27
00:01:20,940 --> 00:01:25,200
Amazingly, a few discotheques
provide jukeboxes.

28
00:01:25,200 --> 00:01:29,250
Puzzled women bequest
jerks very exotic gifts.

29
00:01:29,250 --> 00:01:33,780
Brawny gods just flocked
up to quiz and vex him.

30
00:01:33,780 --> 00:01:36,330
Peter Piper picked a
peck of pickled peppers

31
00:01:36,330 --> 00:01:39,000
a peck of pickled peppers
Peter Piper picked,

32
00:01:39,000 --> 00:01:41,790
if Peter Piper picked a
peck of pickled peppers,

33
00:01:41,790 --> 00:01:45,063
where's the peck of pickled
peppers Peter Piper picked?