Gamma Probability Distributions With Microsoft Excel

Search:

Gamma Probability Distributions With Microsoft Excel

Want to work with gamma probability distributions? But a quick explanation is order if you're not familiar with this powerful statistical concept and technique. Here's the situation: If a Poisson process produces successes at a constant rate of m per unit of time, then the random variable x, the elapsed time until the rth success, follows the gamma distribution.

The gamma distribution is often used to determine the amount of time it takes for the rth person to arrive in a line.

Using the GAMMADIST Function

If you know x and want to find the probability, you use the GAMMADIST function, which has the following syntax:

=GAMMADIST(x, alpha, beta, cumulative)

For example, if x equals 25, alpha equals 8, beta equals 9, and cumulatative is TRUE, you use the following formula:

=GAMMADIST (25,8,9,TRUE)

The function returns the value 0.007774.

Using the GAMMAINV Fucntion

If you have been given a probability and want to find x, you use the GAMMAINV function, which has the following syntax:

=GAMMAINV (probability, alpha, beta)

For example, if the probability equals .5, alpha equals 8, and beta equals 9, you use the following formula:

=GAMMAINV (.5,8,9)

The function returns the value 69.02.

Using the GAMMALN Function

You use the GAMMALN function to find the natural logarithm of the gamma function, G(x). The GAMMALN function uses the following syntax:

=GAMMALN(x)

For example, if x equals 25, you use the following formula:

=GAMMALN(25)

The function returns the value 54.78.

Article Source: http://articlenexus.com

Prolific computer book author Stephen L. Nelson wrote the MBA's Guide to Microsoft Excel, from which this short article is adapted. Nelson also writes and edits downloadable do-it-yourself small business incorporation kits that businesses and investors can use for setting up a Pennsylvania S Corporation or a Rhode Island S Corporation .

Please Rate this Article

Not yet Rated

Click the XML Icon Above to Receive Accounting Articles Via RSS!

Additional Articles From - Home | Accounting

Cash Accounting Or Accrual Accounting - By : Ben Needles
Starting A Child Daycare Center - By : kelvin young
Faxless Payday Loans New York: - By : Gray smith
Small business accounting firm: Carve an grand base for your upcoming organization - By : Alvis Brazma
Limitations of freelancer accounting - By : jessica thomtion
Five Card Draw Strategy - By : Momo Ahmed
Debt Management: Plan And Make Your Debt Disappear! - By : Charly Groom
Best Locations for Investment Properties - By : jessica thomtion
Real estate accounting: An important business aspect that your business needs - By : Alvis Brazma
Jewelry as art in Topeka - By : wotrace.com

	Print This Article
	Add To Favorites
	Email to Friends
	Ezine Ready

Submit Articles
Member Login
Top Authors
Most Popular Articles
Submission Guidelines
Ezine Notifications
Article RSS Feeds

(Your 160x160 ad here)
Only $50 a month-click here

Everything you need for your website and home business.
	Adsense Site Builder
	Adsense Analyzer Software
	Clip Art
	Domain Names
	Header Graphics
	Internet Business Info
	Photo Art
	SEO Software
	Web Hosting $4.95/mo
	Website Templates
	Web Site Promotion Tools
AdvancedWebsiteTools.com

Link Exchange
Blog by WordPress
Privacy Policy
Terms of Service
About Us
Contact Us
Banner Advertisements

Have you Victimized by a Business or the Government? File your consumer complaints or business complaints at BusinessReporter.net!

Structured Settlement?
Free information to help you learn more about structured settlements, your rights, and how to select the best company for you.

Affordable Discount Dental Plans
Choose from over 30 top-quality national and regional discount dental plans. Save 10% to 60% on most dental procedures

Hair Loss Remedies

Remove Bad Credit
Legally Erase Bad Credit and Improve Your Credit Rating
with Self Help Credit Repair
Do It Yourself Credit Repair

Free Diabetic Supplies

Antique Radios | Ham Radios