Plotting a binomial distribution formulae in excel?
 

Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)

What are you looking to use as your variable? n,k, or p?

--
Regards,
Dave


"Knowledge001" wrote:

Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)

Use a compter (excel) to plot the binomial distribution as a function of k
for n=50, and p=0.7

"David Billigmeier" wrote:

What are you looking to use as your variable? n,k, or p?

--
Regards,
Dave


"Knowledge001" wrote:

Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)

By the way, you have the binomial distribution formula wrong, it's:
(N choose K)(p^K)(1-p)^(n-k)

But to answer your question, place this formula in A1 and drag down to row
50, then select the range A1:A50 and graph:

=COMBIN(50,ROW())*(0.7^ROW())*(0.3^(50-ROW()))


--
Regards,
Dave


"Knowledge001" wrote:

Use a compter (excel) to plot the binomial distribution as a function of k
for n=50, and p=0.7

"David Billigmeier" wrote:

What are you looking to use as your variable? n,k, or p?

--
Regards,
Dave


"Knowledge001" wrote:

Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)

"Knowledge001" wrote:

Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p) plot the binomial distrbution as a function of k for n=50, and p=0.7

Maybe you could use the BINOMDIST worksheet function to get values on a
worksheet and then create a Column chart type.

- Mike

"Knowledge001" wrote in message
...
Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)

Thanks David, I was able to plot the graph. Do you Know of a book you
recomend, to learn more about writing formulaes in excel

"David Billigmeier" wrote:

By the way, you have the binomial distribution formula wrong, it's:
(N choose K)(p^K)(1-p)^(n-k)

But to answer your question, place this formula in A1 and drag down to row
50, then select the range A1:A50 and graph:

=COMBIN(50,ROW())*(0.7^ROW())*(0.3^(50-ROW()))


--
Regards,
Dave


"Knowledge001" wrote:

Use a compter (excel) to plot the binomial distribution as a function of k
for n=50, and p=0.7

"David Billigmeier" wrote:

What are you looking to use as your variable? n,k, or p?

--
Regards,
Dave


"Knowledge001" wrote:

Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)