Question

Use EXCEL

1. Construct Distribution:
   1. For each variable, construct Empirical distribution: Frequency Distribution and Relative Frequency Distribution (and if warranted, construct Cumulative Relative Distribution.)
   2. Apply a meaningful chart type to present each of the Relative Frequency Distribution (and Cum. Rel. Freq.) calculated in part “a”. (Freq. Dist. Plot is not necessary).

	Savings	Months Employed	Age	Housing	Credit Risk
1	$739	12	23	Own	Low
2	$1,230	0	32	Own	High
3	$389	119	38	Own	High
4	$347	14	36	Own	High
5	$4,754	45	31	Rent	Low
6	$0	13	25	Own	Low
7	$229	16	26	Own	Low
8	$533	2	27	Own	Low
9	$493	9	25	Own	High
10	$0	4	43	Own	High
11	$989	0	32	Rent	High
12	$3,305	15	34	Rent	Low
13	$578	14	26	Own	Low
14	$821	63	44	Own	High
15	$228	26	46	Own	Low
16	$129	8	39	Own	Low
17	$732	4	25	Own	High
18	$683	33	31	Own	Low
19	$0	116	47	Own	Low
20	$12,348	2	23	Rent	High

Answer 1

1. For each variable, construct Empirical distribution: Frequency Distribution and Relative Frequency Distribution (and if warranted, construct Cumulative Relative Distribution.)

For Savings:

	Savings						cumulative
lower		upper	midpoint	width	frequency	percent	frequency	percent
0	<	2,000	1,000	2,000	17	85.0	17	85.0
2,000	<	4,000	3,000	2,000	1	5.0	18	90.0
4,000	<	6,000	5,000	2,000	1	5.0	19	95.0
6,000	<	8,000	7,000	2,000	0	0.0	19	95.0
8,000	<	10,000	9,000	2,000	0	0.0	19	95.0
10,000	<	12,000	11,000	2,000	0	0.0	19	95.0
12,000	<	14,000	13,000	2,000	1	5.0	20	100.0
					20	100.0

For Months Employed:

	Months Employed						cumulative
lower		upper	midpoint	width	frequency	percent	frequency	percent
0	<	20	10	20	14	70.0	14	70.0
20	<	40	30	20	2	10.0	16	80.0
40	<	60	50	20	1	5.0	17	85.0
60	<	80	70	20	1	5.0	18	90.0
80	<	100	90	20	0	0.0	18	90.0
100	<	120	110	20	2	10.0	20	100.0
					20	100.0

For Age:

	Age						cumulative
lower		upper	midpoint	width	frequency	percent	frequency	percent
20	<	25	23	5	2	10.0	2	10.0
25	<	30	28	5	6	30.0	8	40.0
30	<	35	33	5	5	25.0	13	65.0
35	<	40	38	5	3	15.0	16	80.0
40	<	45	43	5	2	10.0	18	90.0
45	<	50	47	5	2	10.0	20	100.0
					20	100.0

For Housing:

Housing
	frequency	percent
Own	16	80.0
Rent	4	20.0
	20	100.0

For Credit Risk:

Credit Risk
	frequency	percent
Low	11	55.0
High	9	45.0
	20	100.0

1. Apply a meaningful chart type to present each of the Relative Frequency Distribution (and Cum. Rel. Freq.) calculated in part “a”. (Freq. Dist. Plot is not necessary).

For Savings:

For Months Employed:

For Age:

For Housing:

For Credit Risk: