Reference no: EM13991929

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.