OBJECTIVES: Identify components of a sample survey Excel Basics To learn how to enter data, as well as format cells, columns, and tables in Excel

OBJECTIVES:

• Identify components of a sample survey
• Excel Basics
  • To learn how to enter data, as well as format cells, columns, and tables in Excel.
  • To learn how to use Excel Formulas.
  • To learn how to ‘auto fill’ formulas across rows and/or down columns.

A Sample Survey:

The Gallup Organization (www.gallup.com) provides data on all aspects of the attitudes and lifestyles of people around the world. Gallup is just one of many organizations who try to determine what the public is thinking by conducting scientific polls. Try to find a report at Gallup that interest you and lists as much information as possible.

1. What is the title and source of the report you found?

2. For the report you found of a poll, answer all the questions below that are addressed in your article. The report you find must provide answers to at least five of these.

1. Who carried out the survey?

2. What was the population of interest? What in the article indicated this as a population of interest

3. How was the sample selected?

1. 4. How large was the sample?
2. 5. How were the subjects contacted?

6. When was the survey conducted?

7. What were the exact questions asked?

3. Carefully describe the parameter of interest in the poll you found.

4. Did any of the questions above help you find a source of bias in the conclusions of the report?
5. Do any of the questions above that were not addressed in the article give you concern about other potential sources of bias in the conclusions of the report? Explain.