Showing detailed work and writing detailed explanations is required. I reserve the right to subtract points if I cannot see how you arrived at your answer even if your answer is correct. I reserve the right to subtract points if you do not write responses in complete, coherent, and grammatically correct sentences.
This quiz does not require any hand computations. You will need to use both word and excel to complete this quiz.
Companies planning to introduce a new product in the market must define the "target" for the product. Age and gender are two of the most important important demographic variables. The following two-way describes the age and marital status of American women in 1999. The table's entries are in thousands of women.
|
Age (Years)
|
Never Married
|
Married
|
Widowed
|
Divorced
|
Total
|
|
10 to 24
|
10,240
|
2,598
|
9
|
184
|
13,031
|
|
25 to 39
|
7,640
|
20,129
|
193
|
2,930
|
30,891
|
|
40 to 64
|
3,234
|
28,923
|
2,357
|
6,764
|
41,278
|
|
Over 65
|
751
|
8,270
|
8,385
|
1,263
|
18,667
|
|
Total
|
21,865
|
59,918
|
10,944
|
11,141
|
103,867
|
• Compute the marginal distribution of marital status for all adult women (use percents). Use excel to create a bar chart to display this distribution.
• Insert this graph into Word and discuss it.
• Compare the conditional distributions of marital status for women aged 18 to 24 and women ages 40 to 64. Discuss the most important difference between the two age groups.
• Your company is planning a magazine aimed at women who have never been married. Find the conditional distribution of age among never-married women and display it in a bar graph. Insert this graph into word. Discuss what age group or groups you would suggest to your magazine to target.