 # Get instant live Excel expert help with RAND Function “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

how to fill blank spaces in excel with random numbers
Solved by D. C. in 30 mins
I'd like to create a set of random numbers that are selected based on an assigned probability. For example, if a biologist wants to visit two ends of a lake, one 80 percent of the time and the other 20 percent of the time but on random days,how do I create this schedule?
Solved by O. D. in 23 mins
I need to qualify a list of random zip codes against a master zip code list to see which in my random list match the known master. How do I do that?
Solved by S. D. in 25 mins
I have a list of random generated numbers from 1 through 100. I need a formula that will list the number of instances for each number 1 through 100. For example: My list generates 1000 random generated numbers between 1 and 100. I want to know how many times the number 50 is resulted from the 1000 random generated numbers.
Solved by V. D. in 13 mins
Hello, I need help with my logistic class. we use excel in different case analysis. This case is about simulation. so I have like 3 hours to submit my homework. we need to generate random numbers and other stuff depend on that.
Solved by B. L. in 14 mins
I have made a spreadsheet to generate random planets for a game - I have made variables for the fields as well which works fine - the problem is twofold 1 - i want to check for incompatible conditions = such as IF Planet_Function="Agriculture" THEN Planet_Types<>"Asteroid Belt" OR Planet_Types<>"Artificial" OR Hydrosphere<>"Barren" 2 - it checks for all incompatible conditions - then either flags them for me to change manually - OR IDEALLY - would regenerate on its own until there are no more errors - i have it set to generate only when requested by F9
Solved by T. S. in 26 mins
use the excel sheet name part 2 to answer the question and round the answer to 4 decimal places . Information from the American institute of insurance indicates that mean amount of life insurance per household in the united states is \$100,000 with a standard deviation of \$40,000 assume the population distribution is normal. A random sample of 100 household is taken What is the probability that sample mean will be more than \$120,000? What is the probability that sample mean will be between \$100,000 and \$120,000?
Solved by B. Y. in 21 mins
Information from the American institute of insurance indicates the mean amount of life insurance per household in the United States is \$110,000 with a standard deviation of \$40,000. Assume the population distribution is normal. A random sample of 100 households is taken. (a) What is the probability that sample mean will be more than \$120,00? (b) What is the probability that sample mean will be between \$100,000 and \$120,000? Round your answer to 4 decimal places. ( use part 2 sheet to answer this question)
Solved by F. Y. in 19 mins
The file name sheet part two is kept blank, use part 2 sheet to answer this question. Put a box around your answers. Round your answer to 4 decimal places. Information from the American institute of insurance indicates the mean amount of life insurance per household in the unites states is \$110,00 with a standard deviation of \$40,000. Assume the population distribution is normal. A random sample of 100 households is taken. A. what is the probability that sample mean will be more than \$120,000? B. what is the probability that sample mean will be between \$100,00 and \$120,000?
Solved by C. F. in 29 mins
I want to have a random cell from a columns of data selected and changed to certain number
Solved by S. W. in 29 mins