Purchase Solution

Statistics: sampling ages of moviegoers

Not what you're looking for?

Ask Custom Question

The file HP.xls contains the ages of 48 moviegoers to a recent showing of a Harry Potter movie.The following two methods illustrate in different ways how you might select a random sample of eight moviegoers' ages. In each case use the initial order of the files ages as the starting point, so that the first person in the list is 32 years old and the 48th person is 21.

a. Start in row 18 of Table E.1., and reading across, use the table to pick the sample of eight ages. So if your random number was '48' the age would be '21'. Pick your sample without replacement.

b. In this part you are to use Excel to generate random numbers. Picking eight out of 48 is pretty trivial, but imagine picking 1,200 out of 50,000. You are to use the RANDBETWEEN function.

i) Start again with a worksheet that has the original 48 moviegoers in the original
starting order of the file and label that worksheet tab 'Original'.

ii) Next, open up a new worksheet tab and use the RANDBETWEEN function to pick 48 values from 1 to 400 in Column A. Label this worksheet tab 'Random'.

iii) Now be careful. You are to select those 48 random values and, in Column C, choose the Paste Special option and choose the Values option and then paste. The original column of random numbers should be different now! Finally copy the random numbers from column C back to column C of the Original worksheet.

What is gained from all this? Say you wanted to select a sample of eight as in (a). You could now sort on your random numbers and pick, say, the lowest eight.

Attachments
Purchase this Solution
Solution Preview

See the Excel file attached.

The file HP.xls contains the ages of 48 moviegoers to a recent showing of a Harry Potter movie.The following two methods illustrate in different ways how you might select a random sample of eight moviegoers' ages. In each case use the initial order of the files ages as the starting point, so that the first person in the list is 32 years old and the 48th person is 21.
a. Start in row 18 of Table E.1., and reading across, use the table to pick the sample of eight ages. So if your random number was 48 the age would be 21. Pick your sample without replacement.

Note: there are several methods of using a random number table. I'm using the method here:http://www.evaluationwiki.org/index.php/How_to_Use_a_Random_Number_Table. I'm looking at the last two digits of each group of number and I'm choosing the ones that are between 1 and ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Population of a Subway Car Statistics Problem

    56953 Population of a Subway Car Statistics Problem 2. The ages of a group of people in a subway car are: 5, 7, 12, 21, 29, 30, 33, 46, 52, and 83. Consider this to be your population. Find µ.

  • Probability : Sampling

    39051 Probability : Sampling In a recent survey of 1282 moviegoers, 712 said they prefer butter on their popcorn while the rest did not.

  • Identifying Sample and Populations

    Survey responses of "Best", "Better", "Good", "Poor" c. Ages of high school teachers d.Subjects in which university students major Section 1.3: Identify the sampling techniques.

  • Discussion questions

    This is your "Sampling Design." Which of the four sampling techniques best describes your design? d. Explain in moderate detail the method you used to gather your data. In statistics this venture is called the "Methodology." e.

  • Measures of Central Tendency

    This is your "Sampling Design." Which of the four sampling techniques best describes your design? d.Explain in moderate detail the method you used to gather your data. In statistics this venture is called the "Methodology." d.

  • Measuring Central Tendency

    Make sure you break your sample into classes or groups, such as: males/females or ages or time of day, etc.

  • This post addresses the Mid-Atlantic Cinema economics case.

    Historically, Mid-Atlantic has found that 50 percent of all moviegoers buy a $5 cup of buttered popcorn.

  • Sampling distribution

    135631 Sampling distribution Suppose Stat I students ages follow a skewed right distribution with a mean of 24 years old and a standard deviation of 2 years old.

  • Critiquing Sampling Strategy and Sample Size in a Research

    Therefore, the population of a limited group of an entire population, which consisted of children between the ages of 12.5-18 years of age, were chosen for the population sample.

View More Related Solutions