Question

If you generate 1000 random numbers in Excel using the "=RAND()" formula, what can you say about the mean of these random numbers?

If you generate 1000 random numbers in Excel using the "=RAND()" formula, what can you say about the mean of these random numbers?

a.

Mean will be less than 1.00 and greater than 0.8

b.

Mean will be less than 0.6 and greater than 0.4

c.

Mean will be less than 0.4 and greater than 0.2

d.

Mean will be less than 0.8 and greater than 0.6


0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

By given  data,

Measure of central tendency is used to estimate the summary of the data set. Most commonly used measures are mean, median and mode. Where the measure of central tendency are also known as location measure.

Mean is the average of sum of all the observation divided by the total number of observations, median is the middle value that separates the ordered data into two equal halves and mode is the most repeated value

. the 1000 random variables generated by the excel.

Now Average or mean of 1000 random variables was 0.518 calculated using the excel code =AVERAGE(A1:A1000)

Since the mean value lie between the 0.4 and 0.6

Option B is correct


answered by: Subrahmanyam golla
Add a comment
Know the answer?
Add Answer to:
If you generate 1000 random numbers in Excel using the "=RAND()" formula, what can you say about the mean of these random numbers?
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Most computer languages include a function that can be used to generate random numbers. In Excel,...

    Most computer languages include a function that can be used to generate random numbers. In Excel, the RAND function can be used to generate random numbers between 0 and 1. If we let x denote a random number generated using RAND, then x is a continuous random variable with the following probability density function. for 0 sxs 1 elsewhere (a) Graph the probability density function. f(x) f(x) EEEEEEEEEEEEE Endas tiers - 3 - Terce BOORTE E segments Egertice Tesegent o...

  • most computer languages include a function that can be used to Generate random numbers in Excel...

    most computer languages include a function that can be used to Generate random numbers in Excel the Rand function can be used to Generate random numbers between 0 and 1 if we let X denote a random number General using R and then X is a continuous random variable with the following probability density function

  • (b) What is the probability of generating a random number between 0.35 and 0.65? (c) What...

    (b) What is the probability of generating a random number between 0.35 and 0.65? (c) What is the probability of generating a random number with a value less than or equal to 0.20? (d) What is the probability of generating a random number with a value greater than 0.60? (e) Generate 50 random numbers by entering =RAND() into 50 cells of an Excel worksheet. This answer has not been graded yet. (f) Compute the mean and standard deviation for the...

  • Question 26 (3 points) The RAND() function in Excel enters random numbers between o and 1....

    Question 26 (3 points) The RAND() function in Excel enters random numbers between o and 1. what function in word enters Word document? CD RAND(p,l) O There is no function that enters random text in a word document RTEXT(w,s) WORDS O BARD(lines of text) Save Question 27 (3 points) If a spreadsheet cell A4 contains the formula -ses4 and the formula in A4 is copied and pasted (standard p formula in A5 will read $B$4. $B$5 It won't have a...

  • pick a number for mean and standard deviation generate 5 random numbers using a normal distribution...

    pick a number for mean and standard deviation generate 5 random numbers using a normal distribution and mean and standard deviation from (i) using your 5 numbers find the mean and the standard deviation of your data How far is your sample mean from your true mean? By 'far' I mean how many sample standard deviations. use the absolute value of distance here Repeat steps 2-4 1000 times. you should now have 1000 measures how far your sample mean is...

  • 4.60 The sum of two uniform random numbers. Generate two random numbers between 0 and 1...

    4.60 The sum of two uniform random numbers. Generate two random numbers between 0 and 1 and take Y to be their sum. Then Y is a continuous random variable that can take any value between 0 and 2. The density curve of Y is the triangle shown in Figure 4.12. (a) Verify by geometry that the area under this curve is 1. (b) What is the probability that Y is less than 1? [Sketch the density curve, shade the...

  • 4. 3/6 points Previous Answers ASWSBE13 6.2.004. My Notes Ask Your Teacher Most computer languages include...

    4. 3/6 points Previous Answers ASWSBE13 6.2.004. My Notes Ask Your Teacher Most computer languages include a function that can be used to generate random numbers. In Excel, the RAND function can be used to generate random numbers between 0 and 1. If we let x denote a random number generated using RAND, then x is a continuous random variable with the following probability density function. ROX) i for 0 SX S1 10 elsewhere (a) Graph the probability density function....

  • 5000) of uniformly distributed random numbers between 1 Generate a large number (1000 or and 2...

    5000) of uniformly distributed random numbers between 1 Generate a large number (1000 or and 2 (HINT: use the rand command for generating a uniformly distributed random variable between 0 and 1 and then move it!). b Plot the pdf of the distribution. Use the hist command to obtain the number of samples in a random numbers, define binx as a vector with bins on the x-axis (binx = 1:0.01:2). P histx,binx) will provide you the weights pdf. Compare with...

  • 1. Based on the mean, percent error, and standard deviation, what can you say about your accuracy...

    mean: 100.7 percent error: 0.7% standard deviation: 29.58 1. Based on the mean, percent error, and standard deviation, what can you say about your accuracy and precision? What does this say about whether your errors are primarily random or systematic? Explain your reasoning 1. Based on the mean, percent error, and standard deviation, what can you say about your accuracy and precision? What does this say about whether your errors are primarily random or systematic? Explain your reasoning

  • The random-number generator on calculators randomly generates a number between 0 and 1. The random variable...

    The random-number generator on calculators randomly generates a number between 0 and 1. The random variable X, the number generated, follows a uniform probability distribution. (a) Identify the graph of the uniform density function. (b) What is the probability of generating a number between 0.85 and 0.96? (c) What is the probability of generating a number greater than 0.88? (a) Choose the correct graph of the uniform density function below. ОА. OB. OC. A Density Density A Density ON ON...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT