ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   did Excel GAMMADIST parameters change?? (https://www.excelbanter.com/excel-discussion-misc-queries/191910-did-excel-gammadist-parameters-change.html)

tsterkel

did Excel GAMMADIST parameters change??
 
In the literature, Milesky, Tucker, et.al. they use GAMMADIST with parameters
of (alpha,beta,x,cum). However my Excel has the parameters of
(x,alpha,beta,cum). Did GAMMADIST change? merely shifting "x" to the
implied new order does NOT provide the same results!

Mike Middleton

did Excel GAMMADIST parameters change??
 
tsterkel -

My copy of Function Reference for Excel 4.0 (copyright 1992) shows

GAMMADIST(x,alpha,beta,cumulative)

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"tsterkel" wrote in message
...
In the literature, Milesky, Tucker, et.al. they use GAMMADIST with
parameters
of (alpha,beta,x,cum). However my Excel has the parameters of
(x,alpha,beta,cum). Did GAMMADIST change? merely shifting "x" to the
implied new order does NOT provide the same results!




Jerry W. Lewis

did Excel GAMMADIST parameters change??
 
If you would provide a reference to the article, we miight be able to tell
you what the authors actually did.

Jerry

"tsterkel" wrote:

In the literature, Milesky, Tucker, et.al. they use GAMMADIST with parameters
of (alpha,beta,x,cum). However my Excel has the parameters of
(x,alpha,beta,cum). Did GAMMADIST change? merely shifting "x" to the
implied new order does NOT provide the same results!



All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com