Question: Create To do so, enter an Excel worksheet that simulates throwing a pair of dice 20 times. the formula =RANDBETWEEN(1, 6) in the first 20

 Create To do so, enter an Excel worksheet that simulates throwing

Create To do so, enter an Excel worksheet that simulates throwing a pair of dice 20 times. the formula =RANDBETWEEN(1, 6) in the first 20 rows ot column A, and again in column B. Each value will be a random integer between 1 and 6, representing the outcome of one random die. Within each row of column C, place the sum of the corresponding values in columns A and B. In column D, place one of the following labels within each row: (a) (b) (c) If the value in column Cis 7 or 11, display "You Win." If the value in column C is 2, 3 or 12, display "You Lose." If the value in column C is 4, 5, 6, 8, 9 or 10, display "Inconclusive." Note: RANDBETWEEN(a, b) is an Excel library function that returns a random integer between the specified limits a and b (where b > a). To activate this function, run the Excel Setup program and install the Analysis ToolPak. Then enable the Analysis ToolPak by selecting Add-Ins from the Tools menu

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!