Question: Use a worksheet to simulate the rolling of dice. Use the VLOOKUP function as described in Appendix 16.1 to select the outcome for each die.

Use a worksheet to simulate the rolling of dice. Use the VLOOKUP function as described in Appendix 16.1 to select the outcome for each die. Place the number for the first die in column B and the number for the second die in column C. Show the sum in column D. Repeat the simulation for 1000 rolls of the dice. What is your simulation estimate of the probability of rolling a 7?

Step by Step Solution

★★★★★

3.39 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The Excel worksheet for this problem is as follows Selected cell formulas are as fol... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

148-M-S-Q-M (145).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

What is your final estimate for rs?

What is your final estimate for the cost of equity, rs? During the last few years, Harry Davis Industries has been too constrained by the high cost of capital to make many capital investments....

What is your best estimate of the percent change in urinary protein based on the data in Table 8.16? Renal Disease Ten patients with advanced diabetic nephropathy (kidney complications of diabetes)...

BUS 220 - Introduction to Decision Sciences Assignment 4 due on Thursday 11/12/2015 Fall 2015 NOTE: 10% of your grade will be deducted if the work is not presented in a clear and neat manner. NOTE:...

1 2.3 Definition of a Discrete Probability Function Definition: Let S be a discrete sample space from some experiment. A function P, defined on all events in S, is said to be a probability function...

A random experiment was conducted where a Person A tossed five coins and recorded the number of "heads". Person B rolled two dice and recorded the larger number out of the two dice. Simulate this...

CIS 111 C Programming Programming Assignment Two Die Roll Probability Simulator Overview In this assignment, the student will write a program that simulates the rolling of dice and collects...

A random experiment was conducted where a Person A tossed five coins and recorded the number of "heads". Person B rolled two dice and recorded the larger number out of the two dice. Simulate this...

Pro-simulation Questions: 1. A number cube has six faces, labeled from 1 to 6. Consider the population {1, 2, 3, 4, 5, 6}. State the mean and standard deviation of this population. p = 3-5 o = 1-71...

This is Statistics course and I need help with answering questions. I have to fill in the blanks. I attached lesson 2,3 and 6 in case you need it for reference. I did the first 6 questions so please...

Measured conditions for the bottoms from a depropanizer distillation unit in a small refinery are given below. Using the data in Figure and assuming an ideal liquid solution (volume of mixing = 0),...

It's 1976 and you are throwing a fondue party! You need to heat 800.0 mL of vegetable oil to 375 F (190.0C) using an ethanol burner. Assuming a perfect transfer of heat from the burner to the oil,...

Agencies at the state level are divided into counties and municipalities. True False

The Department of Corrections (DOC) needs to replace two of its prison transport buses. There are two companies that have a track record of making reliable vehicles, and both make a bus that meets...

Bob Richards, the production manager of Zychol Chemicals, in Houston, Texas, is preparing his quarterly report, which is to include a productivity analysis for his department. One of the inputs is...

An electric go kart with the following specification was tested on a straight track Kart specifications: Vehicle Mass = 60 kg Rider Mass= 70 kg Cd*A= 0.25 m (the Cd*A value is with the rider sitting...

The following Information has been extracted from the financial statements of a company. Net income in 2316 = $3,000 Annual depredation in 2016 = $1,000 Interests in 2016= $500 Working capital in...

What is the net employment income? Canadian income tax Unless "received", amounts listed are paid by the salesperson Salary received 29,300 Commissions received 14,269 Airfares 3,100 Lodging 3,444...

Hot dogs Healthy eating probably doesnt include hot dogs, but if you are going to have one, youd probably hope its low in both calories and sodium. Recently, Consumer Reports listed the number of...

If each activity in Problem 19.3 has a duration of one week, find the earliest and latest start and finish times for each activity and the corresponding total floats.

Sven Sengler has divided a project into the following activities. What does the network for the project look like? (a) If each activity can be reduced by up to two weeks, what is the shortest...

A project consists of ten activities with estimated durations (in weeks) and dependences shown in the following table. (a) What are the estimated duration of the project and the earliest and latest...

Suppose you have a loan of $10,000,000 outstanding, on which you will have to make a (floating-rate) coupon payment on Tuesday, February 24th. The coupon that you have to pay is determined by the...

Question 5 Not yet answered Marked out of 2.00 Flag question Se compra una maquinaria con un costo inicial de $100,000. Los costos de operacin y mantenimiento son $5,000 los primeros 2 aos y 58,000...

Use the following information for the remaining questions: Project A: Initial Investment: $600 Cash Flows in Years 1 4: $240,$190,$160,$120 Project B: Initial Investment: $400 Cash Flows in Years 1...