1. Engineering
  2. Computer Science
  3. we will be using excel to simulate the number of...

Question: we will be using excel to simulate the number of...

Question details

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 20 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:a20, 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 20. 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.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution