ZuoTi.Pro
Question

IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) In a typical month, an insurance agent presents life insurance plans to 40 potential Historically, one in four such customers chooses to buy life insurance from this agent. You may treat this as a binomial experiment. a. What is the probability of success for this problem? b. What is the total number of trials in this problem? c. Create a probability distributio n table which includes the value for the random variable and the probability of each possible outcome of the random variable. Also create the cumulative d. What is the probability that exactly five customers will buy life insurance from this agent in the e. What is the probability that no more than 10 customers will buy life insurance from this agent in f. What is the probability that at least 20 customers will buy life insurance from this agent in the g. Determine the mean and standard deviation of the number of customers who will buy lif h. What is the probability that the number of customers who buy life insurance from this agent in probability column. coming month? the coming month? coming month? insurance from this agent in the coming month? the coming month will lie within two standard deviations of the mean?
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

15 A20 p(x) F(x) BINOMDIST(AS,40,0.25,o) BINOMDISTIA540,0.25,1 BINOMDIST(A6,40,0.25,0)BINOMDISTIA6,40,0.25.1) BINOMDIST(A740, 0.25,0).-ו =BINOMDIST(A7,40, 0.25,1) 8,40, 0.25,1) BINOMDIST(A9 40,025,1) BINOMDIST(A10,40,0.25,0)-BINOMDIST(A10,40.o.25,1) BINOMDIST(A11,40,0.25,0) -BINOMDIST(A11,40,0.25,1) =B IN O M DISTA 12,40,0.25,0), i-BINOMDIST( 12,40,0 25,1) BBINOMDISTIA13 40,0.25,1) İ BINOMDISTA 14,40,0.25,0) --BINOMDIS (414,40,0.25,1) -BIN OMDISTA15 40,0.25, 1) BI NOM Dist( A8,40, 0.25,0) i BINOMDIST(A9.40,0.25,0 #8 INOM DIST( 8 3 . İ 4 9 4 | 10 5 11 6 Iİİ ITI LL 7 13 3 14/9 : 15 10 16 11 BINOMDIST(A13,40,0.25,0 I - : ーB INOM DIST(A15,40 0.25,0) =BI NON DIST( 1640,0-25,0) BINOMDİST(A17 40,0.25,0) =BI NO DIST A 16,40,0 25,1 m 17 12. 이 BINOMDIST(A1740 0.25,1) 18 13BINOMDISTA1s 40.0.25 OSINOMDisT A19 40 o.25 19 14BINOMDISTIAL9 40.0 25.0)5 BNOMDISTIA19 40,0.251 #BINOMI DIST(AC 40, 25,0. NON DIST(A20,40,0.25,1 in t Sneet-i, Sheet3 ー·ト,t sheet1 Ready ii. | StartMicrosoft Excel binol. Diel up Connecti Excel Help.B10 BINOMDIST(A10,40,0.25,O) 0| 1.01E-05 | 1.006E-05 | 16|0.01 1 0.000134 0.000144117 0.01 210.000872| 0.001015기 18 32) 이 11 1 5| 0.99 | 133 1 34 0 4 0.011347 0.0160422 20 136 0 101-510:02亞32. 0.04 3274| 21 38 江ま.. : -610:052951| 0.0962246 | 221 0 12: -. 71 0.08573|0.1819542| 23| 01:11 391 01 1 -33 810.1178 781 0.2998323| 24 251 o -14 91 0.13 9 70 710.4395397| 9 0.139707 0.439539725 iO 0.144364 0.5839041 260 16 110.13124 0.7151444 27 17 12 0.105721 0.820865828 18 19 141 o.048 794|0.9455628 30 20 15 0.028192 0.973755 31o 0 13 0.0759030.8967683 29 0 11 Ready .. 滮Start | | thi, Microsoft Excel-bino 45 Excel Help Dial-up ConrectionX F value, ,nc1 ,el dist、ibullo-) 丐 ,th.? d.colU m Gins cumulat ive d stai bal I- P obabi lity tnt at l at 20 rusbirbus (q -) t .lty?. 乏 Lt lsug.urn 5 C

0 0
Add a comment
Know the answer?
Add Answer to:
IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) In a...
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

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE The annual number...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE The annual number of industrial accidents occurring in a manufacturing plant is known to follow a Poisson distribution with mean 12. a. What is the probability of observing of observing exactly 12 accidents during the coming year? b. What is the probability of observing no more than 12 accidents during the coming year? c. What is the probability of observing at least 15 accidents during the coming...

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes a. Clearly state what the random variable in this problem is? b. What is an appropriate distribution to be used for this problem and why? c. What is the expected number of calls in one hour? d. What is the probability of receiving...

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Suppose the number...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Suppose the number of customers arriving each hour at the only checkout counter in a local pharmacy is approxima hour. a. Find the probability that exactly 10 customers arrive in a given hour. b. Find the probability that at least five customers arrive in a given hour 1) tely Poisson distributed with an expected arrival rate of 20 customers per c. Find the probability that no more...

  • N AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Use Excel function...

    N AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Use Excel function and write down the Poisson Distribution (with mean = 5.5) in a Table and plot the chart. 1) (Ctrl)" |

  • IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS ...

    IN A EXCEL FILE USING EXCEL FORMULAS AND CALCULATIONS MUST SHOE FORMULAS IN CELL! SHOW THE STEPS IN SOLUTION APPROACH. Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type...

  • Statistics and Probability Question. Please show and explain all calculations in detail so that we can...

    Statistics and Probability Question. Please show and explain all calculations in detail so that we can learn. Thank you! Problem 5. Market data from customers who buy Surface Pro 7 or Surface Pro 6 computers show that a randomly selected customer chooses a Surface Pro 7 with a probability of 0.6. Consider 100 randomly selected such customers and assume that each individual independently selects a Surface Pro 7 with a probability of 0.6 and a Surface Pro 6 with a...

  • IN An EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS In San Francisco, 30% of workers take public...

    IN An EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS In San Francisco, 30% of workers take public transportation daily. In a sample of 10 workers, a. Clearly state what the random variable in this problem is? b. What is an appropriate distribution to be used for this problem and why? c. What is the probability that exatly three workers take public transportation daily? d. What is the probability that NONE of workers take public transportation daily? e. What is the probability...

  • I need answer for these in excel format ... please by using excel formulas for example...

    I need answer for these in excel format ... please by using excel formulas for example =NORM.dis() ... as soon as possible please! And thankyou! Fonmattin Undo Cipboard Font A manulacturer produces ight buibs that have a mean ide of at least 600 hours when the production process is working properly. Based on past experience, the population standard deviation is 50 hours and the ight bulb ide is normally distributed The operations manager selects a random sample df5o light bulbs,...

  • For this problem, you must use Excel to perform the necessary calculations. Below are the formulas...

    For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. If it is appropriate to use the binomial distribution, use the formula =binom.dist(number_s,trials,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trials, trials is the total number of trials, probability is the probability for a single trial expressed as a decimal, and cumulative should be set as false. This will report the...

  • please show the excel formulas and calculations. thank you!! Problem 3.15 In Charleston, a city of...

    please show the excel formulas and calculations. thank you!! Problem 3.15 In Charleston, a city of temptations, the average weekly family (no kids, less than 5 years married) expenditure on entertainment is $60, with a standard deviation of $14 What is the probability that 75 couples (no kids, less than 5 years married) spend less than $57 per week in entertainment? a. b, what amounts of average weekly spending would the sample have in order to be within 1.3% of...

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