Math 106 Project 2 Collecting and Analyzing Data Pts

Project 2: Collecting and Analyzing Data
Name:________________________________________________________________________
All questions must be answered in complete sentences.
Grading: This project is worth in total 75 points. This is split into 3 parts.
1. The project was completed with thoughtful responses and complete sentences (10 pts)
2. Excel file submitted with work shown (5 pt)
3. The questions were answered correctly based on the Statistics learned so far. Points are
distributed per problem.
Part 1 Average Income by State
The following is an excerpt of data collected by the financial website dqydj.com 1.
State Average Individual

Income in 2020
Alabama $54,813.68
Alaska $58,920.08
Arizona $57,407.70
Arkansas $55,897.80
California $66,461.85
Colorado $67,241,75
Connecticut $72,776.72
Delaware $59,517.97
Florida $57,369.16
Georgia $56,713.19
Hawaii $57,290.63
Idaho $57,290.63
Illinois $66,554.70
Indiana $55,290.18
Iowa $51,783.06
1. (3 pt) Is the Average Individual Income Categorical or Quantitative data? Why? Explain your
answer clearly.
1
https://dqydj.com/average-income-by-state-median-top-percentiles/
2. In the U.S., average individual income in 2019 was $62,518.132.
a. (2 pt) How many of the states shown have an average individual income less than the
U.S. average? What percent of all the data shown does this represent?
b. (3 pt) Out of the states shown whose average individual income is less than the U.S.
average, what percent of them are states whose name begins with the letter A?
c. (3 pt) Out of all the states whose name begins with the letter A, what percent of them
have an average individual income less than the U.S. average? (This is NOT the same
question as above!)
Part 2 Yes or No?
For this part of the project, you will conducting a survey on a yes or no question of your choosing. You
are going to collect information from 20 different people. For each person, you will ask gender and your
yes or no question. From there, you will perform some statistical analysis and answer questions on the
data.
Choose a yes or no question that is fun and interesting for you. Some examples:
 Are you a fan of the Arizona Diamondbacks?

 Do you like Star Trek: Voyager?
 Have you ever had surgery?
Question you will be asking (1 pt) _______________________________________________
For each person, ask two questions:

2
https://dqydj.com/average-income-by-state-median-top-percentiles/
1. What is your gender? (male, female, or other/no response)
2. Your question? (yes or no)
Record the responses on a separate sheet of paper, and then enter it into Excel. In column A, number 1
– 20. In column B, record the gender of person 1, then the gender of person 2, etc. In column 3, record
each person’s response – yes or no – to the question. (Do not put these results in this document.) You
will submit this Excel file with your project.
Answer the following questions with complete sentences. Review the definitions of population,
sample, and sample statistic.
1. (3 pt) What is the population that is being studied?
2. (3 pt)What is the sample that is taken?
3. (4 pt) What sampling method was used to collect the data. Choose from the sampling methods
described in your text and explain why it is this type of sampling. (Hint: You probably did not
use Simple Random Sampling.)
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.
Your question here:_________________________________?
Response Frequency
Yes
No
(3 pt)
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. (4 pt)
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.
Your question here:_________________________________?
Yes No (3 pt)
Male
Female
Other/NA
Based on the two-way table, answer these questions with complete sentences. Type out your
calculations as well (for example: 9/15 *100% = 60%), so that your work can be check for partial credit if
your answer is incorrect.
1. (2 pt) What percent of all responses were yes?
2. (4 pt) If you repeated this experiment with 20 different people, would you get the same percent
of yes responses? Why or why not?
3. (3 pt)What percent of all male responses were yes? (out of the male responses, what percent
were yes?)
4. (3 pt) 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. (3 pt) What percent of all yes responses were female? (out of the yes responses, what percent
were female?)
6. (3 pt) Suppose that your population had 15,000 people who said yes to your question. Based on
the statistic that you collected above, what number of those people would be female?
Part 3
Suppose that in part 2, I asked you to use cluster sampling with any sample size of 20 or greater.
Describe how you would get the survey information using cluster sampling. (Give the full details of your
data collection –where you would go, which cluster you would use, etc.) You do NOT need to actually
collect data this way, merely describe how you would. (10 pt)

Math 106 Project 2 Collecting and Analyzing Data Pts

Uploaded by

Copyright:

Available Formats

Math 106 Project 2 Collecting and Analyzing Data Pts

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Math 106 Project 2 Collecting and Analyzing Data Pts

Uploaded by

Copyright:

Available Formats

Project 2: Collecting and Analyzing Data

All questions must be answered in complete sentences.

Part 1 Average Income by State

The following is an excerpt of data collected by the financial website dqydj.com 1.

State Average Individual

Part 2 Yes or No?

 Are you a fan of the Arizona Diamondbacks?

Question you will be asking (1 pt) _______________________________________________

For each person, ask two questions:

1. (3 pt) What is the population that is being studied?

2. (3 pt)What is the sample that is taken?

Your question here:_________________________________?

Your question here:_________________________________?

1. (2 pt) What percent of all responses were yes?

You might also like