Question

1. Presented below is a portion of the data for 400 respondents which were used to construct the graph presented in Chart 1 (Please use Excel or SPSS to generate this Chart). What is another type of graph that you can use to display this information (Please try to use Histogram to report frequencies; You can try to draw Histogram in Excel and paste your Histogram in the Word file, or convert it as the PDF file). Construct this graph using the data below with the frequencies placed along the vertical axis (15 pts in table; 5 pts drawing the Histogram):

Age at First Marriage	Percent (%)	Frequencies (N=400)
20	15.00	400*15%=60
21	23.00	?
22	19.00	?
23	17.80	?
24	10.60	?
25	7.60	?
26	4.00	?
27	3.00	?

Chart 1: Histogram for Age at First Marriage (Percent

2.Considering the information in table above, what would happen to the percentage of respondents age 22 if we simply dropped all respondents who were first married at age 20 from the sample?

3.Considering the information in table above, what proportion of respondents were first married at the ages of 24 and 26 (5 pts)?

Answer 1

The data value for frequencies are,

Age at First Marriage	Percent (%)	Frequencies
20	15	60
21	23	92
22	19	76
23	17.8	71.2
24	10.6	42.4
25	7.6	30.4
26	4	16
27	3	12

The histogram for the frequencies of age at first marriage is obtained in excel by following these steps,

Step 1: Write the data values in excel.The screenshot is shown below,

Step 2: Make a column "bin" with class width of 20,

bin

10

30

46

62

78

94

Step 3: DATA > Data Analysis > Histogram > OK. The screenshot is shown below,

Step 3: Insert Input Range: 'frequencies' column, Bin Range: bin column then OK. The screenshot is shown below,

The frequencies are obtained.

bin	Frequency
10	0
30	2
46	2
62	1
78	2
94	1
More	0

Step 4: Select bin and Frequency column then INSERT > Recommended Charts > Clustered column. The screenshot is shown below,

2)

if we dropped all respondents who were first married at age 20 from the sample, the total frequency will be 340. Now the percent for each age group is obtained by dividing the frequency by total frequency and multiply by 100.

Age at First Marriage	Frequencies (N=340)	Percent (%)
21	92	27.06
22	76	22.35
23	71.2	20.94
24	42.4	12.47
25	30.4	8.94
26	16	4.71
27	12	3.53

We can see the the percent for age 22 is increased from 19% to 22.35%.

3)

The percent respondents who were first married at the ages of 24 and 26 is obtained by adding the percentage for both the age,i.e.