ZuoTi.Pro
Question

Please do this in Excel if possible

Problem 2. The following table contains the probability distribution for Xthe number of traffic accidents reported in a day in a small city in the Midwest: 0 1 23 5 P(X- 20 20 35 15 05 05 ) What is the probability of at least 1 accident? b) What ilwr: SUMPRODUCTO fanction in Excel may be helpful.) c) What is the variance of the number of accidents? d) What is the standard deviation of the number of accidents?

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

q3xls Microsort bxel Hcme insert Poge .피out Formules Cat, Review ve Σ AutcSum aBad copy Calculation rsert Delete Farmt cleer Sort &ind Iller - Select Clioboer 1-1-B2 0.2D 0.20 0.15 0.15 0.05 0.05 4 (a) 5 Pl At least 1 accide『따 : 1-Pt XD 0.00 圈Hill 10096 11:17 PM Type here to search 28-Jan-19 a.ㄧ 43xlsx Micresct Excel Homa I Page Layot Form la Data RavVw ム@ 녜 Σ AutoSum- A 矽·アヨ.vn叩 esel Copy Calculation Insert Delete Fmet2 Clar Check Cell Formatting Tabla FIter Selsst C5 PIXEx 0.20 0.20 035 0.15 0.05 1 (b 1.2 10 18 23 24 囲14 1 100%に O Type here to search 11:17 PM 28-Jan-19 0q3xlsx Microsoft Excel Hcme recrt page Layout Formulas cata Ronw vo. Normal らcopy Check Cell Insert Delee Furet Formatting Table 2Clrnd & Call: 012 应| -BB-POWER[B10.2} 2 Pix-x) 0.20 0.15 0.05 0.05 4 (c) E(EX) 0.2 1.4 1.35 0.8 1.25 10 EX-5X X-x1.8 12 VEX) 1.76 14 15 (d) 16 17 Standard-deviatinnX V(X 1.32665 19 23 09 100% に) 11:18 PM O Type here to search 28 Jan 15q35x Microsoft Excel Home | Insert Page Lこyour Fcrmuas D ta Renew Ver 势, wrap Text copy Check Cell Formet ngç - Table 2 cearier Seled Cel: C17 -SORT(D12) 2 PIXEx) 0.70 0.20 0.15 1.1 1.35 D.8 10 E(X)=2XPlXc 1.8 12 V 1.76 17 Staidard-deviation X 1.12665 KTTotalSecurity K7TotalSecurity License has expired. KilotalSoourity Feacy O Type here to search 11:18 PM 28-Jan-19 0

1 0
Add a comment
Know the answer?
Add Answer to:
Please do this in Excel if possible Problem 2. The following table contains the probability distribution...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • The table holds the probability distribution for the variable X, which represents the number of traffic...

    The table holds the probability distribution for the variable X, which represents the number of traffic accidents in a small town (daily) Number of Accidents Per Day (X) Probability of X, P(X) 0 .21 1 .27 2 .23 3 .12 4 .08 5 .05 6 .04 a. Calculate the probability of observing at least 1 accident per day, Pr(X ≥ 1). b. Calculate the probability of observing 7 accidents per day, Pr(X = 7). c. Calculate the expected number of...

  • The following table contains the probability distribution for the number of traffic accidents daily in a...

    The following table contains the probability distribution for the number of traffic accidents daily in a smal town. Complete parts (a) and (b) to the right. a. Compute the mean number of accidents per day. Number of Accidents Px) (Type an integer or a decimal.) Daily (X) 0.22 0.25 0.21 0.11 0.09 0.07 0.05 b. Compute the standard deviation. (Type an integer or decimal rounded to three decimal places as needed.)

  • PLEASE DO ASAP Alt Ctri (20 points) On one particular road in the city, th follows...

    PLEASE DO ASAP Alt Ctri (20 points) On one particular road in the city, th follows a Poisson distribution with ?-3, and the follows an exponential distribution with 0-8 hours. e number of traffic accidents time in between traffic accidents 5. A In a given day, what is the probablity that there are more than 5 traffic accidents in the city? B. What is the probability that another accident occurs within 5 hours since last C. one in that day?...

  • The following table contains the probability distribution for X = the number of speeding cars reported...

    The following table contains the probability distribution for X = the number of speeding cars reported in a day at an intersection. Probability 0.12 0.29 0.42 0.11 0.04 0.02 What is the probability of more than one but at most four speeding cars in a day at the intersection?

  • PLEASE ANSWER PART (c) USING EXCEL I III 6. The following table contains the probability distribution...

    PLEASE ANSWER PART (c) USING EXCEL I III 6. The following table contains the probability distribution for the returns of three securities over the next year. Expected Returns Scenarío Probability T-bills #1 0.03 -17% 5% 33% 3% #2 0.07 -9% 11% 17% 3% #3 0.15 7% 17% 7% 3% #4 0.50 14% 25% 1% 3% #5 0.15 19% 29% 3% #6 0.07 27% 34% -17% 3% #7 0.03 35% 44% -27% 3% a) Determine the expected return and standard deviation...

  • please show thorough work Problem 3 Recall that X ~ Exp(A) if the probability density function...

    please show thorough work Problem 3 Recall that X ~ Exp(A) if the probability density function of X is fX(x)-Ae-λ r for z 2 0, Let Xi, , Xn ~ Exp(A), where λ is an unknown parameter. Exponential random variables are often used to model the time between rare events, in which case λ is interpreted as the average number of events occurring per unit of time a) Let zı, . . . , en be n observations of an...

  • Discrete probability problems 0.2 pts Question 12 The table below is a discrete probability distribution in...

    Discrete probability problems 0.2 pts Question 12 The table below is a discrete probability distribution in which x represents the number of tudents that a statistics tutor may see on any given day and Pix) represents the probability that the tutor sees that number of students. P(x) О.11 0.18 e.36 e.16 e.14 e.es What is the mean of this discrete probability distribution? (Round to the nearest hundredth.) Question 13 0.2 pts The table below is a discrete probability distribution in...

  • Please do questions 1 and 2 Please submit the four asterisked problems below in class on...

    Please do questions 1 and 2 Please submit the four asterisked problems below in class on Wednesday, April 17 Be sure your work is labeled when appropriate. For example, if your solution involves "P(A)," make sure it is clear what event A is and which number in your calculation is P(A); if your solution involves a random variable X make sure it is clear what X is. 1. * An urn contains 999 red balls and 1 green ball. 2000...

  • If possible, please do this in excel. Generating a series of numbers with exponential distribution Posted...

    If possible, please do this in excel. Generating a series of numbers with exponential distribution Posted on: Thursday, April 18, 2019 5:46:35 PM CDT Requirement: Generate randomly a series of 100 numbers whose histogram would look like an exponential distribution. Use the exponential distributionx)-e(PF),. The CDF of itis Fx)-1-e You can come up with any method you feel appropriate. The method shall be used to generate automatically more series of numbers that follow the same exponential distribution. You can pick...

  • show excel formulas please 2. Discrete and Continuous Probability Distributions: In the following three parts, write...

    show excel formulas please 2. Discrete and Continuous Probability Distributions: In the following three parts, write the formula and value for the cases shown. (a) X is the binomial random variable with n = 50 and p = 0.65. [8 points) Case Excel Formula Value PIX> 25) P(X < 35) OMBE 2787 Makeup Test Summer 2020 (b) Suppose that a bank receives an average of 7 bad checks per day and this process can be modeled as a Poisson distribution....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT