Purchase Solution

Three Quantitative Problems: Frequency distributions

Not what you're looking for?

Ask Custom Question

A. Develop a frequency distribution using classes of 12-14, 15-17, 18-20, 21-23, and 24-26.
B. Develop a relative frequency distribution and a percent frequency distribution using the classes in part (a)

Mendelsohn Media Research provided survey data on the annual amount of household purchases by families with an annual income of $75,000 or more (Money, 2001). Assume that the following data from a sample of 25 households show the dollars spent in the past year on books and magazines. Please see the excel attachment.

A. Construct a frequency distribution and relative frequency distribution for the data.
B. Provide a histogram. Comment on the shape of the distribution.
C. Comment on the annual spending on books and magazines for families in the sample.

The Nielsen Home Technology Report provided information about home technology and its usage by persons age 12 and older. The following data are the hours of personal computer usage during one week for a sample of 50 person. Please see excel attachment.

Summarize the data by constructive the following:
A. A frequency distribution (use a class width of 3 hours)
B. A relative frequency distribution
C. A histogram
D. An ogive
E. Comment on what the data indicate about personal computer usage at home.

These problem needs to be done in Excel what the instructions says.

See attached file for full problem description.

Purchase this Solution

Solution Summary

The solution develops frequency distributions and analysis for them in three different questions.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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