Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
"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 |
#6
|
|||
|
|||
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) |
#7
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Translate excel formulae | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
how do i draw a distribution chart in excel | Charts and Charting in Excel |