Reference no: EM132309257
Topic: M2 Analysis Assignment
Order Instructions:
We will be using Excel to simulate a normal distribution with a mean of 300 and a standard deviation of 9. Please note there are five parts to this question.
Start of Questions
We will be using Excel to simulate a normal distribution with a mean of 300 and a standard deviation of 9. Please note there are five parts to this question.
1. First, generate a random sample of 14 data points from a normally distribution population (using the =invnorm command in Excel). Create a histogram where the first bin starts at 275.25 and the width of each bin is 4.5. You can have your last bin be 320.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 60 data points from a normally distribution population (using the =invnorm command in Excel).
Create a histogram where the first bin starts at 275.25 and the width of each bin is 4.5. You can have your last bin be 320.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 320 data points from a normally distribution population (using the =invnorm command in Excel).
Create a histogram where the first bin starts at 275.25 and the width of each bin is 4.5. You can have your last bin be 320.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 275.25 and the width of each bin is 4.5. You can have your last bin be 320.25. Save that histogram as an image file and attach it here. (Your image file should be .png, .jpg, or .bmp.)
Then Answer this question :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.
5. 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.
First, generate a random sample of 6 data points (1-10). To easily determine how many lefties are in the sample, you can use the command =countif(range, 1). The range will be something like a1:a6, if you created your sample in column a. This will count how many number 1's there are. You can determine the number of right-handed people by subtracting this number from 6.
Create a pie graph in Excel to show the proportion of left-handed vs. right-handed people are in your sample, and save it as an image file. Attach the pie graph here, and note what percentage of your sample was actually left-handed.
6. Second, generate a random sample of 14 data points (1-10).
Create a pie graph in Excel to show the proportion of left-handed vs. right-handed people are in your sample, and save it as an image file. Attach the pie graph, and note what percentage of your sample was actually left-handed.
7. Next, generate a random sample of 65 data points (1-10).
Create a pie graph in Excel to show the proportion of left-handed vs. right-handed people are in your sample, and save it as an image file. Attach the pie graph, and note what percentage of your sample was actually left-handed.
8.Then, generate a random sample of 3000 data points (1-10).
Create a pie graph in Excel to show the proportion of left-handed vs. right-handed people are in your sample, and save it as an image file. Attach the pie graph, and note what percentage of your sample was actually left-handed.
Then answer this question :In as much detail as possible, explain what you've noticed in this exercise. You should state what percentage of people were left-handed in each sample. How did this compare to the population proportion of 10%? Make sure to address what you noticed as the sample size increased. 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.
Number of Pages: 2 (Double Spaced)
Number of sources: 1
Writing Style: APA
Type of document: Coursework
Academic Level:High School
Category: Mathematics
VIP Support: N/A
Language Style: English (U.S.)