(smooth music)
- [Dr. Jerz] Hello, I am Dr. Rick Jerz
This is a simple test video.
I will use an average recording environment
my MacBook Pro 2021 in my office.
Click the data ribbon, then the What If analysis tool
and pick goal seek.
The hardest part of using goal seek
is knowing how to fill out this dialogue box.
We want to set cell E9 to five by varying cell E10.
Click OK, and goal seek seeks the answer
which could take a little time depending upon
the speed of your computer.
Goal seek finds a solution.
Click OK.
Look at this.
We would need a sample size of 110.
100 is not dramatically different than 107.
Some would say just round up 107 to 150.
But depending upon the cost of obtaining samples
the difference could have a significant cost difference.
The quick brown fox jumped over the lazy dog.
The five boxing wizards jump quickly.
Pack my box with five dozen liquor jugs.
Go, lazy fat vixen, be shrewd, jump quick.
When zombies arrive, quickly fax Judge Pat.
Amazingly, a few discotheques provide jukeboxes.
Puzzled women bequest jerks very exotic gifts.
Brawny gods just flocked up to quiz and vex him.
Peter Piper picked a peck of pickled peppers
a peck of pickled peppers Peter Piper picked,
if Peter Piper picked a peck of pickled peppers,
where's the peck of pickled peppers Peter Piper picked?