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

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 using =COUNTIF where you have ">=2" instead of the 1 as the element you're counting.

Create a pie graph in Google Sheets 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.

Percent that is left-handed:?

Second, generate a random sample of 15 data points (1-10).

Create a pie graph in Google Sheets 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.

Percent that is left-handed:

Next, generate a random sample of 50 data points (1-10).

Create a pie graph in Google Sheets 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.

Percent that is left-handed:

Then, generate a random sample of 2900 data points (1-10).

Create a pie graph in Google Sheets 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.

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!