Need by Sunday @ 7:30pm EST Data Collection and Nielsen Ratings

Sheet 1

	Topic I: Data Collection
(8 points)	Q1: In your OWN WORDS, define the following sampling techniques. Your definitions need to clearly show the differences between each approach.
	Random Sampling
	ANSWER HERE
	Systematic Random Sampling
	ANSWER HERE
	Multi-Stage Cluster Sampling
	ANSWER HERE
	Stratified Sampling
	ANSWER HERE
(5 points)	Q2: Suppose I work for a retail company and I'm interested in doing a statistical study on our target market.
	One variable I'm interested in is customer age, and unknown to me the average age of ALL my customers is 34 years old.
	However, when I do my study I randomly sample 50,000 customers and the average age is 32 years old.
	The difference between these two amounts is due to sampling error.
	Do you think this difference is significant? Why or why not? What's one way you could reduce the sampling error?
	ANSWER HERE
(5 points)	Q3: One way data is collected is through the use of a radio/TV diary. Those who participate are asked to fill out the
	diary CORRECTLY for a specified period of time. Unfortunately there is a lot of response error with this data collection method.
	Consider the following radio diary submission and locate ALL FIVE MISTAKES. When looking for response error consider
	the fact that the last row contains a perfect entry.
	Mistake #1:	ANSWER HERE
	Mistake #2:	ANSWER HERE
	Mistake #3:	ANSWER HERE
	Mistake #4:	ANSWER HERE
	Mistake #5:	ANSWER HERE
(7 points)	Q4: Customer reviews are notorious for having non-response error since it's completely optional. This can be seen
	on sites such as Amazon or Netflix where you have to rate a product on a five-star scale. Since it's not required to rate
	the product you normally see reviews from people who either really liked it or really hated it.
	Select a product review that you believe shows non-response error. The review must use a five-star scale and
	you must provide a link that shows me the overall rating along with the individual scores (see below for an example).
	In at least five sentences, explain why you believe non-response error exists for the product you selected.
	Example of information I need:
	ANSWER HERE
(15 points)	Q5: Let's assume I ask some random participants how many hours of TV they watch in a typical week.
	I record the data on a piece of paper by writing the responses by hand. Here are the results:
	TABLE 1
	ID	# of Hours
	1	5
	2	10
	3	2.5
	4	0
	5	21.3
	6	28
	7	15
	8	15.5
	9	7
	10	0
	This data is originally on paper, but I need to put this data into an Excel spreadsheet. Here's what it looks like in Excel:
	TABLE 2
	ID	# of Hours
	1	5
	2	10
	3	25
	4	0
	5	2.13
	6	28
	7	15
	8	155
	9	7
	10	0
	Notice that I made some processing errors. This can be due to a variety of reasons. Perhaps my handwriting was poor and
	I couldn't read the numbers correctly. Or maybe I was in a hurry and was going too fast when using Excel. At any rate,
	my statistics will be affected.
	Please calculate the statistics for both tables and compare. Based on your understanding of these statistics, why did
	processing error significantly impact some measures while leaving others practically the same?
	(Hint: For this last part you'll need to describe their individual formulas, which are discussed in the statistics video review.)
	TABLE 1:			TABLE 2:
	Mean:	ANSWER		Mean:	ANSWER
	Median:	ANSWER		Median:	ANSWER
	Mode:	ANSWER		Mode:	ANSWER
	Std Deviation:	ANSWER		Std Deviation:	ANSWER
	ANSWER HERE
	Topic 2: Nielsen Data
	Please use the following charts when answering Questions 6-10. They cover the top ten shows for both broadcast and cable networks.
(5 points)	Q6: When looking at the first chart (broadcast networks), how many viewers watched The Oscars? (Ignore the red carpet events.)
	ANSWER HERE
(7 points)	Q7: Select one of the shows on either list and provide the rating. What does this percentage represent? How is it different than a share?
	ANSWER HERE
(7 points)	Q8: Which broadcast network (NBC, CBS, etc.) seems to be the most successful? Least successful?
	(Please provide at least five sentences to explain your reasoning.)
	ANSWER HERE
(7 points)	Q9: Why are the ratings for cable networks typically lower than the ratings for broadcast networks?
	(Please provide at least five sentences.)
	ANSWER HERE
(7 points)	Q10: Looking at the chart for cable networks, you'll notice that WWE Raw appears three times on the list. How is this possible?
	(Hint: Find out when this specific show is on TV and consider the show length.)
	ANSWER HERE
	Please use the following chart in order to answer Questions 11 and 12. This Top 10 list looks at TV shows and their Twitter metrics.
(4 points)	Q11: There are four numerical measures in the chart, each one measuring the success of a TV show and its Twitter presence.
	However, the Top 10 list is sorted by which of the four variables?
	ANSWER HERE
(4 points)	Q12: Identify the top show according to the following measures:
	Unique Aud:	ANSWER
	Impressions:	ANSWER
	Unique Authors:	ANSWER
	Tweets:	ANSWER
	Please use the following chart in order to answer Questions 13 and 14. This last chart looks at top global web parent companies
	by considering some of the metrics on their websites.
(12 points)	Q13: Select three of the sites on the list and explain why you would expect a lot of traffic for each one.
	(Please provide at least a couple of sentences for each.)
	Choice #1:	ANSWER
	Explanation:
	ANSWER HERE
	Choice #2:	ANSWER
	Explanation:
	ANSWER HERE
	Choice #3:	ANSWER
	Explanation:
	ANSWER HERE
(7 points)	Q14: Although it's not given directly on this chart, it's possible to calculate the total number of global internet users. What is this amount?
	Hint: You will need to select a row (doesn't matter which one) and perform a quick calculation using unique audience and active reach.
	Hint #2: Don't try to Google the answer. I'm looking for a specific value that's unique to this chart.
	ANSWER HERE

This week's assignment is going to look at two different topics: data collection and Nielsen ratings. Data Collection When collecting data you have to be careful because you are making assumptions about the population by considering a sample of information. As a result you're sampling approach needs to be well-thought-out. There are many ways to collect a sample and you have to be on the lookout for different sources of error. Nielsen Ratings Ratings are determined by many companies but the most reputable has to be Nielsen. They measure data across multiple platforms (TV, online, mobile, etc.) and companies pay a lot of money for the results. The information we have access to is limited because it's free, but you can find a lot of data on Nielsen.com. Please read each question carefully and provide your answers in the specified cells.