Spreadsheet model for performing a simulation of the throw

Assignment Help Basic Statistics
Reference no: EM131104443

The game of craps requires the player to throw two dice one or more times until a decision has been reached as to whether he (or she) wins or loses. He wins if the first throw results in a sum of 7 or 11 or, alternatively, if the first sum is 4, 5, 6, 8, 9, or 10 and the same sum reappears before a sum of 7 has appeared. Conversely, he loses if the first throw results in a sum of 2, 3, or 12 or, alternatively, if the first sum is 4, 5, 6, 8, 9, or 10 and a sum of 7 appears before the first sum reappears.

(a) Formulate a spreadsheet model for performing a simulation of the throw of two dice. Perform one replication.

(b) Perform 25 replications of this simulation.

(c) Trace through these 25 replications to determine both the number of times the simulated player would have won the game of craps and the number of losses when each play starts with the next throw after the previous play ends. Use this information to calculate a preliminary estimate of the probability of winning a single play of the game.

(d) For a large number of plays of the game, the proportion of wins has approximately a normal distribution with mean = 0.493 and standard deviation = 0.5√n. Use this information to calculate the number of simulated plays that would be required to have a probability of at least 0.95 that the proportion of wins will be less than 0.5. 22

Reference no: EM131104443

Questions Cloud

Estimate the theoretical maximum efficiency of this heat : Estimate the theoretical maximum efficiency of this heat engine. Assume hand temerature is 32?C and room temperature is 23?
What are assumptions : In the realm of decision making, what are assumptions? Rather than use a dictionary definition, cite several specific assumptions that would go with any real-life decision you have made or have seen made at a company at which you have worked.
Calculate the net present value of waiting for the patent : A venture capitalist named Kevin is considering a pitch from an entrepreneur who has invented a smart toaster, which is a wifi-enabled cooking appliance that alerts users via text-message when their toast is ready. The entrepreneur has submitted an a..
International market sufficiently competitive : Are the trade policies in your selected international market sufficiently competitive to attract new companies in a particular industry?
Spreadsheet model for performing a simulation of the throw : The game of craps requires the player to throw two dice one or more times until a decision has been reached as to whether he (or she) wins or loses. He wins if the first throw results in a sum of 7 or 11 or, alternatively, if the first sum is 4, 5..
What is the major distinction : What is the major distinction?
Effective period of the labor agreement : Compare the methods available for the adjustment of wages during the effective period of the labor agreement. Make this comparison in light of the organization in which you currently work or recently worked.
What is the cost of the asset being depreciated : What is the cost of the asset being depreciated? What amount, if any, was used in the depreciation calculations for the salvage value for this asset? Which method will produce the highest charge to income in Year 1?
A thriving business repairing bicycles : Eddie's Bicycle Shop has a thriving business repairing bicycles. Trisha runs the reception area where customers check in their bicycles to be repaired and then later pick up their bicycles and pay their bills.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Explain discrimination claim on the basis of numbers

In total, of 1000 applications they got from men, they hired 625, or 62.5%. Based on numbers presented, what do you believe of the discrimination claim?

  Determine if such a length is considered unusual

A woman wrote to DearAbby and claimed that she gave birth 308 days after a visit from her husband, who is in the Navy. Lengths of pregnancies have a mean of 268 days and a standard deviation of 15 days

  Find the expected value of market research information

Use a decision tree to recommend a decision. What is the expected value of the market research information? What is the efficiency of the information?

  Is difference in mean scores large enough to be important

Is the difference in mean scores large enough to be important? (d) Is it reasonable to assume equal variances? (e) Carry out a formal test for equal variances at α = .05, showing all steps clearly.

  Rolling of a fair six-sided die

If a fair six-sided die is rolled 1200 times, find the probability that an even number will occur at most 620 times.

  Discussing discrete probability distributions

Thirty percent of the population in a southwestern community are Spanish-speaking Americans. A Spanish-speaking person is accused of killing a non-Spanish speaking American.

  Find out the probability distribution of blood types

Find out the probability distribution of blood types by gender in the group of 1000 individuals.The table below gives the distribution of blood types by gender in a group of 1000 individuals.

  When solving for the sample size required to estimate p to

when solving for the sample size required to estimate p to within a particular margin of error under what circumstances

  Business application project select a decision

Business Application Project Select a decision oriented issue from your profession that can be measured using Applied Information Economics (AIE) to come to a specific decision. Write a report that describes the AIE framework as follows:

  Television viewing 835 hours per day per household normal

television viewing 8.35 hours per day per household. normal probabiity distirbution with a standard deviation of 2.5

  Problem with unaccepted shipments simply

The data from the drive quality tests conducted at DataStor over the past 150 shifts are contained in the file DATASTOR. The Data Description section contains a description of this data file.1.

  Evalauate the variance of their salaries

A random sample of students is selected, and each one is asked to try first brand A and then brand B, or vice versa with the order determined at random.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd