Question

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 left-handed vs. right-handed people are in your sample, and save it as an image file. Attach the pie graph using the Insert Image option, and note what percentage of your sample was actually left-handed.



2.

Second, generate a random sample of 115 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 using the Insert Image option, and note what percentage of your sample was actually left-handed.

3.

Next, generate a random sample of 280 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 using the Insert Image option, and note what percentage of your sample was actually left-handed.

4..

Then, generate a random sample of 1500 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 using the Insert Image option, and note what percentage of your sample was actually left-handed.

5.

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

Answer 1

(1) Sample size = 10

(2) Sample size = 115

(3) Sample size = 280

(4) Sample size = 1500

(5) As the sample size increases, the proportion of left-handed people in the sample approaches the population proportion of 10%.