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.

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

Homework Answers

Answer #1

,

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
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?
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...
A game involves rolling a fair six-sided die. If the number obtained on the die is...
A game involves rolling a fair six-sided die. If the number obtained on the die is a multiple of three, the player wins an amount equal to the number on the die times $20. If the number is not a multiple of three, the player gets nothing. How will you model the simulation for the roll of a die? A. Use the numbers 1–20 to represent the numbers rolled when a player wins. B. Use the numbers 1–6 to represent...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT