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

  Question 1anbsp explain following terms-nbsp inbsp distinct

question 1anbsp explain following terms-nbsp inbsp distinct random

  Hypothesis testing of consumer preference

A test was conducted to determine whether gender of a spokesperson affected the likelihood that consumers would prefer a new product.

  Seven persons are staying at a hotel the hotel has

seven persons are staying at a hotel. the hotel has twenty-five floors each with the same number of rooms. each of the

  Minimum sample size required to construct a confident

A researcher want to estimate the mean shoulder height of both male and female bears within 0.25 centimeters. Determine the minimum sample size required to construct a 99% confident interval

  Find probability that first ball drawn was white

Then a second ball is drawn at random from the three ball in the box. what is the probability that the first ball drawn was white, given that at least one to the two balls drawn was white?

  Percent of lead removed as response variable

It is the gallons of water processed at a plant, and the amount of lead removed from the water. A. Make a scatterplot to determine what kind of relationship there seems to be between the two variables. Use the percent of lead removed as the respon..

  Designing the pie chart and bar graph for data

Data is distribution of the most popular colors for 2005 model luxury cars made in North America. Design the pie chart and bar graph for data.

  What proportion of adults said that clothing was ?rst choice

What proportion of adults said that clothing was their ?rst choice? What are the odds that an adult will say that clothing is his or her ?rst choice?

  Test of goodness of fit to check coats follow probabilities

In this problem we want to run a test of goodness of fit to check whether the coats in the consignment follow the indicated probabilities.

  Sample-size for population mean

How many boxes must the processor sample to be 95 percent confident that the sample mean does not differ from the population mean by more than 0.2 pounds?

  Estimate of the true population average amount

(a) Set up a 99% confidence interval estimate of the true population average amount of paint included in a five-litre can. (Use the z-table.) (b) Based on the results of (a), do you think that the store owner has a right to complain to the manufact..

  Suppose a simple random sample of size 43 is selected from

suppose a simple random sample of size 43 is selected from a population with sigma 8. find the value of the standard

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