Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Mathematics questions

Question

What is management growth? What are its factors

Answered: 1 week ago