1
00:00:05,300 --> 00:00:05,850
Hello.

2
00:00:05,850 --> 00:00:07,733
I am Dr. Rick Jurors.

3
00:00:07,733 --> 00:00:09,983
This is a simple test video.

4
00:00:09,983 --> 00:00:12,750
I will use an average
recording environment.

5
00:00:12,750 --> 00:00:16,450
My MacBook Pro 2021 in my office.

6
00:00:16,950 --> 00:00:21,683
Click the data ribbon, then the
what if analysis tool and pick goal chic.

7
00:00:21,983 --> 00:00:26,366
The hardest part of using goal seekers
knowing how to fill out this dialog box.

8
00:00:26,633 --> 00:00:30,200
We want to set cell E 9 to 5 by varying

9
00:00:30,200 --> 00:00:34,916
cell E ten click
okay and goal sheet seeks that an answer

10
00:00:35,266 --> 00:00:39,083
which could take a little time
depending upon the speed of your computer.

11
00:00:39,300 --> 00:00:42,300
Goal sheet finds a solution. Click. Okay.

12
00:00:42,416 --> 00:00:43,366
Look at this.

13
00:00:43,366 --> 00:00:46,516
We would need a sample size of 110

14
00:00:46,650 --> 00:00:50,550
or 100
is not dramatically different than 107.

15
00:00:50,850 --> 00:00:55,316
Some would say just round up 107 to 150.

16
00:00:55,616 --> 00:00:58,950
But depending upon the cost of obtaining
samples,

17
00:00:59,266 --> 00:01:02,066
the difference could have a
significant cost difference.

18
00:01:03,166 --> 00:01:06,166
The quick
brown fox jumped over to Lazy Dog.

19
00:01:06,200 --> 00:01:11,066
The five boxing wizards jump quickly
packed my box with five dozen

20
00:01:11,066 --> 00:01:12,650
liquor jokes.

21
00:01:12,650 --> 00:01:15,716
Go lazy fat vixen, be shrewd

22
00:01:15,750 --> 00:01:18,866
jump quick when zombies arrive quickly

23
00:01:18,866 --> 00:01:24,533
Facts Judge Pat Amazingly few discotheques
provide jukeboxes

24
00:01:25,100 --> 00:01:28,516
puzzled women, bequests, jokes,
very exotic gifts.

25
00:01:29,150 --> 00:01:32,766
Brawny gods
just flocked up to quiz and vex him.

26
00:01:33,683 --> 00:01:37,516
Peter Piper picked up peck of pickled
peppers, a peck of pickled peppers.

27
00:01:37,516 --> 00:01:41,450
Peter Piper picked a Peter Piper picked up
peck of pickled peppers.

28
00:01:41,716 --> 00:01:44,766
Was the peck of pickled
peppers Peter Piper picked.