Probability Distribution (Excel)

[ad_1]
1. Packages delivered from a local distribution center to their final destination vary between 30 and 240 minutes, and follow a uniform distribution. a. What is the expected value of time it takes for parcels to arrive at their final destination.b. What is the probability that a package takes 60-120 minutes to arrive?c. What is the likelihood that a package takes more than 200 minutes?d. What is the probability that a package takes less than 100 minutes?2. A fleet of vehicles requiring regular maintenance typically cost $980 per month, with a standard deviation of $100, and follow a normal distribution. Two repairs completed recently, costing $1093 and 937, are being assessed to see if the costs are comparable to typical costs. Compute the z-value for each of these costs and comment on the value relative to typical costs.3. The income for mid-level executives is normally distributed, with a mean of $110,000 and standard deviation of $18,000. a. What is the probability of finding an executive whose income is greater than $125,000? b. What is the likelihood of finding an executive who income is less than $115,000? c. What is the probability of finding an executive who income is between $100,000 and $110,000?4. A retail store maintains inventory so that the likelihood of running out of stack (i.e. a stock out) is 5%. If the store anticipates demand for an item to be 10 units per month, with a standard deviation of 1, how many units should be kept in stock? Assume demand is normally distributed, and round your answer to the nearest whole number that ensures stock outs occur no more than 5% of the time.
[ad_2]Source link
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"