Question

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.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
a) Rolling a fair dice 1500 times. Use Excel (binom.dist and cumulative is 0) to find...
a) Rolling a fair dice 1500 times. Use Excel (binom.dist and cumulative is 0) to find the probability that #6 appeared exactly 40 times. b) Rolling a fair dice 1500 times. Use Excel (binom.dist and cumulative is 0) to find the probability that numbers less than #3 are rolled exactly 150 times. c) 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...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit the Excel spreadsheet. 1. A fair coin is tossed 15 times, calculate the probability of getting 0 heads or 15 heads 2. A biased coin with probability of head being .6 is tossed 12 times. What is the probability that number of head would more than 4 but less than or equal to 10. 3. You have a biased dice (with six faces numbered...
Suppose the total of rolling any particular number of such dice is normally distributed, with a...
Suppose the total of rolling any particular number of such dice is normally distributed, with a standard deviation and mean as shown If you are rolling 4 dice, the standard deviation is approximately 3.416 If you are rolling 5 dice, the standard deviation is approximately 3.819 If you are rolling 6 dice, the standard deviation is approximately 4.183 Also, If you are rolling 4 dice, the mean is approximately 14 If you are rolling 5 dice, the mean is approximately...
Three eight sided dice (instead of six) are rolled 2000 times!! 1.What is the most common...
Three eight sided dice (instead of six) are rolled 2000 times!! 1.What is the most common sum that would be observed? 2.Perform the exercise in Excel, what is the (sample) standard deviation that you find with 2000 rolls? 3. What is the sum of the frequency column?
Consider the following experiment of rolling two standard, six-sided dice. Use the full sample space for...
Consider the following experiment of rolling two standard, six-sided dice. Use the full sample space for rolling two standard, six-sided dice. Use the sample space to calculate the following. Let E be the event that both face-up numbers are odd. Find P(E). Let F be the event that the face-up numbers sum to 7. Find P(F). Let T be the event that the sum of the face-up numbers is less than 10. Find P(T).
1) Roll two dice 10 times. Record the sum of the dice for each roll. Find...
1) Roll two dice 10 times. Record the sum of the dice for each roll. Find the mean, standard deviation, and construct a histogram from the data.2) Roll two dice 50 times. Record the sum of the dice for each roll. Find the mean, standard deviation, and construct a histogram from the data.3) Roll two dice 100 times. Record the sum of the dice for each roll. Find the mean, standard deviation, and construct a histogram from the data.4) Summarize...
1) A fair die is rolled 10 times. Find an expression for the probability that at...
1) A fair die is rolled 10 times. Find an expression for the probability that at least 3 rolls of the die end up with 5 dots on top. 2) What is the expected number of dots that show on the top of two fair dice when they are rolled?
1) A dice game involves rolling 2 dice. If a 2, 3, 4, 10, 11, or...
1) A dice game involves rolling 2 dice. If a 2, 3, 4, 10, 11, or 12 (the sum of the two) is rolled, you win $5.00. If you roll a 5, 6, 7, 8, or 9 you lose $5.00. Find the expected value per play. Please explain the work in detail
Setup: 3 different people take turns rolling dice. They all get doubles WITHIN 3 ROLLS. NOT...
Setup: 3 different people take turns rolling dice. They all get doubles WITHIN 3 ROLLS. NOT IN A ROW. Each person waits their turn to roll. On each persons turn, they each roll doubles WITHIN 3 ROLLS. GIVEN THE FOLLOWING CONDITIONS: - There is a 25% chance that the dice are loaded so that:  Each die is loaded so that 6 comes up half the time P(6) = .5 for each die. The other numbers (1-5) are equally likely to show...
Make in Excel three tables size 50 times 50, 250 times 50, 1000 times 50 with...
Make in Excel three tables size 50 times 50, 250 times 50, 1000 times 50 with Bernoulli distributed random numbers for p(1) = 1/3. Use the generated tables for calculating new column as t he average of the first 50 columns. Random numbers in this column will have distribution close to the Normal distribution. Find population probability distribution functions, means, variances and standard deviations and compare its with sample frequency distribution functions, averages, sample estimation of variances and standard deviations...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT