Question

How to use excel to simulate 10 random dice rolls? Need to use the concept of...

How to use excel to simulate 10 random dice rolls? Need to use the concept of Inverse CDF and use the Excel tools: vlookup() and rand().

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Firstly Rand() function returns a random number between 0 and 1. This function will recalculates the value when a worksheet is opened or changed

1. Open excel file and keep the cursor in the cell A1. Type the formula "=Rand()" and press enter

2. Drag the formula to the range of A1 to A10. Now the excel has been updated 10 random numbers

Vlookup:

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

"=VLOOKUP (value, table, col_index, [range_lookup])"

  • value - The value to look for in the first column of a table.
  • table - The table from which to retrieve a value.
  • col_index - The column in the table from which to retrieve a value.
  • range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

Example:

After updating the inverse CDF, vlookup function helps to compare and incorporate coulns from another set of data.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Simulate 1000 rolls of a pair of dice. (Hint: Sounds like a For Loop to me!)...
Simulate 1000 rolls of a pair of dice. (Hint: Sounds like a For Loop to me!) Write a program that simulates a dice roll by picking a random number from 1-6 and then picking a second random number from 1-6.    How many times do you get two 1’s. What many times do you get two 1’s if you simulate 10,000 rolls of a pair of dice? Upload your program and type the answer to the two questions. (remember, these...
Dice Rolling) Write an application to simulate the rolling of two dice. The application should use...
Dice Rolling) Write an application to simulate the rolling of two dice. The application should use an object of class Random once to roll the first die and again to roll the second die. The sum of the two values should then be calculated. Each die can show an integer value from 1 to 6, so the sum of the values will vary from 2 to 12, with 7 being the most frequent sum and 2 and 12 being the...
We know that in throwing two fair dice independently, the sum of the two outcomes will...
We know that in throwing two fair dice independently, the sum of the two outcomes will be 2, 3, …., 12 with respective probabilities I/36, 1/18, 1/12, 1/9, 5/36, 1/6, 5/36, 1/9, 1/12, 1/18, and 1/36. Simulate 1000 independent throws of a pair of independent fair dice, and compare the observed proportion of 2s, ….., 12s with the known probabilities, using an appropriate test from Law Chapter 6. Use a random number function in Excel to generate the 1000 throws....
solve using excel... 1. rolling a fair dice 1500 times. Use excel to find the mean...
solve using excel... 1. rolling a fair dice 1500 times. Use excel to find the mean and standard deviation that the numbers less than #3 are rolled at most 250 times. so, please explain how to solve this using excel.
Suppose you roll two twenty-five-sided dice. Let X1, X2 the outcomes of the rolls of these...
Suppose you roll two twenty-five-sided dice. Let X1, X2 the outcomes of the rolls of these two fair dice which can be viewed as a random sample of size 2 from a uniform distribution on integers. a) What is population from which these random samples are drawn? Find the mean (µ) and variance of this population (σ 2 )? Show your calculations and results. b) List all possible samples and calculate the value of the sample mean ¯(X) and variance...
For a Binomial Random Variable with n = 22 and p = .54, use Excel to...
For a Binomial Random Variable with n = 22 and p = .54, use Excel to calculate: P(X = 8) P(X <=15) P(X > 13) P(X ≥ 10) P(9<=X<=21) For a Normal Random Variable with μ = 22 and σ = 5.4, use Excel to calculate: P(X < 18) P(X > 26) P(X > 10) P(17 < X < 31) You should attach an Excel file showing all of your work, including formulas.
how to use excell to Using excel, You will need to plot the log of the...
how to use excell to Using excel, You will need to plot the log of the copy number (x axis) against the CT values (Y-axis) and generate a line of best fit together with an R2 value (which measures the goodness of fit). copies per UL cq(Value) 10,000,000 28.87 1,000,000 32.01 100,000 35.27 10,000 38.87
i need to know on excel how to calculate the yield to maturity of a bond...
i need to know on excel how to calculate the yield to maturity of a bond with the information below. it can be random numbers Number of periods Present value (price) Face value Coupon rate i also need a second calculation that shows me the YTM if this bond pays semi-annually instead of annually it can be random numbers.
R Simulation: For n = 10, simulate a random sample of size n from N(µ,σ2), where...
R Simulation: For n = 10, simulate a random sample of size n from N(µ,σ2), where µ = 1 and σ2 = 2; compute the sample mean. Repeat the above simulation 500 times, plot the histogram of the 500 sample means (does it mean that I can just use hist() method instead of plot() method). Now repeat the 500 simulations for n = 1,000. Compare these two sets of results with different sample sizes, and discuss it in the context...
We can use the random number table to simulate outcomes from a given discrete probability distribution....
We can use the random number table to simulate outcomes from a given discrete probability distribution. Jose plays basketball and has probability 0.7 of making a free-throw shot. Let x be the random variable that counts the number of successful shots out of 10 attempts. Consider the digits 0 through 9 of the random number table. Since Jose has a 70% chance of making a shot, assign the digits 0 through 6 to "making a basket from the free throw...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT