123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Business >> View Article

Probability Distribution

Profile Picture
By Author: mohanchen
Total Articles: 434
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

probability distribution has a bell-shaped curve. It is characterized
by its mean mu and standard deviation sigma. The mean describes the location of the curve, the standard deviation describes the shape (how peaked or flat it is). The mean, the median, and the mode are all equal in a normal distribution.

To describe the time it takes to complete a task, you use the exponential probability distribution, For example, you can describe the time between arrivals of vehicles in a drive-through or the time required to load a crate of goods. Product lifetimes also often follow an exponential probability distribution.

For example, if the average lifetime of a part in a machine is 15 years, you can find the probability that the part will last less than a certain number of years, more than a certain number of years, or between numbers of years.
The EXPONDIST function uses the following syntax:
=EXPONDIST (x, lambda, cumulative)
where lambda is the inverse of the mean and cumulative allows you to tell Excel whether you want the cumulative probability ...
... or the probability of exactly that value. For example, if you want to find the probability that a part with a mean lifetime of 12 years lasts less than 6 years, enter the function as follows:
=EXPONDIST(6,1/12,TRUE)
The function returns the value 0.3935.

CRITBINOM Function

The acceptance criterion function, CRITBINOM, is used for quality control of a production process. You use this function to find the maximum number of defective items that a person can find in a lot and still allow acceptance of the lot. Inspectors should accept the lot if they find this number or fewer defective items and reject the lot if they find more defective items.

To determine the acceptance criterion, you need to know the number of items in the lot, the probability of accepting each item, and the producer's allowable risk (alpha) for rejecting an acceptable lot.
The CRITBINOM function uses the following syntax:
=CRITBINOM (trials, probability_s, alpha)
where trials is the number of trials, probability's is the probability of a success on each trial,
and alpha is the criterion value. Probability's and alpha are both between 0 and 1.

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 cumulative is TRUE, you
use the following formula:
=GAMMADIST (25,8,9,TRUE)
The function returns the value 0.007774.

Total Views: 223Word Count: 399See All articles From Author

Add Comment

Business Articles

1. Unveiling The Material Characteristics Of Plastic Parts
Author: adam.xu

2. Top 5 Beach View Resorts In Chennai For A Memorable Getaway
Author: greenmeadows resort

3. Relationship Counselling Den Haag Brings The Best Chance To Understand Each Other’s Needs!
Author: Angelika Matthias

4. Web Development Company: Guide For Hiring The Best
Author: Sagar Tech

5. Make A Business Website To Get Started Online
Author: Sagar Tech

6. Elevate Your Software Quality With Agile Advisors: Premier Software Testing Consultancy In Dubai, Uae
Author: kohan

7. Affordable Polyester Pleated Mesh From Top Manufacturers
Author: pavitra

8. Empowering Sustainable Development: Agile Advisors As Your Trusted Leed Certification Consultant In Dubai And Uae
Author: kohan

9. Buy Cats Eye Gemstone Online In Ahmedabad
Author: rishabhjains

10. Why Data Destruction And Sanitisation Are Important
Author: Destruction and Sanitisation

11. Stock Market Update: शेयर बाजार में लगातार चौथे हफ्ते बढ़त: क्या तेजी बरकरार रहेगी? जाने इस हफ्ते किन महत्वपूर्ण पहलुओं पर ध्यान देना चाहिए
Author: M Ratlami

12. Perfect Happy New Year Gift For Your Girlfriend Thoughtful Ideas For 2024
Author: MyFlowerTree

13. China Valmax Valve Co., Ltd
Author: China Valmax Valve Co., Ltd.

14. Mastering Clipping Path In Photoshop: A Guide To Precision Editing
Author: Sam

15. Expert Emergency And Cosmetic Dental Care Services For Families And Individuals In St. Louis
Author: Jessica Williams

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: