Question

In: Statistics and Probability

Use formula U=a+(b-a)*RAND( ) to obtain a sample of 25 outcomes for a game of Battleship...

Use formula U=a+(b-a)*RAND( ) to obtain a sample of 25 outcomes for a game of Battleship as described in Problem 34 (The time required to play a game of Battleship is uniformly distributed between 15 and 60 minutes). Find the average and standard deviation for these 25 outcomes.

Solutions

Expert Solution

MS Excel is used

a=15, b=60

Hence U= a+(b-a)*RAND() becomes 15+45*RAND()

In excel direct functions like = AVERAGE (number1,[number2..) and=STDEV(number1,[number2]..) are used to find average and standard deviation..


Related Solutions

for u=<2,1,-3> and v=<1,0,2>, a) find the angle between u and v b) use the formula...
for u=<2,1,-3> and v=<1,0,2>, a) find the angle between u and v b) use the formula proj_a b=((a•b)/|b|^2)b to find vector projection of v onto u c) sketch vectors u, v, and the projection found with only using arrows d) find the area of the parallelogram determined by u and v
Formula=IF(RAND()>0.5,T.INV(RAND(),10)-2,T.INV(RAND(),10)+2 observation sample 1 1 1.37700278 2 1.827378045 3 3.479013387 4 1.382604626 5 2.572039451 6 2.38234939...
Formula=IF(RAND()>0.5,T.INV(RAND(),10)-2,T.INV(RAND(),10)+2 observation sample 1 1 1.37700278 2 1.827378045 3 3.479013387 4 1.382604626 5 2.572039451 6 2.38234939 7 0.240414349 8 -1.347432349 9 2.85777933 10 -3.379978992 11 -2.746482213 12 1.886442756 13 -1.947527669 14 1.540754548 15 -0.233174876 16 -1.104079702 17 -1.226712691 18 3.300631732 19 0.940368484 20 -1.845113569 21 -1.250733918 22 -1.392547733 23 2.478557615 24 0.823135564 25 1.630991977 sample mean 0.489827213 Use the excel spreadsheet to simulate 1000 samples of size 25 by copying cells C:3 through C:27 and pasting into rows 3 through...
6. Team A and Team B are competing in the following game: There are 25 flags...
6. Team A and Team B are competing in the following game: There are 25 flags planted on the beach. On its turn a team may take 1, 2, 3, or 4 flags. The team that takes the last flag wins. Team A chooses first. You are the captain of Team B. Using backward induction, devise and explain a strategy that guarantees your team will win.
Team A and Team B are competing in the following game: There are 25 flags planted...
Team A and Team B are competing in the following game: There are 25 flags planted on the beach. On its turn a team may take 1, 2, 3, or 4 flags. The team that takes the last flag wins. Team A chooses first. You are the captain of Team B. Using backward induction, devise and explain a strategy that guarantees your team will win.
can u give a formula that can be use using financial performance to calculate efficiency of...
can u give a formula that can be use using financial performance to calculate efficiency of cost of capital, capital structure, capital budgeting and mergers and acquisitions
for (b): Use a Lagrange multiplier. To get a formula for the variance of Xc, use...
for (b): Use a Lagrange multiplier. To get a formula for the variance of Xc, use the bilinearity property of covariance and the formula for Cov(Xi , Xj ) (i 6= j) derived in class. When you have the sum of all cj such that j 6= k, you might find it useful to replace that sum by 1 − ck. (Explain.) ForarandomsampleofsizenfromapopulationofsizeN,considerthefollowing as an estimate of μ: n Xc = wheretheci arefixednumbersandX1,...,Xn isthesample. a. Find a condition on the...
A fair coin is tossed 4 times. a. Write the outcomes of the sample space b....
A fair coin is tossed 4 times. a. Write the outcomes of the sample space b. Let A be the event of obtaining at least one head, find P(A) c. Let B be the event of obtaining at least one tail, find P(B) d. Let C be the event of obtaining two tails, find P(C) e. Find P(A ∪ B) f. Find P(A ∩ B) g. Find P(A ∪ B ∪ C)
what sampling technique would u use to select the sample study
what sampling technique would u use to select the sample study
Use the formula to find the standard error of the distribution of differences in sample means,...
Use the formula to find the standard error of the distribution of differences in sample means, x1 - x2. (there are lines above both x's but my computer won't transcribe it) Samples of size  45 from Population 1 with mean  3.4 and standard deviation  1.5 and samples of size  45 from Population 2 with mean  1.9 and standard deviation  1.4
solve by use this FORMULA : = Conventional B-C ratio with PW B-C PW(benefits of the...
solve by use this FORMULA : = Conventional B-C ratio with PW B-C PW(benefits of the proposed project) PW(total costs of the proposed project) PW(B) I - P ((( DRAW A CASH FLOW DIAGRAM ))) 10-7. A toll bridge across the Mississippi River is being considered as a replacement for the current I-40 bridge linking Tennessee to Arkansas. Because this bridge, if approved, will become a part of the U.S. Interstate Highway system, the B–C ratio method must be applied...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT