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

Question

Question

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.

math Statistics-And-Probability

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

You can simulate using =

=NORM.INV(RAND(),700,5)

And generated image is

Histogram 35 30 34 25 20 20 15 18 15 10 8

Add a comment

Answer 2

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

We will be using Excel to simulate a normal distribution with a mean of 500 and...

We will be using Excel to simulate a normal distribution with a mean of 500 and a standard deviation of 9. Please note there are five parts to this question. First, generate a random sample of 50 data points. 1. Create a histogram where the first bin starts at 475.25 and the width of each bin is 4.5. You can have your last bin be 520.25. Save that histogram as an image file and attach it here using the Insert...
generate a random sample of 130 data points. Create a histogram where the first bin starts...

generate a random sample of 130 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5. You can have your last bin be 272.5 Save that histogram as an image file and attach it here using the Insert Image option
Next, generate a random sample of 300 data points, Createa that histogram as an image file...

Next, generate a random sample of 300 data points, Createa that histogram as an image file and attach it here using the insert image option where the first bin starts at 222.5 and the width of each bin is S. You can have your last bin be 272.5 Save 스,브

Then. generate a random sample of 1300 data points. Create a histogram where the first bin...

Then. generate a random sample of 1300 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5. You can have your that histogram as an image file and attach it here using the insert image option.
e a sample of 10 data points. Create a histogram where the first bin starts at...

e a sample of 10 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5, You can have your last bin be 2725. Save that histogram as an image file and attach it here using the Insert Image option f this option doesn't work for adding the images you may have to drag the image directy from your Explorer window into the answer image option. Some students have reported this...
We will be using Excel to simulate the number of left-handed people in a particular sample....

We will be using Excel to simulate the number of left-handed people in a particular sample. Left-handed people make up about 10% of the population. We will randomly pick numbers between 1 and 10, where 1 represents a left-handed person and 2 - 10 represents a right-handed person. This should result in about 10% of our sample being left-handed. Please note there are five parts to this question. 1. Create a pie graph in Excel to show the proportion of...

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

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

Homework Answers

Add Answer to:
use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

Post as a guest

Earn Coins