Question

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

2. Second, generate a random sample of 145 data points. 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 Image option.

3. Next, generate a random sample of 290 data points. 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 Image option.

4. Then, generate a random sample of 1200 data points. 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 Image option.

5. In as much detail as possible, explain what you've noticed as the sample size increased. You should address the distribution of the sample. You will be graded on the completeness of your answer. Remember, you can record audio of your explanation if you'd prefer that over typing. You should attach that audio in the entry box below.

( PLEASE EXPLAIN TO ME HOW YOU GOT THE ANSWER AND THE STEPS THANKS )

Answer 1

Step1. Open Excel Goto Data then data analysis tool(if you dont have please add it with the help of add-on).

Step 2. Select Random number generator in data analysis tool. Select normal Dist. then fill mean =500 and standard dev =9. press ok.

Step 3. After that again goto data analysis tool and select histogram, select data generated then select bin then output bar and press ok.

e) As sample size or number of data increases the graph is getting more symmetric(Bell-shaped) d has 1200 data point has it has the best bell shape compared to others