06632 Mathematics Order within 24hrs

06632 Topic: M2 Analysis Assignment

Number of Pages: 2 (Double Spaced)

Number of sources: 1

Writing Style: MLA

Type of document: Math Problem

Academic Level:High School

Category: Mathematics

Language Style: English (U.S.)

Order Instructions: Attached

. We will be using Excel to simulate a normal distribution with a mean of 400 and a standard deviation of 9. Please note there are five parts to this question.

1 . First, generate a random sample of 19 data points from a normally distribution population (using the =invnorm command in Excel). Create a histogram where the first bin starts at 375.25 and the width of each bin is 4.5. You can have your last bin be 420.25. Save that histogram as an image file and attach it here. (Your image file should be .png, .jpg, or .bmp.

2. Second, generate a random sample of 75 data points from a normally distribution population (using the =invnorm command in Excel). Create a histogram where the first bin starts at 375.25 and the width of each bin is 4.5. You can have your last bin be 420.25. Save that histogram as an image file and attach it here. (Your image file should be .png, .jpg, or .bmp.)

3. Next, generate a random sample of 260 data points from a normally distribution population (using the =invnorm command in Excel). Create a histogram where the first bin starts at 375.25 and the width of each bin is 4.5. You can have your last bin be 420.25. Save that histogram as an image file and attach it here. (Your image file should be .png, .jpg, or .bmp.)

4. Then, generate a random sample of 1700 data points from a normally distribution population (using the =invnorm command in Excel). Create a histogram where the first bin starts at 375.25 and the width of each bin is 4.5. You can have your last bin be 420.25. Save that histogram as an image file and attach it here. (Your image file should be .png, .jpg, or .bmp.)

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.