Question: How to solve this problem using excel Poisson formula? Thanks A telephone company's goal is to have no more than 3 monthly line failures on

How to solve this problem using excel Poisson formula? Thanks

How to solve this problem using excel Poisson formula? Thanks A telephone

A telephone company's goal is to have no more than 3 monthly line failures on any 100 miles of line. The company currently experiences an average of 6 monthly line failures per 50 miles of line. Let x denote the number of monthly line failures per 100 miles of line. Assuming x has a Poisson distribution: (a) Find the probability that the company will meet its goal on a particular 100 miles of line. (Do not round intermediate calculations. Round final answer to 4 decimal places.) Probability 0.0023 (b) Find the probability that the company will not meet its goal on a particular 100 miles of line. (Do not round intermediate calculations. Round final answer to 4 decimal places.) Probability 0.9977 (c) Find the probability that the company will have no more than 3 monthly failures on a particular 200 miles of line. (Do not round intermediate calculations. Round final answer to 4 decimal places.) Probability 0.0000 (d) Find the probability that the company will have more than 12 monthly failures on a particular 150 miles of line. (Do not round intermediate calculations. Round final answer to 4 decimal places.) Probability 0.9083

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!