“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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