Thread: solver
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis
 
Posts: n/a
Default solver

Hi. I made some quick charts. However, I will not be able to post them as
the file size is about 100k.
Let me know, and I will email them to you. I put them into PDF format to
make it easier.

For the second problem:

Solver could not find the solution for the case
p1=.01, p2=.05,alpha=.05, beta=.10.
The solution, found by trial and error,
is c=3, n=110.


I show this to be an invalid solution with the second equation.
I "think" that c=3 is correct, but the valid range of n
is 132 to 137. Do you show n=110 to be correct?
Anyway, let me know and I'll be glad to send it to you.

As a side note, the reason Solver will not work with this is due to
"BINOMDIST" function being a discontinuous function.
What I mean is that for example...Solver tries n=100.1
=BINOMDIST(3, 100.1, 0.01, TRUE)
The answer is 0.9816
Next, Solver will try n=100.9

=BINOMDIST(3, 100.9, 0.01, TRUE)
The answer is the same! 0.9816

Because Solver changed n, and the output did not change, Solver does not
know how to proceed to the next guess. Solver is not very sophisticated,
and quickly gives up.

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003

"John" wrote in message
ups.com...
Dana,

Thank you for your helpful comments. I am looking for a solution, and a
graphical solution that works is perfectly acceptable. Do you mind
telling me what you plotted?

John Adams