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.
The solution develops frequency distributions and analysis for them in three different questions.