Need assistance on how to plot this formulae in Excel.
(N choose K)K^P(n-k)^(1-p)
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" <[email protected]> wrote in message
news:[email protected]...
> 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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks