Question

Use the cells on this sheet to make calculations. Calculate the probability of pulling 4 straight Kings or Queens one after tPLEASE solve and show formulas used in Excel! I am so slow at this! thank you! :)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

P(puilling 4 kings or 4 queens ) =P(select 4 kings from 4)+P(select 4 Queens from 4)=combin(4,4)/combin(52,4)+combin(4,4)/combin(52,4) =0.0000074

2)

P(2 face cards in 3 trails) =P(2 face card from 12 and one from remaining 40)

=combin(12,2)*combin(40,1)/combin(52,3)=0.119457

Add a comment
Know the answer?
Add Answer to:
PLEASE solve and show formulas used in Excel! I am so slow at this! thank you!...
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
  • I am having problem understanding this problem. please explain it explicitly. its a discrete comp...

    I am having problem understanding this problem. please explain it explicitly. its a discrete computer science problem. thanks Exercises 27-32 concern a 5-card hand from a standard 52-card deck. A standard deck has 13 cards from each of 4 suits (clubs, diamonds, hearts, spades). The 13 cards have face value 2 through10, jack, queen, king, or ace Each face value is a "kind" of card. The jack, queen, and king are "face cards. 27. How many hands contain 4 queens?...

  • Answer the following questions and use Excel to show your work. A standard deck of playing...

    Answer the following questions and use Excel to show your work. A standard deck of playing cards consists of 52 cards. The cards in each deck consist of 4 suits, namely spades (♠), clubs (♣), diamonds (♦), and hearts (♥). Each suit consists of 13 cards, namely ace, king, queen, jack, 10, 9, 8, 7, 6, 5, 4, 3, and 2. In the game of poker, a royal flush consists of the ace, king, queen, jack, and 10 of the...

  •               Looking closely, you will see that the Jack of Spades and the Jack of Hearts...

                  Looking closely, you will see that the Jack of Spades and the Jack of Hearts are revealing only one eye. These are the “one-eyed Jacks” and are used as wild cards in a popular home-version of poker, along with the four 2’s (or “Deuces”).   The King of Diamonds is also showing only one eye, so let us include it among the wild cards. That gives us a total of 7 wild cards: the four 2’s, the two one-eyed Jacks,...

  • Hello, I need help with Question 7. Please show all the steps and the solutions of the problem. Thank you very much. 7. Consider a game that consists of drawing a single card at random from a standar...

    Hello, I need help with Question 7. Please show all the steps and the solutions of the problem. Thank you very much. 7. Consider a game that consists of drawing a single card at random from a standard deck of 52 cards. You pay S3 to play the game, and the money is not returned. If you draw an ace, you win S10. If you draw a king or queen, you win S5. How much should you expect to win...

  • (Excel) Assume that two investments...(See picture below, please solve in excel and show formulas used, Thank...

    (Excel) Assume that two investments...(See picture below, please solve in excel and show formulas used, Thank you :) ) 3. (Excel) Assume that two investments each cost $90000 initially. The returns are as follows: Investment End of year Type B. COST -90000 -90000 INCOME 14440 16000 INCOME 15015 16000 INCOME 15615 16000 INCOME 16240 16000 INCOME 16890 16000 INCOME 17565 16000 SALVAGE 45000 41000 a. Which investment is preferred using the payback method? b. Which investment is preferred using the...

  • her ability to solve math problelli nunity college show that 40% of first-year studente les. Records...

    her ability to solve math problelli nunity college show that 40% of first-year studente les. Records also show that the graduation rate of e 18 75%. Assuming that these two factors are ch other, what is the probability that a randomly graduate from the college? (2 marks) cluing dldle card in the second d) A person's height and his or her ability to solve 52. The enrolment records of a community college si live in one of the college's dormitories....

  • 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...

  • Show what formulas are used in excel to solve problems please. What role does capital budgeting...

    Show what formulas are used in excel to solve problems please. What role does capital budgeting play in the firm's overall financial planning program? answer must be at least 300 words. 2 COMMON STOCK VALUATION Crosby Corporation common stock paid $1.32 in dividends last year and is expected to grow indefinitely at an annual 7 percent rate. What is the value of the stock if you require an 11 percent return? 4 6 DATA 7 Growth rate 8 Dividend (Do)...

  • Please solve all parts and show work clearly. Please show all the formulas used. Thank you!

    Please solve all parts and show work clearly. Please show all the formulas used. Thank you! We were unable to transcribe this image3b) Calculate the upper-3dB frequency (f, = ??)ofthis MOSFET amplifier. /10 points/ 3b) Calculate the upper-3dB frequency (f, = ??)ofthis MOSFET amplifier. /10 points/

  • This is a major project so please show all formulas/work on Excel. Thank you so much!...

    This is a major project so please show all formulas/work on Excel. Thank you so much! Instructions Enter your name and Access ID (aa1234' format) in the cells above. The data required for this case will not appear until you do so. You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom....

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