For the data you collected, fill out the frequency table For this table only use the (yes or no) response to the second question Ignore gender for this portion of the project Have you seen this movie Response Frequency Relative Frequency Yes No Now use Excel to make a pie chart of this data Make sure the pie chart has a title, a legend, and that each slice shows the percent of data in that slice Copy your pie chart from Excel and paste below You will also be submitting the Excel file with your assignment, but you must have the pie chart pasted below as well For the data you collected, fill out the two way table You will use both the gender response to the first question and the yes no response to the second question What percent of all responses were yes Have you seen this movie Gender Identity Yes No Male 9 2 Female 9 0 Other N A Based on the two way table, answer these questions with complete sentences 5 2 If you repeated this experiment with 20 different people, would you get the same percent of yes responses Why or why not 5 3 What percent of all male responses were yes (out of the male responses, what percent were yes ) Suppose that your entire population had 10,000 males Using the percent you found above, how many of these 10,000 males would have seen your movie 5 5 What percent of all yes responses were female (out of the yes responses, what percent were female ) Suppose that your population had 15,000 people who had definitely seen the movie What percent of those people would be female For the age data you collected, using Excel make a histogram that describes the ages of your sample Organize your age data in 5 to 6 bins Then use the histogram to make frequency table (See the example below for the frequency table, which you can edit to enter your data) Copy your histogram from Excel and paste below Do not submit this separately Make sure your histogram has a title Age bin (years) Frequency Cumulative Frequency (0,15 (15,30 (30,45 (45,60 (60,75 (75,90 Part 3 Suppose that in Part 2, you were asked to use cluster sampling with any sample size of 20 or greater Describe a process you could use to get the survey information using cluster sampling You do NOT need to actually collect data this way, merely describe how you could

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 30, 2024

For the data you collected, fill out the frequency table. For this table only use the (yes or no) response to the second question.Ignore gender

For the data you collected, fill out the frequency table. For this table only use the (yes or no) response to the second question.Ignore gender for this portion of the project.

Have you seen this movie?

Response	Frequency	Relative Frequency
Yes
No

Now use Excel to make a pie chart of this data. Make sure the pie chart has a title, a legend, and that each slice shows the percent of data in that slice. Copy your pie chart from Excel and paste below. You will also be submitting the Excel file with your assignment, but you must have the pie chart pasted below as well.

For the data you collected, fill out the two-way table. You will use both the gender response to the first question and the yes/no response to the second question.
1. What percent of all responses were yes?

Have you seen this movie?

Gender Identity	Yes	No
Male	9	2
Female	9	0
Other:
N/A:

Based on the two-way table, answer these questions with complete sentences.

5.2 If you repeated this experiment with 20 different people, would you get the same percent of yes responses?Why or why not?

5.3 What percent of all male responses were yes? (out of the male responses, what percent were yes?)

Suppose that your entire population had 10,000 males. Using the percent you found above, how many of these 10,000 males would have seen your movie?

5.5 What percent of all yes responses were female? (out of the yes responses, what percent were female?)

Suppose that your population had 15,000 people who had definitely seen the movie. What percent of those people would be female?

For the age data you collected, using Excel make a histogram that describes the ages of your sample. Organize your age data in 5 to 6 bins. Then use the histogram to make frequency table. (See the example below for the frequency table, which you can edit to enter your data). Copy your histogram from Excel and paste below. Do not submit this separately. Make sure your histogram has a title.

Age bin (years)	Frequency	Cumulative Frequency
(0,15]
(15,30]
(30,45]
(45,60]
(60,75]
(75,90]

Part 3

Suppose that in Part 2, you were asked to use cluster sampling with any sample size of 20 or greater.Describe a process you could use to get the survey information using cluster sampling. You do NOT need to actually collect data this way, merely describe how you could.