K
Knowledge001
Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)
(N choose K)K^P(n-k)^(1-p)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Billigmeier
What are you looking to use as your variable? n,k, or p?
K
Knowledge001
Use a compter (excel) to plot the binomial distribution as a function of k
for n=50, and p=0.7
for n=50, and p=0.7
D
David Billigmeier
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()))
(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()))
K
Knowledge001
Knowledge001 said: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
M
Mike Middleton
Maybe you could use the BINOMDIST worksheet function to get values on a
worksheet and then create a Column chart type.
- Mike
worksheet and then create a Column chart type.
- Mike
K
Knowledge001
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
recomend, to learn more about writing formulaes in excel