Dear Sir,
Please help to teach me which funtion in excel can analyze the data following beta binomial distribution model.
Best regards,
TQV
Dear Sir,
Please help to teach me which funtion in excel can analyze the data following beta binomial distribution model.
Best regards,
TQV
Re: Funtion to use beta binomial distribution for model data
I know what the binomial distribution is and what the beta distribution is, but I don't know what a beta binomial distribution might be. Is this a Baysian problem where the p value for the binomial has a beta prior distribution?
Re: Funtion to use beta binomial distribution for model data
Quote from DerkI know what the binomial distribution is and what the beta distribution is, but I don't know what a beta binomial distribution might be. Is this a Baysian problem where the p value for the binomial has a beta prior distribution?
Dear Derk,
It used to analyse the TV viewing data. This model can calculate the cumulative reach in period of time from TV viewing data. It can be binominal distribution b/c my boss called it BBD very often.
Best regards,
TQV
Re: Funtion to use beta binomial distribution for model data
TQV
Are you sure you are not talking about the BETA distribution
see the function BETADIST
Quote
BETADISTReturns the cumulative beta probability density function. The cumulative beta probability density function is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
AFAIK binomial dist is used for data that has only two outcomes success or failures
HTH
pangolin
Re: Funtion to use beta binomial distribution for model data
Actually, the Binomial distribution is a discrete distribution that is usually used to get the probability of k "sucesses" in n tries, where the probability of a success is a constant p and each try is independent of the others. Excel has a BinomDist function for this.
TQV, can you post an example of the calculation that is now being done? That may help determine whether it can also be done in Excel. Perhaps your boss has a formula or is using some other piece of software to do the calculation. Any more details would help. From what you say, you need a continuous distribution, and the Beta, as Pangolin says, may well be what you are after.
Don’t have an account yet? Register yourself now and be a part of our community!