Question: Construct a spreadsheet simulation model to simulate 10,000 rolls of a die with the six sides numbered 1, 2, 3, 4, 5 and 6. a.

Construct a spreadsheet simulation model to simulate 10,000 rolls of a die with the six sides numbered 1, 2, 3, 4, 5 and 6.
a. Construct a histogram of the 10,000 observed dice rolls.
b. For each roll of two dice, record the sum of the dice. Construct a histogram of the 10,000 observations of the sum of two dice.
c. For each roll of three dice, record the sum of the dice. Construct a histogram of the 10,000 observations of the sum of three dice.
d. Compare the histograms in parts (a) to (c). What statistical phenomenon does this sequence of charts illustrate?

Step by Step Solution

★★★★★

3.37 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b c d As we add more dice to the sum the total becomes more and more bellshaped That is ... 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)

1014-B-C-A-P-C (728).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: a. Construct...

Construct a spreadsheet simulation in which each trial consists of rolling of four dice. That is, there are four random variables each with an outcome of 1, 2, 3, 4, 5, or 6. For each trial, record...

South Central Airlines (SCA) operates a commuter flight between Atlanta and Charlotte. The regional jet holds 50 passengers, and currently SCA only books up to 50 reservations. Past data show that...

1. Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and website...

Can someone explain to me how to answer number 3 on an excel spreadsheet? Thank you! For each of these Scenarios. the fixed COS-t remains 5150.000. Use Scenario Manager to generate a summary report...

Can someone answer number 3 please. Skip the first question FOI' EHCh Of these scenarios. the XEU COS-t remains $150,000. USE Scenario Manager to generate a summary report that gives the prot for...

Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Variable Cost/ Book $12 $10 $11 ACCESS Price $50 Demand 2500 1000 5000 20 00 For each of these scenarios, the fixed cost remains $160,000. Use...

I will be doing this in Excel. Please provide explanations! Construct a spreadsheet simulation model to simulate 500 rolls of a die with the six sides numbered 1, 2, 3, 4, 5, and 6. Instructions:...

2. Dice Rolls. Construct a spreadsheet simulation model to simulate 1,000 rolls of a die with the six sides numbered 1, 2, 3, 4, 5, and 6. a. Construct a histogram of the 1,000 observed dice rolls....

Construct a spreadsheet simulation model to simulate 1,000 rolls of a die with the six sides numbered 1, 2, 3, 4, 5 and 6. Construct a histogram of the 1,000 observed dice rolls. For each roll of two...

Bamburg Ltd's retained earnings at the date of acquisition was $ 135,000. No ordinary shares were issued/ redeemed by the subsidiary since acquisition. The group used the proportion of the net assets...

Mike is the Director of Human Resources for a 120-employee family-owned manufacturing firm. Mike has been quite busy the last year reforming the benefit offerings to comply with recent changes in...

Students whose undergraduate major was economics were followed for 10 years after graduation to study the number of different jobs they took. Explain whether each of the following terms applies to...

Patents. Rodney Klassen was employed by the U.S. Depart ment of Agriculture (USDA). Without the USDAs authorization, Klassen gave Jim Ludy, a grape grower, plant material for two unreleased varieties...

Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products from the same raw material. Regular Grind can be produced at a rate of 10,000 pounds...

Burger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more expensive hardware and require additional time for finishing and polishing. Standard...

A business student has $ 2,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next 2 years is given in the...

Project A requires an initial outlay at t = 0 of $ 5 , 0 0 0 , and its cash flows are the same in Years 1 through 1 0 . Its IRR is 1 5 % , and its WACC is 1 2 % . What is the project's MIRR? Do not...

Is there a limit to the amount of interest that you can get? Consider the case of investing $1 at 100% interest for 1 year. Your interest calculation is $1 if the interest is computed at the end of...

Cannonier. Inc., has identified an investment project with the following cash flows. If the discount rate is 8 percent, what is the future value of these cash flows in Year 4? (Do not round...