Question

PLEASE SOLVE USING EXCEL FUNCTIONS Question 6: The prizes for the Powerball lottery are shown on...

PLEASE SOLVE USING EXCEL FUNCTIONS

Question 6:

The prizes for the Powerball lottery are shown on this worksheet along with their corresponding probabilities. Find the mean and standard deviation of the prize when you buy one lottery ticket.

Divisions Prize (X) Probability (f(X))
Five plus Powerball $50,000,000 0.0000000068443
Match 5 $200,000 0.0000002806143
Four plus Powerball $10,000 0.0000017110601
Match 4 $100 0.0000701459035
Three plus Powerball $100 0.0000838363514
Match 3 $7 0.0034246575342
Two plus Powerball $7 0.0013404825737
One plus Powerball $4 0.0078125000000
Zero plus Powerball $3 0.0142857142857
No prize $0 0.9729806648327
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
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
Similar Questions
The payouts for the Powerball lottery and their corresponding odds and probabilities of occurrence are shown...
The payouts for the Powerball lottery and their corresponding odds and probabilities of occurrence are shown below. The price of a ticket is $1.00. Divisions Payout Odds Probability Five plus Powerball $ 50,000,000 144,307,962 .000000006930 Match 5 200,000 3,560,009 .000000280898 Four plus Powerball 10,000 583,892 .000001712643 Match 4 180 13,535 .000073877069 Three plus Powerball 180 11,927 .000083836351 Match 3 11 291 .003424657534 Two plus Powerball 11 745 .001340482574 One plus Powerball 4 127 .007812500000 Zero plus Powerball 3 69 .014285714286...
For a multistate​ lottery, the following probability distribution represents the cash prizes of the lottery with...
For a multistate​ lottery, the following probability distribution represents the cash prizes of the lottery with their corresponding probabilities. Complete part A. A. If the grand prize is $15,000,000​, find and interpret the expected cash prize. If a ticket costs​ $1, what is your expected profit from one​ ticket? The expected cash prize is $ ________ B. To the nearest​ million, how much should the grand prize be so that you can expect a​ profit? Assume nobody else wins so...
Lottery: I buy one of 400 raffle tickets for $20. The sponsors then randomly select 1...
Lottery: I buy one of 400 raffle tickets for $20. The sponsors then randomly select 1 grand prize worth $500, then 2 second prizes worth $300 each, and then 3 third prizes worth $100 each. The selections are made without replacement. (a) Complete the probability distribution for this raffle. Give your probabilities as a decimal (rounded to 4 decimal places) or as a fraction. Outcomes          P(x)          Win Grand Prize     Win a Second Prize     Win a Third Prize     Win Nothing     (b)...
1) Choose a lottery that has published odds. Make sure to post the odds in both...
1) Choose a lottery that has published odds. Make sure to post the odds in both "1 in X" format and in "p = 0.XXX" decimal format. For example, Flip a Coin has a 1 in 2 chance of being heads, p(heads) = 0.50 2) Explain why P(A and B) = 0, where P(A) = lottery number #1 is a winning jackpot ticket and P(B) = lottery number #2 is a winning jackpot ticket.   3) If there was a really...
Question 1: PLEASE SOLVE USING EXCEL FUNCTIONS A professor, transferred from Toronto to New York, needs...
Question 1: PLEASE SOLVE USING EXCEL FUNCTIONS A professor, transferred from Toronto to New York, needs to sell his house in Toronto quickly. Someone has offered to buy his house for $220,000, but the offer expires at the end of the week. The professor does not currently have a better offer but can afford to leave the house on the market for another month. From conversations with his realtor, the professor believes the price he will get by leaving the...
Part 1 Armadillos are among the most common of Florida’s roadkill victims. A study done along...
Part 1 Armadillos are among the most common of Florida’s roadkill victims. A study done along the Ronald Reagan Turnpike in central Florida found an average of 1.9 armadillo roadkills per 100 miles during the winter, when armadillos are least active [Source: M. Inbar and R. T. Mayer, “Spatio-temporal trends in armadillo diurnal activity and road-kills in central Florida,” Wildlife Society Bulletin 27, no. 3 (1999).] It’s New Year’s Day, and you and your friends are on a road trip...
Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer...
Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer Andrew Tobias argues that he can earn 200% per year buying wine by the case. Specifically, he assumes that he will consume one $10 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $10 per week or buy a case of 12 bottles today. If he buys the case, he receives a 10 percent discount and, by doing...
Part B: Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known...
Part B: Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer Andrew Tobias argues that he can earn 200% per year buying wine by the case. Specifically, he assumes that he will consume one $10 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $10 per week or buy a case of 12 bottles today. If he buys the case, he receives a 10 percent discount and,...
Portfolio Analysis Problem (Excel Spreadsheet) Solve the following portfolio analysis problem using excel. Be sure to...
Portfolio Analysis Problem (Excel Spreadsheet) Solve the following portfolio analysis problem using excel. Be sure to create a general spreadsheet as you will be graded by the accuracy of your spreadsheet for the 8 computations below with a change in some or all of the following: Portfolio Weights, Probabilities, Asset Returns. Be sure to put your name at the top of the spreadsheet and submit as an excel attachment in Canvas. Work out the problem manually before you create your...
Download the Applying Excel form and enter formulas in all cells that contain question marks. Excel...
Download the Applying Excel form and enter formulas in all cells that contain question marks. Excel : ch_08_Noreen_4e_applying_excel_student_form.xlsx Data Example E Cost of equipment needed $60,000 Working capital needed $100,000 Overhaul of equipment in four years $5,000 Salvage value of the equipment in five years $10,000 Annual revenues and costs: Sales revenues $200,000 Cost of goods sold $125,000 Out-of-pocket operating costs $35,000 Discount rate 14% Enter a formula into each of the cells marked with a ? below Exhibit 8-6...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT