HomeworkLib
Question

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5....

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5. Construct a histogram for them [Note: first generate 100 uniformly distributed random values from [0,1]; then use them as the first input for NORMINV( ) function, two other inputs are mean and standard deviation of given Normal distribution.

can you show me step by step how to do this in excel

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ANSWER :

Do comment in case any doubt, will reply for sure . Goodluck

0 0
Add a comment
Know the answer?
Add Answer to:
Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

    Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. use excel generate a random sample of 1300 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. post your histogram

  • Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

    Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5 In Excel generate a random sample of 290 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram

  • Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

    Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. First, generate a random sample of 50 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram as an image file and attach it here.

  • use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

    use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. generate a random sample of 150 data points in excel. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram as an image file and attach it here using the Insert Image option.

  • Please answer both 1 & 2. 1. Use Excel to generate 100 observations from the standard...

    Please answer both 1 & 2. 1. Use Excel to generate 100 observations from the standard Normal distribution. a.Make a histogram of these observations. How does the shape of this histogram compare with a Normal density curve? 2. Use Excel to generate 100 Normally distributed random values (that is 100 outcomes of a Normally distributed random variable with mean 10 and standard deviation of 5). a. Make a histogram for your data. How does the shape of this histogram compare...

  • Use Excel to standard normal observations with assumed population parameters with mean 16 and standard deviation...

    Use Excel to standard normal observations with assumed population parameters with mean 16 and standard deviation 5. Go to Data Analysis (you need to have chosen "Analysis Toolpack" first) -> Random Number Generation -> Normal. Generate one random variable with numbers generated for samples of size 5, 16, and 25 from the default standard normal distribution. This will simulate the importance of the "assume normal" assumption. Use the =) provided from the parent population as your "assumed" population standard deviation....

  • Generate 100,000 normal data with mean 70 and standard deviation 4.5. (Don’t show generated data). Graph...

    Generate 100,000 normal data with mean 70 and standard deviation 4.5. (Don’t show generated data). Graph an histogram of the generated data. Then, using a transformation, determine the probability of P(65<x<75). Hint( Normal Distribution) Please show all the steps to do this in Minitab.

  • 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...

  • A distribution of values is normal with a mean of 230 and a standard deviation of...

    A distribution of values is normal with a mean of 230 and a standard deviation of 25. From this distribution, you are drawing samples of size 27. Find the interval containing the middle-most 70% of sample means:

  • Many random number generators allow users to specify the range of the random numbers to be...

    Many random number generators allow users to specify the range of the random numbers to be produced. Suppose that you specify that the range is to be all numbers between 0 and 5. Call the random number generated Y. Then the density curve of the random variable Y has constant height between 0 and 5, and height 0 elsewhere. 1. Use Excel to generate 100 random values from the above distribution. Construct a histogram for generated values [ Note: use...

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