BINOMDIST

G

gldtkn77gary

How do I create a table using the BINOMDIST function? I have a hypothetical situation in which I have to determine the probability of shipping a lot for different lot qualities from 0 to 1 in increments of 0.05?
 
P

Paul

gldtkn77gary said:
How do I create a table using the BINOMDIST function? I have a
Click to expand...
hypothetical situation in which I have to determine the probability of
shipping a lot for different lot qualities from 0 to 1 in increments of
0.05?

The definition of BINOMDIST parameters is described in Help:
BINOMDIST(number_s,trials,probability_s,cumulative)

If you want a table for different values of any parameter, list these values
in column A, write the formula in B1 referring to the parameter in A1, and
copy down column B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - (re-) Set a Table Style 2
Help with long if then statement 1
Re 'BINOMDIST' function 3
Excel - Wich Function should I use? 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Basic Statistics 4
IF formula 4
Repeating a row other than the 1st row as the header row in a table from next page 1

Top