Question
i need to know how to do this on excel. please show through excel if possible
Statistical Techniques in Business & Economics, 17th Edition 205 DISCRETE PROBABILITY DISTRIBUTIONS 45. An auditor for Health
0 0
Add a comment Improve this question Transcribed image text
Answer #1

N R S TI W AA AB AC AD AE Ans:- This is an example of binomial distribution with n=15 and p =0.4 (a) Expected number of poli

Add a comment
Know the answer?
Add Answer to:
i need to know how to do this on excel. please show through excel if possible...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Chapter 6 and 7 practice problems

    An auditor of Health Maintenance Services of Georgia reports 40 percent of policyholders 55 years or older submit a claim during the year. Fifteen policyholders are randomly selected for company records.A. How many of the policy holders would you expect to have filed a claim within the last year?B. What is the probability that 10 of the selected policyholders submitted a claim last year?C. What is the probability that 10 or more of the selected policyholders submitted a claim last...

  • Chapter 6 and 7 practice problems

    An auditor of Health Maintenance Services of Georgia reports 40 percent of policyholders 55 years or older submit a claim during the year. Fifteen policyholders are randomly selected for company records.A. How many of the policy holders would you expect to have filed a claim within the last year?B. What is the probability that 10 of the selected policyholders submitted a claim last year?C. What is the probability that 10 or more of the selected policyholders submitted a claim last...

  • I need solution to be in excel format so I can see how it was done...

    I need solution to be in excel format so I can see how it was done Question 1: Chapter 8 Investment Criteria. A new furnace for your small factory will cost $27,000 a year to install and will require ongoing maintenance expenditures of $1,50 more fuel-efficient than your old furnace and will reduce your consumption of heating oil by 2,400 gallons per year. Heating oil this year will cost $3 a gallon; the price per gallon is expected to increase...

  • if using excel please show formulas so i know how to do. Expected return A stock's...

    if using excel please show formulas so i know how to do. Expected return A stock's returns have the following distribution: Demand for the Company's Products Weak Below average Average Above average Strong Rate of Return If Probability of This Demand Occurring 0.2 0.1 0.4 0.2 0.1 1.0 This Demand Occurs -50% -10 17 20 49 a. Calculate the stock's expected return. Round your answer to two decimal places. b. Calculate the stock's standard deviation. Round your answer to two...

  • please show how to do problem in Excel sheet template like above Economic Life 13-1 An...

    please show how to do problem in Excel sheet template like above Economic Life 13-1 An injection-molding machine has a first cost of $1,050,000 and a salvage value of $225,000 in any year. The maintenance and operating cost is $235,000 with an annual gradient of $75,000. The MARR is 10%. What is the most economic life? G JK M EUAC- P E UAC-M EUAC-S EUAC Minimum? 1 2 235000 235000 235000 235000 235000 235000 235000 235000 Maint G (AIG, 10%,...

  • The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of...

    The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of the 1-40 freeway are being considered in order to reduce traffic congestion and travel times Since this is a government project, the B-C ratio method must be applied in the evaluation. Construction costs of the project are estimated to...

  • Please show all your work. I need step by step. How did you solve? Please help...

    Please show all your work. I need step by step. How did you solve? Please help me both part or both question. Please help me with all question. Will give you thumbs up. 3. According to government data, 25% of employed women have never been married. If 20 employed women are selected at random, what is the probability that two or fewer of them have never been married? (Note: set up a numerical expression only, but you do not have...

  • Please help me with this question!!! I need all the schedule fill it out and I don’t know how to ...

    please help me with this question!!! I need all the schedule fill it out and I don’t know how to do it; please help me ! Help Save& Exit Submit Check my work During 2018, Jason and Vicki Hurting, who are married with two children and fling jointly, had the following tak information Jason landscaping business, and Vicki works as a sales executive for a manufacturing business Jason (SSN 412-34-5670) and Vicki (SSN 412-34-5671) reside at 123 Bate Street, Bright,...

  • PLease help. I don't understand how to do this. don't know what i am doing. On...

    PLease help. I don't understand how to do this. don't know what i am doing. On January 1, 2021, the general ledger of Grand Finale Fireworks includes the following account balances: Debit Credit Accounts $44,400 47,900 9,200 81,000 Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Common Stock, $1 par value Additional Paid-in Capital Retained Earnings $ 10,700 16,300 17,000 97,000 41,500 $182,500 $182,500 Totals During January 2021, the following transactions occur: 2 Issue an additional 2,100 shares of...

  • i need help with 1,2,3, and 4. can you please show me how you arrived at...

    i need help with 1,2,3, and 4. can you please show me how you arrived at the answers. thanks so much. Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 15% for all items sold Barbara Cheney, Pittman's controller, has just prepared the company's budgeted income statement for next...

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